Bug 152344

Summary: REPORT Builder: Standard format for number in fields will ignore 0 values
Product: LibreOffice Reporter: Robert Großkopf <robert>
Component: BaseAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal    
Priority: medium    
Version: 7.4.3.2 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=152331
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Open the document, execute the report. 0 won't be shown in "TID"

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