Issue 111627 - Numbers in cells have unusable default format
Summary: Numbers in cells have unusable default format
Status: CLOSED DUPLICATE of issue 26826
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: OOo 3.2
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2010-05-15 16:02 UTC by 10110111
Modified: 2010-05-15 16:17 UTC (History)
2 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description 10110111 2010-05-15 16:02:54 UTC 
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.
Comment 1 Regina Henschel 2010-05-15 16:17:13 UTC 
The view for standard format will be enhanced in OOo 3.3, see issue 26826.

*** This issue has been marked as a duplicate of 26826 ***
Comment 2 Regina Henschel 2010-05-15 16:17:47 UTC 
closing, duplicate