https://bugs.documentfoundation.org/show_bug.cgi?id=169453
Bug ID: 169453
Summary: FILEOPEN, FORMATTING: Loading XLSX file with IFS()
results with #NAME?
Product: LibreOffice
Version: 25.8.2.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Attempting to load an XLSX file that has cells that use the `IFS()` function
results in the function being translated to a lowercased `ifs()`, which
syntactically breaks the cell, resulting in a #NAME? error.
Expected behavior is that cells referencing `IFS()` should not be lowercased,
and cells referencing `IFS()` should not generate errors related to incorrect
function names related to `IFS()`.
Steps to Reproduce:
1. Using the provided XLSX file, load the file into LibreOffice. The sheet
contains 3 populated cells: A1 = 10, A2 = 20, A3 =
=IFS(A2<10,"hello",A1>5,"world", TRUE(), "fallback")
2. Observe A3
Actual Results:
A3 errors with #NAME?. Looking into the cell shows the string
"=ifs(A2<10,"hello",A1>5,"world", TRUE(), "fallback")"
Expected Results:
A3 should respond with "world"
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 25.8.2.2 (X86_64) / LibreOffice Community
Build ID: 580(Build:2)
CPU threads: 12; OS: Linux 6.17; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
25.8.2-4
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
