Issue 81233 - spreadsheetml: Trouble with import from XML (format MS Excel 2003) to OpenOffice Calc
Summary: spreadsheetml: Trouble with import from XML (format MS Excel 2003) to OpenOff...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.2.1
Hardware: PC All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needhelp
Depends on:
Blocks:
 
Reported: 2007-09-03 16:27 UTC by rolik
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
simple example (4.00 KB, text/xml)
2007-09-03 16:40 UTC, rolik 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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 1 rolik 2007-09-03 16:40:41 UTC 
Created attachment 47930 [details]
simple example
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