https://bugs.documentfoundation.org/show_bug.cgi?id=145383
Bug ID: 145383
Summary: Google Sheets XLSX Download CONCAT Function
Product: LibreOffice
Version: 7.1.6.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Google Sheets supports CONCAT when uploaded. However, when downloaded the
CONCAT function does not work. I noticed that the downloaded XLSX file has
lower case concat versus being capitalized. This breaks the function since
LibreCalc only seems to recognize the capitalized function (only CONCAT, not
concat).
Steps to Reproduce:
1. Upload XLSX file created in LibreCalc
2. Save as Google Sheets. Concat function maintained.
3. Download as XLSX format. Lower case concat in all cells so function lost.
Get Name? error
Actual Results:
NAME? error in all cells with concat function. LibreCalc seems to only
recognize capitalized CONCAT which seems odd.
Expected Results:
LibreCalc should recognize both =CONCAT( and =concat( as the same function
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
--
You are receiving this mail because:
You are the assignee for the bug.
