Bug 156667

Summary:	Calc: setting number of decimal places to 0 directly has no effect, unless you set it to 1 first
Product:	LibreOffice	Reporter:	bobby.1.derti
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	buzea.bogdan
Priority:	medium
Version:	7.3.7.2 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108252

Description bobby.1.derti 2023-08-08 11:27:25 UTC

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.

Comment 1 jcsanz 2023-08-08 17:09:47 UTC

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

Comment 2 LeroyG 2023-08-08 22:14:09 UTC

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

Comment 3 bobby.1.derti 2023-08-09 02:55:35 UTC

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.

Comment 4 LeroyG 2023-08-13 22:31:00 UTC

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.

Comment 5 BogdanB 2023-09-16 11:50:19 UTC

"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

Comment 6 ady 2023-09-16 18:56:23 UTC

(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".