Bug 169453 - FILEOPEN, FORMATTING: Loading XLSX file with IFS() results with #NAME?
Summary: FILEOPEN, FORMATTING: Loading XLSX file with IFS() results with #NAME?
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.2.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-11-14 21:11 UTC by jarethgomes
Modified: 2026-01-22 07:18 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
XLSX used into reproducible example (4.67 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2025-11-14 21:13 UTC, jarethgomes 		Details
Sample redone with Excel 365 (7.68 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2025-11-14 23:29 UTC, m_a_riosv 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description jarethgomes 2025-11-14 21:11:25 UTC 
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
Comment 1 jarethgomes 2025-11-14 21:13:13 UTC 
Created attachment 203984 [details]
XLSX used into reproducible example
Comment 2 m_a_riosv 2025-11-14 23:29:30 UTC 
Created attachment 203990 [details]
Sample redone with Excel 365

Your sample file gives an error with
Microsoft® Excel® para Microsoft 365 MSO (versión 2510 compilación 16.0.19328.20190) de 64 bits

After reintroduce the formula, in my case (Spanish) SI.CONJUNTO() it works fine with LibreOffice.
Version: 25.8.3.2 (X86_64)
Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e
CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: threaded

But remember that the @ in the formula it is not implemented with LO so not imported/applied.
Comment 3 jarethgomes 2025-11-15 05:22:46 UTC 
Thanks. Your xlsx file works on my version of LO. To add some more context to this, the xlsx I have was generated earlier today using Google Sheets (File > Download > Microsoft Excel).  I can't confirm this myself with Excel, but a person on my team ran my example using Excel, and it worked for them.

Version of Excel they were using:
Microsoft Office Home and Business 2024
Version 2510 (Build 19328.20190)
Comment 4 m_a_riosv 2025-11-15 12:28:46 UTC 
Please verify that the file is opened with MSO-Excel, and that a calculation it's done [F9].