Issue 115512 - "Precision as shown" not working if automatic decimal
Summary: "Precision as shown" not working if automatic decimal
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.3 RC4
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
Keywords: regression
Depends on:
Blocks: 111112
  Show dependency tree
Reported: 2010-11-10 18:49 UTC by jumbo444
Modified: 2017-05-20 11:41 UTC (History)
3 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description jumbo444 2010-11-10 18:49:05 UTC

I love "automatic decimal" (CWS koheiautodecimal

However, it seems it is not compatible with "Precision as shown" option.
Steps to reproduce:
- in Tools>Options>OOo Calc>Calculate, check "Precision as shown" option, and
uncheck "Limit decimals for general number format" option
- enter a decimal value such as =PI()
=> you get 0!

Found in OOo330m14 (RC4) on WinXP
Comment 1 jbf.faure 2010-11-11 09:34:03 UTC
I can confirm the defect under Linux (Ubuntu 10.04 x86-64) from at least OOO330m9.
Key word regression set : no problem in OOo 3.2.1

Comment 2 vitriol 2010-11-11 09:46:45 UTC
Adding me to CC
Comment 3 jeffooo 2010-11-11 10:42:39 UTC
Adding me to CC
Comment 4 niklas.nebel 2010-11-11 10:55:06 UTC
I'll take it.
Comment 5 mdxonefour 2010-11-11 10:57:07 UTC
adjusting target to 3.3
Comment 6 niklas.nebel 2010-11-11 12:20:03 UTC
Fixed in CWS "calc63". The new (and intended) behavior is: With automatic
decimals and "precision as shown", there is no rounding for cells with default
format. This was agreed upon on the ux list, see point 3 in
Comment 7 niklas.nebel 2010-11-11 14:06:57 UTC
reassigning to QA for verification
Comment 8 oc 2010-11-11 17:07:08 UTC
verified in internal build cws_calc63