Issue 90108 - Invalid references on Z* columns when import MS Excel 2003 XML file
Summary: Invalid references on Z* columns when import MS Excel 2003 XML file
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.0 Beta
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-05-29 13:11 UTC by vladmazan
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

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

Cell AA1 containt =Z1+Z2 but opened as =A1+A2 (2.55 KB, text/xml)
2008-05-29 13:15 UTC, vladmazan
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description vladmazan 2008-05-29 13:11:20 UTC
When open MS Excel 2003 XML file, if file have references on *Z* column (for
example Z1, AZ5, etc.) OOo change this references to A* column (Z1 -> A1, Z2 ->
A2, AZ3 -> A3, etc.) When open this file in MS Excel, references is good. There
are no differences, file was exported by OOo, or created by MS Excel.
Comment 1 vladmazan 2008-05-29 13:15:22 UTC
Created attachment 54055 [details]
Cell AA1 containt =Z1+Z2 but opened as =A1+A2
Comment 2 jm38706415 2008-07-07 03:27:10 UTC
Confimed this issue in Dev_DEV300_m21_winXP. 

The value of AA1 is A1+A2.
Comment 3 ooo 2008-07-14 13:41:29 UTC
@dr: the document has <Column ss:Span="25"/><Cell ss:Index="26"><Data
ss:Type="Number">1</Data></Cell><Cell ss:Formula="=RC[-1]+R[1]C[-1]">
It seems the formula cell is created with a wrong position not taking the
span/index into account.
Comment 4 Regina Henschel 2009-04-09 16:06:36 UTC
This seems similar to issue 81233.
Comment 5 daniel.rentz 2009-10-14 13:33:44 UTC
new target