Bug 70316 - FORMATTING: Incorrect default value for decimals
Summary: FORMATTING: Incorrect default value for decimals
Status: RESOLVED DUPLICATE of bug 44399
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2013-10-09 11:35 UTC by Jonas Müller
Modified: 2013-10-09 12:59 UTC (History)
0 users

See Also:
Crash report or crash signature:

ODS file showing the problem (7.27 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-10-09 11:35 UTC, Jonas Müller

Note You need to log in before you can comment on or make changes to this bug.
Description Jonas Müller 2013-10-09 11:35:23 UTC
Created attachment 87332 [details]
ODS file showing the problem

LibreOffice Calc has incorrect default values for decimals making it quite strange if you want to have no decimals:

Steps to reproduce:

1. Open Example.ods
2. Go in cell C3 and go into the menu to format the cell ("Zellen formatieren")
3. As you can see the field for "decimals" is already on 0.
4. As everything is how you want it to be, close the dialogue by clicking on ether OK or cancel.


The cell still has decimals

Expected results:

The cell shouldn't have decimals as the value "decimals" is on 0.

In order the really have no decimals you have to enter "0" again into the decimals or delete the existing 0 to have it replaced by a new 0.
Comment 1 ign_christian 2013-10-09 12:59:43 UTC
I think it's a long standing issue with "General" or "Standard" format.

*** This bug has been marked as a duplicate of bug 44399 ***