Issue 26941 - standard-format shows not enough digits after decimal point
Summary: standard-format shows not enough digits after decimal point
Status: CLOSED DUPLICATE of issue 22345
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1RC
Hardware: All All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
: 26939 (view as issue list)
Depends on:
Blocks:
 
Reported: 2004-03-24 18:48 UTC by norbert2
Modified: 2004-04-07 14:15 UTC (History)
1 user (show)

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

Attachments
standard-decimal-digits.png (39.75 KB, image/png)
2004-04-07 14:15 UTC, norbert2 		no flags Details
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 norbert2 2004-03-24 18:48:14 UTC 
If I enter for example "1.875" into a cell, "1.88" is displayed.

Excel displays "1.875", like I have entered it. Excel Standard-cell format shows
up to 9 digits after the decimal point, which suit good to the default cell-width.

Why don't you do so in Calc? For example in technical calculations, 2 digits
after decimal point are not enough.
In Calc I have to switch the number-format for many cells in order to have
enough digits after decimal point.

The way Excel handles this (up to 9 digits after decimal point) is much more
userfriendly.

Please fix this.
Comment 1 norbert2 2004-03-24 18:49:57 UTC 
An anwanted copy of this issue is 26941. Please delete issue 26939 and keep this
one.
Comment 2 norbert2 2004-03-24 18:51:06 UTC 
I meaned "unwanted" :-)
Comment 3 frank 2004-03-25 11:12:17 UTC 
Hi,

this is a double to Issue 22345. Please have a look at the specification
mentioned there.

Also it's possible change the default numberformat for a document by simply
editing the default cell style using the Stylist (F11). To do so for every new
document change this cellstyle and save the document as default template.

Also this is just a view of the values used in the cell and Calc is mainly used
in business environments, such companys are using mainly two decimals. Also the
calculation itself is done by using all places of the number except you have set
the option 'Precision as shown' under Tools-Options-Spreadsheet-Calculate.

Frank

*** This issue has been marked as a duplicate of 22345 ***
Comment 4 frank 2004-03-25 11:12:42 UTC 
closed double
Comment 5 frank 2004-03-25 11:13:43 UTC 
*** Issue 26939 has been marked as a duplicate of this issue. ***
Comment 6 norbert2 2004-03-28 12:05:49 UTC 
Frank:
I think with "business environments" you think abou calculating with money. But
in Excel the user has only to press the buttin with the currency-icon (german:
Eurozeichen) to get 2 digits after decimal point.

I think this is the smarter solution. Please re-consider to adopt this.
Comment 7 norbert2 2004-04-07 14:14:13 UTC 
I just found out, that the amount of digits after decimal point of the Standard-
format (german) can be changed in the settings. I have attached a screenshot.

So it's OK that this issue is closed. But in my oppinion you can change it 
from "DUPLICATE" to "INVALID".
Comment 8 norbert2 2004-04-07 14:15:04 UTC 
Created attachment 14381 [details]
standard-decimal-digits.png