Issue 90108

Summary: Invalid references on Z* columns when import MS Excel 2003 XML file
Product: Calc Reporter: vladmazan <vladmazan>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CLOSED DUPLICATE QA Contact:
Severity: Trivial    
Priority: P3 CC: damjan, issues, knmc, rb.henschel
Version: OOo 3.0 Beta   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.2.0-dev
Developer Difficulty: ---
Attachments:
Description Flags
Cell AA1 containt =Z1+Z2 but opened as =A1+A2 none

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
Comment 6 damjan 2023-01-11 18:32:26 UTC 
This is fixed by my patch to bug 81233, so marking it a duplicate of that bug.

Thank you for your bug report and sample document :-).

*** This issue has been marked as a duplicate of issue 81233 ***