Bug 129485 - Data Range and #headers: Err: 504
Summary: Data Range and #headers: Err: 504
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-12-18 23:27 UTC by guichard.adrien
Modified: 2019-12-21 07:22 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Test case #headers (9.16 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-12-18 23:27 UTC, guichard.adrien 		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 guichard.adrien 2019-12-18 23:27:29 UTC 
Created attachment 156659 [details]
Test case #headers

When opening Excel file using data range #header selector, an error 504 is shown in cells.

Example:
=MATCH(Tab1[#headers],Tab2[#headers],0)

in Excel this formula shows the correct answer.
Comment 1 Xavier Van Wijmeersch 2019-12-19 09:47:11 UTC 
when I open the attachment I get error 508 and this is the formula I see in B9

=MATCH(#NAME?#headers;#NAME?#headers;0)

Version: 6.3.4.2
Build ID: 60da17e045e08f1793c57c00ba83cdfce946d0aa
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3; 
Locale: nl-BE (en_US.UTF-8); UI-Language: en-US
Calc: threaded

Version: 6.5.0.0.alpha0+
Build ID: 1fd65c35f9cc44d94ac10e929b9c9c4bfb8d1afc
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3; 
Locale: nl-BE (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 2 m_a_riosv 2019-12-19 10:34:29 UTC 
The attached it's not an excel file but ODF type file.

Such use of table data formulas are only supporting in excel file format xlsx.
Comment 3 guichard.adrien 2019-12-21 07:22:15 UTC 
The bug is somewhere else in the XLSX file, I could obtain good results changing:
=MATCH(Tab1[#headers],Tab2[#headers],0)
in
=MATCH(Tab1[[#headers]],Tab2[[#headers]],0)

Thanks for your time, I close this bug as INVALID.