Apache OpenOffice (AOO) Bugzilla – Issue 38741
Excel drops decimals to fit the column. SO does not.
Last modified: 2013-08-07 15:12:27 UTC
Attached test version of a customer spreadsheet. see numbers gradually increasing in length with 2 decimal places. Excel (2002), as the number (displayed in General format) gets longer, starts to drop decimal places so that it is still displayed in the column width. The result is that if you open the spreadsheet, in Excel it looks good, in StarOffice there are a number of displayed. Tested on WinXP with StarOffice 7 PP4 and StarOffice 8 m65
Created attachment 20317 [details] testdoc
Work on this is tracked in issue 46511 now. *** This issue has been marked as a duplicate of 46511 ***
duplicate -> closed