| Summary: | Data Range and #headers: Err: 504 | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | guichard.adrien |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED INVALID | ||
| Severity: | normal | CC: | miguelangelrv, raal, xiscofauli |
| Priority: | medium | ||
| Version: | 6.3.2.2 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Test case #headers | ||
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 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. 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. |
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.