Bug 169249 - Decimal places in default style is ignored
Summary: Decimal places in default style is ignored
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.2.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-11-04 13:16 UTC by Greg's Coffee
Modified: 2025-11-05 08:47 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Illustration of bug (160.95 KB, image/png)
2025-11-04 13:16 UTC, Greg's Coffee
Details
Calc file with the bug (14.23 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-11-04 19:48 UTC, Greg's Coffee
Details
Screnshot ot the view opening the sample file, without doing any change. (35.07 KB, image/png)
2025-11-04 22:42 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Greg's Coffee 2025-11-04 13:16:42 UTC
Created attachment 203725 [details]
Illustration of bug

In a Calc file I have a Default style whose Number format is set to -1234.57 (format code 0.00). When I apply that default style to a number, the number of decimal places in the style is ignored. Calc displays the numbers as I type them. See attached.

The expected behavior is that if the Default style specifies two decimal places, and I apply that style to a number, the number appears with two decimal places.
Comment 1 Greg's Coffee 2025-11-04 13:17:25 UTC
Observation: When I create a new style based on *Default* (without making any changes), and apply that style, the number of decimal places is honored.
Comment 2 Greg's Coffee 2025-11-04 19:48:30 UTC
Created attachment 203733 [details]
Calc file with the bug

This file contains an example of the bug described in this ticket.
Comment 3 m_a_riosv 2025-11-04 22:42:53 UTC
Created attachment 203737 [details]
Screnshot ot the view opening the sample file, without doing any change.

Screenshot of the view when opening the sample file, without making any changes.

Version: 25.8.3.1 (X86_64)
Build ID: 52ad9dd1c984050a9fb6932dbfb16e86a49e9758
CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: threaded

Please test in Menu>Help>Restart in Safe Mode.
Comment 4 Greg's Coffee 2025-11-05 01:57:04 UTC
(In reply to m_a_riosv from comment #3)
> Created attachment 203737 [details]
> Screnshot ot the view opening the sample file, without doing any change.
> 
> Screenshot of the view when opening the sample file, without making any
> changes.
> 
> Version: 25.8.3.1 (X86_64)
> Build ID: 52ad9dd1c984050a9fb6932dbfb16e86a49e9758
> CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render:
> Skia/Raster; VCL: win
> Locale: es-ES (es_ES); UI: en-US
> Calc: threaded
> 
> Please test in Menu>Help>Restart in Safe Mode.

Thank you very much! Starting in safe mode cleared the conditions. Please close this ticket.