https://bugs.documentfoundation.org/show_bug.cgi?id=149569
Bug ID: 149569
Summary: Spreadsheet refuses to use the correct number of
decimal places
Product: LibreOffice
Version: 7.3.4.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Formatting Error
Spreadsheet formula: =(A3+BC)/C3
A3: $25,000.00 (Cell format: currency with 2 decimal places)
B3: $66,667.00 (Cell format: currency with 2 decimal places)
C3: 33.3% (Cell format: percent with 1 decimal place)
Result: 275,001
(25,000+66,667)/33.3% SHOULD equal 275,276
275,001 is the result of (25,000+66,667)/33.3333%
I have manually set the number of decimal places to 1 when cell C3 is formatted
as a percent.
I have manually set the number of decimal places to 3 when cell C3 is formatted
as a number.
I have manually set the number of decimal places for cells A3 and B3 to 0 when
formatted as currency AND as a number.
Nothing I can do will get cell C3 to recognize 33.3% or 0.333 correctly.
Steps to Reproduce:
Spreadsheet formula: =(A3+BC)/C3
A3: $25,000.00 (Cell format: currency with 2 decimal places)
B3: $66,667.00 (Cell format: currency with 2 decimal places)
C3: 33.3% (Cell format: percent with 1 decimal place)
Actual Results:
275,001
Expected Results:
275,276
Reproducible: Always
User Profile Reset: No
Additional Info:
Divided the sum of 25,000 and 66,667 by 0.333
--
You are receiving this mail because:
You are the assignee for the bug.
