To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113995 Issue #|113995 Summary|Formulae results in .xls format spreadsheets saved as |zero Component|Spreadsheet Version|OOo 3.2 Platform|All URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|save-export Assigned to|spreadsheet Reported by|els59
------- Additional comments from el...@openoffice.org Thu Aug 19 16:04:22 +0000 2010 ------- 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, Emma --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
