Issue 113995 - Formulae results in .xls format spreadsheets saved as zero
Summary: Formulae results in .xls format spreadsheets saved as zero
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 3.2
Hardware: All Linux, all
: P3 Trivial with 7 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-08-19 17:04 UTC by els59
Modified: 2013-01-29 21:51 UTC (History)
2 users (show)

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

File with some linked cells saved as zero (468.50 KB, application/
2010-08-19 17:05 UTC, els59
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description els59 2010-08-19 17:04:22 UTC
It appears that cells containing formulae that reference other cells are 
sometimes stored as zero when saved in Microsoft Excel 97/2000/XP (.xls) 
format.  For example, if I open the affected file in Microsoft Excel Viewer the 
cells display zero instead of the correct result.  I'm afraid I've not worked 
out how to reproduce this but it has happened to me on a number of occasions.  
If I make some kind of trivial change (again I haven't worked out what triggers 
it) and save it again, it fixes itself.

If it's of help - when searching for this in the issue tracker I came across 
issue 9895 which appears to be the same problem but was apparently fixed 
several years ago...?

I will attach a file called cells_links_broken.xls that is currently exhibiting 
this problem.  An example affected cell is _Optics.A42.  It does seem that it 
happens to cells that are merged together, but this could be coincidence.

Thanks a lot,
Comment 1 els59 2010-08-19 17:05:51 UTC
Created attachment 71200 [details]
File with some linked cells saved as zero
Comment 2 t_only_ttt 2010-09-15 11:04:39 UTC
*** Issue 113995 has been confirmed by votes. ***