Running into an error when using LibreOffice to create .xlsx files. It presents =TRUE() and =FALSE() as 1 and 0, which breaks the spreadsheet parser. The error message is "Unable to parse the data on row {row}" and does not show the row number.
I think the fix is to add the $:
error($"Unable to parse the data on row {row} of the Train Types sheet");
https://github.com/lukos/simsig_importer/blob/33509e2eabc0ac12361f223f59f92789011726f8/SimsigImporterLibrary/SpreadsheetHelper.cs#L696
Running into an error when using LibreOffice to create .xlsx files. It presents
=TRUE()
and=FALSE()
as1
and0
, which breaks the spreadsheet parser. The error message is "Unable to parse the data on row {row}" and does not show the row number.I think the fix is to add the
$
: