Issue 115812

Summary:	Wrong formulas when saving spreadsheet in Excel 2003 XML format
Product:	Calc	Reporter:	ydubinsky <ydubinsky>
Component:	code	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues, rb.henschel
Version:	recent-trunk	Keywords:	oooqa
Target Milestone:	---
Hardware:	Unknown
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description ydubinsky 2010-11-28 04:35:31 UTC

Probably this issue is similar to 66258 (Formulas not saved well in Excel 2003 
XML file) and few others. 
 when I save a simple sheet with the simple formula =SUM(A2:A5) the formula is 
saved as "of:]=SUM([.A2:.A5])" that is weird. (Linux and Windows) 
And another simple formula "=A3+B6" is written as
"of:]=[.A3]+[.B6]" 
i think that Excel 2003 xml is an useful option to generate a file with pretty complicated spreadsheet data inside and if OO supports it the support should be a 
real one. 
In many cases Calc is crashing or stops to respond when saving as 2003 xml file.

Comment 1 Regina Henschel 2010-11-28 19:48:11 UTC

duplicate to issue 94261.

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

Comment 2 Regina Henschel 2010-11-28 19:48:48 UTC

closing, duplicate.