Apache OpenOffice (AOO) Bugzilla – Issue 81233
spreadsheetml: Trouble with import from XML (format MS Excel 2003) to OpenOffice Calc
Last modified: 2013-08-07 15:12:27 UTC
Hello (I am from Russia, sorry for my bad English)! I have trouble with import from XML (format MS Excel 2003) to OpenOffice Calc. See example (some information from XML code): ************* I have 2 formulas with relative position: R[-1]C. If I open its by MS Excel, I see that formulas have absolute positions: Y5 and Z5 - It’s correct. If I open its by OpenOffice, I see that formulas have absolute positions: Y5 and A5 - It’s WRONG! (OpenOffie skipped column Z when translating relative position to absolute position). ************* I have trouble with column Z, when I using relative position into XML. With other columns I haven’t trouble.
Created attachment 47930 [details] simple example
Not a P1 Issue lowered to P4
Hi Swante, seems to be yours. Frank
Thanks for the issue, rolik. Nevertheless I really need help on this Excel 2003 XML / spreadsheetml filter, as there are I am distracted by many other projects and see no possibility to fix this in the short distance..
Is there any resolution for this issue.
In http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=33060 we found a possible solution for OOo version 3.2.1 (OOO320m18, build 9502) by applying two changes in "C:\Program Files\OpenOffice.org 3 \Basis\share\xslt\import\spreadsheetml\spreadsheetml2ooo.xsl" Replace "floor( $column-number div 26 )" by "floor( ($column-number - 1) div 26 )" and "$column-number mod 26" by "($column-number - 1) mod 26 + 1" With these changes, the problem seems to have disappeared.
Hi That post was raised by me. The solution is fine and as suggested would work uptill 702 column number only. would this be taken up in the next release or a next patch ?
The original code has the same limitation to 702 columns. But the MS Excel 2003 XML format is limited to 256 columns so that should be no problem.
But i did not find that limitation. Used MS office 2007 to open the xml files did not find any limitation