Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||spreadsheetml: Trouble with import from XML (format MS Excel 2003) to OpenOffice Calc|
|Component:||open-import||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
Description rolik 2007-09-03 16:27:41 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.
Comment 2 frank 2007-09-03 20:25:56 UTC
Not a P1 Issue lowered to P4
Comment 3 frank 2007-09-04 08:34:31 UTC
Hi Swante, seems to be yours. Frank
Comment 4 svante.schubert 2007-09-04 10:41:31 UTC
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..
Comment 5 krishna_36 2010-08-08 06:07:19 UTC
Is there any resolution for this issue.
Comment 6 alex6684 2010-08-14 18:49:59 UTC
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.
Comment 7 krishna_36 2010-08-14 19:22:19 UTC
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 ?
Comment 8 alex6684 2010-08-14 20:10:32 UTC
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.
Comment 9 krishna_36 2010-08-14 20:12:53 UTC
But i did not find that limitation. Used MS office 2007 to open the xml files did not find any limitation