Description
https://hyperformula.handsontable.com/api/classes/hyperformula.html#getallsheetsserialized
The documentation shows that ['1', '2', '=A1+10'] would be serialized as [1, 2, '=A1+10'] - ie the numeric strings converted to numbers. The actual behaviour is that all cells remain as strings.
The docs shows that RawCellContent should be returned:
[getallsheetsserialized] Returns formulas or values of all sheets in a form of an object which property keys are strings and values are 2D arrays of RawCellContent.
It looks to me that the expected behaviour is to detect the type as-per this:
https://hyperformula.handsontable.com/guide/types-of-values.html#for-string-values
NB: My demo simply copies the code in the getAllSheetsSerialized documentation, it would probably make sense to include the other values shown in the types of values docs too...
Video or screenshots
No response
Demo
https://stackblitz.com/edit/sgkxpfpa-bdrhnhw2?file=index.ts,index.html
HyperFormula version
3.2.0
Your framework
No response
Your environment
Chrome latest
Description
https://hyperformula.handsontable.com/api/classes/hyperformula.html#getallsheetsserialized
The documentation shows that
['1', '2', '=A1+10']would be serialized as[1, 2, '=A1+10']- ie the numeric strings converted to numbers. The actual behaviour is that all cells remain as strings.The docs shows that
RawCellContentshould be returned:It looks to me that the expected behaviour is to detect the type as-per this:
https://hyperformula.handsontable.com/guide/types-of-values.html#for-string-values
NB: My demo simply copies the code in the
getAllSheetsSerializeddocumentation, it would probably make sense to include the other values shown in the types of values docs too...Video or screenshots
No response
Demo
https://stackblitz.com/edit/sgkxpfpa-bdrhnhw2?file=index.ts,index.html
HyperFormula version
3.2.0
Your framework
No response
Your environment
Chrome latest