https://bugs.documentfoundation.org/show_bug.cgi?id=171436
Bug ID: 171436
Summary: The CONCAT function disregards the region setting for
decimal numbers
Product: LibreOffice
Version: 26.2.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Being on the german setting, decimal numbers show with a "," as separator (as
it should be). If I format a cell to instead show "." as the separator by
changing its region format to US and then use the CONCAT (TEXTKETTE) function,
it will disregard this setting and still show a "," in the output string.
Steps to Reproduce:
1.enter decimal number i.e. "1,5"
2.format cell to US region, number then displays as "1.5"
3.use CONCAT
Actual Results:
1,5
Expected Results:
1.5
Reproducible: Always
User Profile Reset: No
Additional Info:
none
--
You are receiving this mail because:
You are the assignee for the bug.