Read xlsx with range names raises errors
Original Reporter info from Mantis: JoshyFun @joshyfun
-
Reporter name: José Mejuto
Original Reporter info from Mantis: JoshyFun @joshyfun
- Reporter name: José Mejuto
Description:
Reading a XLSX file with range names "book wide" defined, raises a loading error for each name in function:
procedure TsSpreadOOXMLReader.ReadDefinedNames(ANode: TDOMNode);
[...]
if (localSheetID = '') or not TryStrToInt(localSheetID, id) then
begin
FWorkbook.AddErrorMsg('no/invalid localID in "definedName" node');
node := node.NextSibling;
Continue;
end;
Additional information:
If the range names are local to the sheet no error is displayed.
Attached file with two ranges, 1 local to the sheet and 1 book wide. The book one is named "ThisFails".
Mantis conversion info:
- Mantis ID: 34381
- OS: Windows
- OS Build: Seven
- Platform: x64