Bug 134797 - concatenate strings inside report builder aren't get formatted
Summary: concatenate strings inside report builder aren't get formatted
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.4.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-07-14 10:30 UTC by michael
Modified: 2020-07-14 16:01 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
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 michael 2020-07-14 10:30:53 UTC 
In the moment data gets concatenated for a data field the format isn't respected.

" Rechnung  "&[RechnungsID]&"/20"

or

"Berlin "&[Rechnungsdatum]

have the result:

Berlin Montag, 13. Juli 2020 um 00:00:00 Mitteleuropäische Sommerzeit

Thanks for your help

michael
Comment 1 michael 2020-07-14 10:33:54 UTC 
... a workaround for the date would be to make your own format:

"Berlin, den "T. MMMM JJJJ

but the problems of the formats seem to affect every format, like currency, date,.....
Comment 2 Robert Großkopf 2020-07-14 14:22:52 UTC 
Concatenating fields will set the field to a field for characters only. It is the same as in the database.

Set two fields, one for the text, the other for the date.