[Libreoffice-bugs] [Bug 137846] New: FILEOPEN XLSX Defined name pointing to data table does not resolve source file name
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Thu Oct 29 08:15:59 UTC 2020
https://bugs.documentfoundation.org/show_bug.cgi?id=137846
Bug ID: 137846
Summary: FILEOPEN XLSX Defined name pointing to data table does
not resolve source file name
Product: LibreOffice
Version: 7.1.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs at lists.freedesktop.org
Reporter: libreoffice at nisz.hu
CC: nemeth at numbertext.org, szucs.attila3 at nisz.hu
Blocks: 137805
Created attachment 166827
--> https://bugs.documentfoundation.org/attachment.cgi?id=166827&action=edit
Data source file with data table from Excel
Attached Excel-made example file contains a data table with month names and a
named range with month names.
Other file ha defined names referencing the data table and the named range,
then using these in VLOOKUP functions.
When opened in Calc the file name of the data table referencing defined name is
not resolved as can be seen in the Manage Names dialog, and the VLOOKUP using
them gives Err:501 error.
The simple defined name works fine.
Steps to reproduce:
1. Open attached files in Calc
Actual results:
Err:501 errors in column C, unresolved file name in the Manage Names dialog.
Expected results:
File name resolved in Manage Names dialog, VLOOKUP works like in Excel.
LibreOffice details:
Version: 7.1.0.0.alpha1+ (x64)
Build ID: f27c4ec5c864395f4cdaec32d7e95ff24e4f43c8
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=137805
[Bug 137805] [META] XLSX (OOXML) Data range / Format as Table issues
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201029/085b4c67/attachment.htm>
More information about the Libreoffice-bugs
mailing list