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

See Also:
Issue Type: ENHANCEMENT
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 norbert2 2004-03-24 18:48:04 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:52:23 UTC 
Please delete (close) this issue because its an unwanted copy of 26941 !!!
Comment 2 frank 2004-03-25 11:13:44 UTC 
double to 26941

*** This issue has been marked as a duplicate of 26941 ***
Comment 3 frank 2004-03-25 11:14:20 UTC 
closed double
Comment 4 norbert2 2004-03-28 17:18:58 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 5 norbert2 2004-04-07 18:35:03 UTC 
This issue is invalid, so please set it to "INVALID".

(Have a look at issue 26941)
Comment 6 frank 2004-04-08 08:27:53 UTC 
Hi Norbert,

it's intentionally marked as double and should hold this state. So nothing to
change.

Frank