Description: Using Format => Cells, setting the number of decimal places to 0 by typing a 0 has no effect. It must first be set to something other than 0. Calc has worked like this for years. I couldn't find a prior bug report but my apologies if I missed it. Steps to Reproduce: 1. Select one or more cells containing floating point numbers. 2. Cick Format, Cells. 3. Type "0" (zero) in the box for "Decimal places", then click OK. Actual Results: Number format is left unchanged, with original number(s) of decimal places. Expected Results: Numbers appear with 0 decimal places. Reproducible: Always User Profile Reset: No Additional Info: Workaround: 1. Click Format, Cells. 2. Next to "Decimal places", click "+" then "-", or click in the box, arrow up then arrow down. 3. Click OK.
NOT reproducible. For me it works correctly. Version: 7.5.5.2 (X86_64) / LibreOffice Community Build ID: ca8fe7424262805f223b9a2334bc7181abbcbf5e CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded Jumbo
Not reproducible on Windows 10.0 with: Version: 7.4.7.2 (x64) / LibreOffice Community Build ID: 723314e595e8007d3cf785c16538505a1c878ca5 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-MX (es_ES); UI: en-US Calc: CL
Agreed - this works normally in Windows. Could someone please try this in Linux? Here is a Linux-specific quirk that seems related: select Format => Cells then Alt-D (decimal). Type 0 (zero) and press enter. Nothing happens. In Windows, pressing Enter is equivalent to clicking OK.
Reproducible with: Version: 7.4.3.2 / LibreOffice Community Build ID: 40(Build:2) CPU threads: 1; OS: Linux 5.14; UI render: default; VCL: gtk3 Locale: es-MX (en_US.UTF-8); UI: en-US Calc: threaded User profile reset.
"Standard" is not changing until we press + to move first to 1, then back to 0. Version: 7.5.5.2 (X86_64) / LibreOffice Community Build ID: ca8fe7424262805f223b9a2334bc7181abbcbf5e CPU threads: 4; OS: Linux 6.2; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
(In reply to BogdanB from comment #5) > "Standard" is not changing until we press + to move first to 1, then back to > 0. JIC and FYI, depending on LO Language, the number Format named "Standard" could be seen instead as "General".