Issue 115812 - Wrong formulas when saving spreadsheet in Excel 2003 XML format
Summary: Wrong formulas when saving spreadsheet in Excel 2003 XML format
Status: CLOSED DUPLICATE of issue 94261
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: recent-trunk
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2010-11-28 04:35 UTC by ydubinsky
Modified: 2010-11-28 19:48 UTC (History)
2 users (show)

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

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