❓ [QUESTION] - Getting total cell data, not their evaluated values.

[RasmusHojgaard]

Description

Hello! Huge fan of this component, extremely useful and versatile.

I am however unable to fathom how to export the actual information in the table. Functions like getObjectsFlatten and getMatrixFlatten only seem to export the evaulated values, not the formulas. I would like for my tables to be able to save/load their actual content to a backend, including relevant formulas (like =sum(), =product() and so on).

How do I go about doing this?

Reproduction URL

No response

Version

1.3.0

[righ]

Thank you for becoming a fan of the library!
Although it's not documented, methods like getMatrixFlatten have an evaluates option.
By specifying table.getMatrixFlatten({ evaluates: false }), you can retrieve the unevaluated formulas.
However, it seems that the evaluates option is not working in v1.3.0.
I'll fix it shortly, so please bear with me for a moment.

[righ]

The issue has been fixed in 1.3.1-alpha.0.
Please check if you are getting the expected result with table.getMatrixFlatten({ evaluates: false }).