Bug 152344 - REPORT Builder: Standard format for number in fields will ignore 0 values
Summary: REPORT Builder: Standard format for number in fields will ignore 0 values
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.4.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-12-01 16:42 UTC by Robert Großkopf
Modified: 2024-12-02 07:19 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
Open the document, execute the report. 0 won't be shown in "TID" (26.25 KB, application/vnd.oasis.opendocument.database)
2022-12-01 16:42 UTC, Robert Großkopf
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2022-12-01 16:42:00 UTC
Created attachment 183944 [details]
Open the document, execute the report. 0 won't be shown in "TID"

Open the attached database.
Execute the report.
Fields for "Town_ID" and "TID" have same datasource.
"TID" isn't shown if it is '0'.
"Town_ID" (and "ID") had been set to Format Code → 0
"TID" has Format Code → Standard

Standard should have a code like 0,## - but it seems to have a code like #,##. So 0-values won't be shown.

This is a very old bug. Think it never worked in another way…

tested with OpenSUSE 15.3 and LO 7.4.3.2
Comment 1 Stang 2022-12-02 04:31:28 UTC
Confirmed on Ubuntu 20.04.5 with

Version: 7.4.3.2 / LibreOffice Community
Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 2 QA Administrators 2024-12-02 03:14:26 UTC Comment hidden (obsolete)
Comment 3 Robert Großkopf 2024-12-02 07:19:04 UTC
Bug is still the same in
Version: 24.8.3.2 (X86_64) / LibreOffice Community
Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded