https://bugs.documentfoundation.org/show_bug.cgi?id=160893
--- Comment #17 from ady <[email protected]> --- Created attachment 195275 --> https://bugs.documentfoundation.org/attachment.cgi?id=195275&action=edit Calc XLOOKUP test xlsx I am attaching a new XLSX file created with Calc, to test this report. Version: 24.8.0.1.0+ (X86_64) / LibreOffice Community Build ID: 6312019426f45e0c4b49d7f29506148f93a5c2e1 CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: threaded It contains 3 worksheets: one with notes, one with ascending-sorted data and one with descending-sorted data. It does not include wildcards nor regex cases. Beware of changing the data: part of the data table and some of the arguments for the formulas are direct strings, not references to other parts of the data table, in order to test this tdf#160893. The results of the formulas of this testing file should be compared when opening the file with Calc vs opening the file with Excel (2021+) and executing recalculation. Another possible test would be to recreate anew the data, cell formats, and formulas in Excel itself (completely independent of Calc) and comparing the results of that file in Excel against importing that recreated file in Calc. This testing file does not cover "every-and-all" possible cases, but I believe it should be a starting point towards resolving this tdf#160893. -- You are receiving this mail because: You are the assignee for the bug.
