Apache OpenOffice (AOO) Bugzilla – Issue 8184
save as MS excel gives formula errors when opened in excel
Last modified: 2004-10-22 12:27:47 UTC
Hi- I have a spreadsheet document with a few simple formulas. When I use "save as microsoft excel" the formulas have errors when the document is opened in excel. The excel cell has the error #VALUE. If I then go to edit the forumla, make no changes, then hit enter, the value is calculated correctly. I get the same error if I save as excel 5.0 or 2000. -Randy
Created attachment 3101 [details] calc document saved as MS excel 2000
Created attachment 3102 [details] calc document saved as MS excel 2000
Known issue. You can work-around this by deleting the parentheses around single cell references, i.e.: =$B$2*$B$2/(2*1,8*B4*1000) instead of =($B$2)*($B$2)/(2*1,8*B4*1000) *** This issue has been marked as a duplicate of 3724 ***
Duplicate
fixed in OOo 2.0