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: libreoffice-bugs@lists.freedesktop.org Reporter: jeff9...@hotmail.com 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.