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.

Reply via email to