To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=98774
Issue #|98774
Summary|Import/Export from xml format
Component|Spreadsheet
Version|OOo 3.0.1
Platform|PC
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|open-import
Assigned to|spreadsheet
Reported by|cedgia
------- Additional comments from ced...@openoffice.org Tue Feb 3 08:40:23
+0000 2009 -------
I have created whit excel a sheet (italian version) and i save in xml format.
A B C
1 1 2 3
2 1 2 3
3 1 2 3
TOT 3 6 9
TOT is the sum of above line
When i open in openoffice 3.0.1 the sum(A1:A3) becomes =SUM(D3:D11])) with too
many "])"
Viceversa if I create the same file in openoffice and save it iin xml format,
when i open with excel, excel show this detailed error report:
Avviso foglio di calcolo XML in Tabella
MOTIVO: Valore errato
FILE: C:\cvvxvx.xml
GRUPPO: Row
TAG: Cell
ATTRIBUTO: Formula
VALORE: of:=SUM([.A1:.A3])
Avviso foglio di calcolo XML in Tabella
MOTIVO: Valore errato
FILE: C:\cvvxvx.xml
GRUPPO: Row
TAG: Cell
ATTRIBUTO: Formula
VALORE: of:=SUM([.B1:.B3])
Avviso foglio di calcolo XML in Tabella
MOTIVO: Valore errato
FILE: C:\cvvxvx.xml
GRUPPO: Row
TAG: Cell
ATTRIBUTO: Formula
VALORE: of:=SUM([.C1:.C3])
Sorry for my very bad english ;-(
Sergio
---------------------------------------------------------------------
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
