Affects Version/s: 5.5.0, 5.6.0
Fix Version/s: 5.6.0
Security Level: Jimmy
Run keikai with attached sample1.xlsx
no exception, cell values handled in a similar way to range references (sample2.xlsx) to avoid blocking the UI
Happens when a formula in a Cell (ex C3) generates results for other cells (C4, C5, C6, etc)
io.keikai.importer.XlsxImporter.importCell(XlsxCellExtractor, int, SSheet)
formulaValue is null due only the first cell (the original cell holding the =indirect formula) having a fonction as value.
The following cells are automatically generated by the spreadsheet (in Excel), and so have no value.
This is similar to the direct reference (sample2.xlsx) which works in keikai by hard-copying the content of the target cells during import then discarding the formula
(same result using the "D3:D10" notation, see sample3.xlsx)