Issue 66258

Summary: Formulas not saved well in Excel 2003 XML file
Product: Calc Reporter: christophe_d <cdebussche>
Component: save-exportAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, jmichae3
Version: OOo 2.0.3   
Target Milestone: ---   
Hardware: All   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
File with bugs none

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.