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
The result, it's fine for me. Please attach your sample file, to test.
Created attachment 180788 [details] Sample file working OK Not repro Version: 7.3.3.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 16; OS: Linux 5.13; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Ubuntu package version: 1:7.3.3~rc2-0ubuntu0.21.10.1~lo1 Calc: threaded Also not repro in Version: 7.5.0.0.alpha0+ / LibreOffice Community Build ID: 66b849eab05bb6b696cced84ca90c17ca1bc31dd CPU threads: 16; OS: Linux 5.13; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Calc: CL I attached a file reproducing the steps described by the OP and the result seems fine. Please attach your own sample file so we can test.
You have entered the value in C3 with a formula similar to =1/3, and it gets many 3 as decimal places, although it shows only one. Just type 33.3, and you will get 275276.
Maybe you must check [x] Precision as shown (https://help.libreoffice.org/latest/en-US/text/shared/optionen/01060500.html#hd_id3145150).