https://bugs.documentfoundation.org/show_bug.cgi?id=170876
Bug ID: 170876
Summary: FILEOPEN XLSX Imported array formula result in
attached file is Err:504
Product: LibreOffice
Version: 4.0.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 108253
Created attachment 205602
--> https://bugs.documentfoundation.org/attachment.cgi?id=205602&action=edit
forum-mso-en-13548.xlsx
Open the attached XLSX, forum-mso-en-13548.xlsx in Calc.
Check cells C3 and C4 in sheet1.
In Excel, they show "repor1" and "repor2".
In Calc both show Err:504.
See attached screenshot for comparison (row height is different in Calc, which
is an independent regression, disregard that).
C3 and C4 contain the following array formula:
{=INDEX(sheet2!$C$3:$C$4;MATCH(1;(--ISNUMBER(SEARCH(sheet2!B3;sheet1!$B$3:$B$4)));0))}
Observed using LO 26.8.0.0.alpha0+ (26-02-07), 4.0.0.3 / Windows.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=108253
[Bug 108253] [META] Calc cell formula bugs and enhancements
--
You are receiving this mail because:
You are the assignee for the bug.
