To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=95045
------- Additional comments from jmich...@openoffice.org Tue May 18 09:42:44
+0000 2010 -------
there is one more issue related to this bug that I just found with 3.2.0 with
regards to importing MS Excel 2003 xml files:
problem #4: excel uses ! instead of the OOo's . after the sheet name.
this is wrong.
problem #5. when importing Excel 2003 XML files, cross-sheet references are
imported wrong as Err:509 when they contain a space. this is a special case
that is being handled wrong where single quotes are used to handle the special
case of having the space, for example, in Excel, the standard reference should
be ='this sheet name has spaces'!A1 but in OOo this gets converted to ='this
sheet name has spaces'A1, but in OOo a valid reference is =Restaurant.A1 or
='this sheet name has spaces'.A1 when you type in or click in an address.
but in excel =Sheet1!A1 or Sheet1!R1C1 (latter is useful for XML files if you
want absolute cell references) is a valid cell reference. until you get into
xml files. then things get dicey. A1 type references are not valid in Excel
2003 XML files. only R C and RC references are valid in Excel 2003 XML files.
and they are very messy unless you are doing absolute references.
programmatically RC (for example, R1C1 or R208C31 is VERY convenient for doing
file exports if you are doing absolute references - it's as easy as doing a
printf with the row and column number.
after entering a correct spreadsheet into OOo with simple cross-sheet
references, OOo outputs as Excel 2003 XML the following incorrect format (herein
called the "cross-sheet references" example"):
<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>
problem #6. excel usesthe formula format =formula while OOo uses of:=[formula]
this is wrong.
see example above. here is another example.
<Cell ss:Formula="of:=[Sheet1.C1]+12*[Sheet1.D2]"><Data
ss:Type="Number">26</Data></Cell>
and I take something back that I said in the last post. in a simple xml file
where the data is clustered together, OOo generated more than 299 "Index"
entries for a total of 4 formula entries across 3 sheets, all on rows 1 and
maybe 2. this is REALLY out of control. I don't know what is causing this.
please fix. thanks.
---------------------------------------------------------------------
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
