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
Status: CLOSED DUPLICATE of issue 81233
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:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-05-29 13:11 UTC by vladmazan
Modified: 2023-01-12 20:36 UTC (History)
4 users (show)

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

Attachments
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
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 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 ***