Convert formulas into values using jupyterlab-spreadsheet-editor

JupyterLab extensions
1

Hello,

I find that the jupyterlab-spreadsheet-editor extension can be very useful, but I do not know how to convert formulas into values.

For example, I can enter a formula and get the results as shown below, but when I save and reopen the .csv file or paste cells into a MD cell, I get the formulas, not the values:

imagen
imagen1063×246 75.6 KB

How can I convert the formulas into numerical values so that I can copy or export the results ?

Thanks so much !

Dimas

2

If there isn’t an easier way to select the values, you can use the HTML representation of the table to convert it to values, or even a CSV, with some Python.

In a Jupyter notebook here, I spell out the steps using the example for rendering formulas from the documentation.

3

Thank you it’s nice to hear!

but I do not know how to convert formulas into values.

If you could open an issue on GitHub - jupyterlab-contrib/jupyterlab-spreadsheet-editor: JupyterLab spreadsheet editor for tabular data (e.g. csv, tsv) I can look at what would be needed; we could probably add a button on the toolbar that converts formulas into values easily.

1 Like