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: 2022-12-02 04:31 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
View All Add an attachment (proposed patch, testcase, etc.)

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