Issue 124207 - Number Format number of decimals for Table Cells and Fields can not be predefined via Styles
Summary: Number Format number of decimals for Table Cells and Fields can not be predef...
Status: CONFIRMED
Alias: None
Product: Writer
Classification: Application
Component: editing (show other issues)
Version: 4.0.0
Hardware: PC Windows 7
: P3 Minor (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-02-08 17:02 UTC by Sam Jennings
Modified: 2014-04-17 19:01 UTC (History)
3 users (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description Sam Jennings 2014-02-08 17:02:00 UTC
Steps:
Make a table in OpenOffice.
Add an integer number followed by a percent.
(For example, 43%)

Observe:
Openoffice converts the number to 
43.00%

This is highly undesirable behavior.  People often use an approximate (or rounded) percentage and do not intend significant digits beyond the rounding.  Therefore, in each such case (literally 99% of the time) OpenOffice is forcing their table data to be wrong.
Comment 1 Edwin Sharp 2014-02-08 17:11:43 UTC
IMHO the default behavior should be leave 43% as is.
AOO410m1(Build:9750)  -  Rev. 1565724
Rev.1565724
Win 7

Return to 43% by: right click - Number Format... - Options - Decimal places=0
Comment 2 Sam Jennings 2014-02-08 17:39:52 UTC
(In reply to Edwin Sharp from comment #1)
> IMHO the default behavior should be leave 43% as is.
> AOO410m1(Build:9750)  -  Rev. 1565724
> Rev.1565724
> Win 7
> 
> Return to 43% by: right click - Number Format... - Options - Decimal places=0

Thank you.  At least there's a viable workaround.
Comment 3 Rainer Bielefeld 2014-02-08 19:04:59 UTC
This problem is not limited to Writer Tables, similar default setting in Calc.

There is a workaround (of course, the same as Edwin told) in the forum: <https://forum.openoffice.org/en/forum/viewtopic.php?f=7&t=39060>

The current behavior probably is intended, generally default format seems to be 2 decimals. In Calc that can be modified easily in Default-Style, but I currently do not know how to do something similar in Writer.

The issue does not only affect Number Values in Writer tables, but also Fields, so related Text document calculation, possibly more. 
Currently this one is more or less WONTFIX, there will not be a particular "show percent in Table without decimals by default" fix. Next one wants 1 Decimal? The costs really are to high for a feature what can simply be replaced by the mentioned workaround 

But indeed, some enhancement would be fine, IMHO we need a possibility to predefine Number styles in Writer. But what does ODF tell? Or may be it's already possible and we only don't know? We will have to check that before we can ask for a fix.
Comment 4 Sam Jennings 2014-02-08 20:39:48 UTC
I believe the best default behavior is to preserve what the user types.  It's no trouble at all to add ".00%" after a number if you want it there, but it's a royal pain in the posterior to remove it when the program insidiously puts it back.  The feature mentioned above is not obvious to anyone who hasn't asked about its existence.  Most of your users will get stranded at this point.  The out of the box behavior is not what a user would want... 

And this is not a feature request, it's a bug report.  I'm 100.00% certain it is a bug.
Comment 5 Edwin Sharp 2014-04-17 19:01:57 UTC
Confirmed with
AOO420m1(Build:9800)  -  Rev. 1586681
Rev.1586681
Win 7