To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=111781
Issue #|111781
Summary|export excel 2003 xml incorrectly uses A1 cell referen
|ces instead of RC
Component|Spreadsheet
Version|OOo 3.2
Platform|PC
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|save-export
Assigned to|spreadsheet
Reported by|jmichae3
------- Additional comments from jmich...@openoffice.org Sun May 23 05:53:58
+0000 2010 -------
after entering a correct spreadsheet into OOo with simple cross-sheet
references (actually, ANY cell references), OOo outputs as Excel 2003 XML the
following incorrect A1 format:
<Row ss:Height="12.8376">
<Cell ss:StyleID="Normal" ss:Formula="of:=['this sheet name has
spaces'.A1]"><Data ss:Type="Number">1</Data></Cell>
<Cell ss:StyleID="Normal" ss:Formula="of:=[Sheet1.A1]"><Data
ss:Type="Number">1</Data></Cell>
</Row>
<Row ss:Height="12.8376"><Cell ss:Index="2" ss:StyleID="Normal"/></Row>
MS Excel outputs the following for the same spreadsheet:
<Row>
<Cell ss:Formula="='this sheet name has spaces'!RC"><Data
ss:Type="Number">1</Data></Cell>
<Cell ss:Formula="=Sheet1!RC[-1]"><Data ss:Type="Number">1</Data></Cell>
</Row>
The RC format Excel uses allows the format
'Sheet name'!R1C1 for sheet names with spaces if you are doing cross-sheet
references and want an absolute cell reference,
or,
SheetName!R1C1 if you are doing a sheet name without spaces and want an absolute
cell reference,
or,
R1C1 if you are referencing the same sheet and want an absolute cell reference.
The R1C1 absolute format is really handy for those who are doing the coding,
because everything is indexed with numbers. and Excel 2003 Accepts it just
fine, I tested the format. usually what you see coming OUT of Excel is pretty
weird for RC addressing. I don't know if that format is documented anywhere or
not as a standard.
example: R12305C121
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
