Issue 66258 - Formulas not saved well in Excel 2003 XML file
Summary: Formulas not saved well in Excel 2003 XML file
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 2.0.3
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-06-08 22:22 UTC by christophe_d
Modified: 2016-09-14 05:30 UTC (History)
2 users (show)

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

Attachments
File with bugs (10.82 KB, application/vnd.sun.xml.calc)
2006-06-08 22:25 UTC, christophe_d 		no flags Details
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 christophe_d 2006-06-08 22:22:44 UTC 
Hello guys,

I tried to save a spreadsheet in the XML supported by Microsoft Excel 2003 and 
some totals are not calculated well if I reopen the file. (those totals were in 
a merged cell).

And I have some formatting problem, the borders are not the same anymore. If 
you want I can send you the file.

Cheers,
Christophe
Comment 1 christophe_d 2006-06-08 22:25:50 UTC 
Created attachment 37014 [details]
File with bugs
Comment 2 christophe_d 2006-06-08 22:27:37 UTC 
Just save the file in Excell 2003 XML. Close and open. Then compare the 
changes.
Comment 3 gercokees 2006-07-03 11:22:22 UTC 
I can confirm this behavour in 2.0.3
Probably something to do with the merged cells...

Changed the subject:
Formulas not saved well -> Formulas not saved well in Excel 2003 XML file
Comment 4 frank 2006-07-10 12:29:57 UTC 
Hi Swante,

one for you.

Frank
Comment 5 Martin Hollmichel 2007-11-09 16:52:19 UTC 
change target from 2.x to 3.x according to
http://wiki.services.openoffice.org/wiki/Target_3x
Comment 6 Jim Michaels 2016-09-14 05:28:01 UTC 
hmm. now aoo doesn't work with excel xml format files at all. just exits the program upon open or save as excel xml. nothing in eventvwr.exe to indicate a crash.
I hope the newer version does not have these problems.

also now, every time I start Calc it wants to go into recovery mode regardless of whether I saved the file before exiting or not.
Comment 7 Jim Michaels 2016-09-14 05:30:24 UTC 
that was for aoo 3.4.1 about the excel xml failures.