https://bugs.documentfoundation.org/show_bug.cgi?id=170788
Bug ID: 170788
Summary: LibreOffice Calc LET Function broken when lowercase
Product: LibreOffice
Version: 26.2.0.3 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When the LET function is used, if it's written in lowercase "let", LibreOffice
Calc will show an error result of "#NAME?". Function names should not be
treated as case-sensitive, so this should get fixed in LibreOffice Calc.
As background, whenever you export a Google Sheet into either Excel or
OpenDocument format, LET is converted to lowercase, wherever it appears in the
formula. It's not within my control to just use uppercase, as the working
source files are all Google Sheets. I am attempting to sync hundreds of Google
Sheets documents to ODS for offline work which will still need to sync back to
Google. (using Linux Insync utility).
example that fails:
=IF($A3="","",
let(act,UPPER(TRIM($B3)),
IF(act<>"MTM", $M3,
$M3 + $W3
)
)
)
Steps to Reproduce:
1. Create a Google Sheet containing these values in A1 to A5:
Active, 3, 4, 5, =IF(A1<>"Active","N/A",LET(avg, AVERAGE(B1:D1), IF(avg>=4,
"Great", IF(avg>=3, "Good", "Poor"))))
The formula in A5 should display a value of "Great".
2. File Menu -> Download -> OpenDocument
3. Open the file with LibreOffice Calc and see that A5 now shows "#NAME?".
4. Edit the formula to uppercase LET and it will show "Great" again.
Actual Results:
cell A5 shows "#NAME?".
Expected Results:
cell A5 shows "Great".
Reproducible: Always
User Profile Reset: No
Additional Info:
Locale: en-CA.UTF-8
Module: SpreadsheetDocument
OS: Linux Mint 22.3 Cinnamon
OS is 64bit: yes
Kernel 6.17.0-14-generic
LibreOffice 26.2.0.3 Flatpak edition
Build: afbbd0df0edb6d40b450b0337ac646b0913a760c
--
You are receiving this mail because:
You are the assignee for the bug.
