Issue 36393 - incorrect default cell format setting
Summary: incorrect default cell format setting
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 1.0.3
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2004-10-30 23:33 UTC by briansavage
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description briansavage 2004-10-30 23:33:54 UTC
An integer entered into a cell defaults the cell to 'Number/General'

The format cell window shows this as having 0 decimal places but in fact it is
assuming 2 decimal places. To change to actually having 0 decimal places the
decimal places field must be increased then set back to 0.

To test enter two integers into cells then divide one into the other. The result
cell shows 2 decimal places but the format cells window shows as 0.

Minor problem but annoying when trying to make the spreadsheet look neat for
Comment 1 frank 2004-11-01 10:44:05 UTC
Hi Bettina,

personally I would like to close this Issue as wontfix because our Standard
numberformat just uses the appropriate decimal places entered. So integers are
shown without decimals and results of a calculation resulting in numbers smaller
than zero are displayed with an accurate number of decimals. The user can
explicitly set the format to integer.

So it's up to you to decide about this.

Comment 2 forsoft 2007-04-21 10:16:37 UTC
That's interesting.

I've noticed the amount of decimal places used in a standard formatted cell is 
always 2, when a value with more decimal places than 2 is entered.

The effect is present in OO 2.2.0

Entering 1.2345 in a cell with the standard format.
The cell displays: 1.23
Comment 3 bettina.haberer 2010-05-21 14:54:12 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".