To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111627 Issue #|111627 Summary|Numbers in cells have unusable default format Component|Spreadsheet Version|OOo 3.2 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|viewing Assigned to|spreadsheet Reported by|
------- Additional comments from [email protected] Sat May 15 15:02:54 +0000 2010 ------- If i enter e.g. 0.00001 into a cell in OO Calc, it will show this number as 0. But it's not zero! In fact, if i have several numbers so that they are ~10^-11, then i can't see anything but zeroes. So, i'm forced to use scientific or fixed precision format for each cell. One of the bad things of this is having some numbers look like 0.000100 instead of 0.0001. In M$ Excel the numbers get the default format which IS readable, i.e. if i enter 0.00001, it's showed as "0.00001", and if i enter something like 0.00000000001, it's automatically showed as "1E-11", and non-zero number is never shown as zero. --------------------------------------------------------------------- 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: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
