https://bugs.documentfoundation.org/show_bug.cgi?id=172850
Bug ID: 172850
Summary: [FORMATTING][FILEOPEN] LibreOffice auto lowercase
xlookup bug
Product: LibreOffice
Version: 26.2.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I normally generate my xlsx files in python and view thme using libre office
calc.
The issue is that the XLOOKUP function seems to be buggy.
When I generate an expression with the XLOOKUP function in python and view it
in libre office calc, the word gets lowercased and breaks. I need to manually
re-capitalise XLOOKUP for the expression to work again. I have tested this with
other function such as VLOOKUP and these functions all behave correctly.
Steps to Reproduce:
1. Run the following python script.
```
from openpyxl import Workbook
wb = Workbook()
# Data sheet
data = wb.active
data.title = "Data"
data.append(["ID", "Name"])
data.append([1, "Apple"])
data.append([2, "Banana"])
data.append([3, "Orange"])
# Lookup sheet
sheet = wb.create_sheet("Lookup")
sheet["A1"] = "Find ID"
sheet["B1"] = "Result"
sheet["A2"] = 2
# XLOOKUP formula
sheet["B2"] = "=XLOOKUP(A2,Data!A:A,Data!B:B)"
wb.save("xlookup_test.xlsx")
print("Created xlookup_test.xlsx")
```
2. Open the generated file with libre calc office.
3. Notice that the expression has lowercased a lowercase 'xlookup'.
4. Capitalize 'xlookup' and notice how the function suddenly works.
Actual Results:
Cell returns #NAME?
Expected Results:
Cell returns 'Banana' in the script but essentially should not return an error.
Reproducible: Always
User Profile Reset: No
Additional Info:
The software should not lowercase XLOOKUP in expressions
Note: I also tested it in 26.2.4.2 then upgraded to see if the problem would
fix itself but both versions do not work.
Version: 26.8.0.1 (X86_64)
Build ID: 2577b8a8e9a5d3f37124fb86a89387e3807953a7
CPU threads: 32; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Vulkan;
VCL: win
Locale: en-AU (en_AU); UI: en-US
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
