Convert formulas into values

[dimassuarez]

Is your feature request related to a problem?

When entering formulas into a CSV file using the jupyterlab-spreadsheet-editor extension, the numerical results can be seen in the CSV viewer / editor, but the corresponding CSV file contains only the formulas.

To ease the usage or export of the augmented CSV files, it would be interesting to have to option of converting formulas into values.

Describe the solution you'd like

For the sake of simplicity and keeping in mind the usage of this extension by fresh students in science labs, it would be nice to add another button on the tools bar for converting the formulas of selected cells into numerical values

Thanks a lot in advance!

[krassowski]

To add a button we use code like this:

jupyterlab-spreadsheet-editor/src/documentwidget.ts

Lines 30 to 38 in a557d77

	const addRowButton = new ToolbarButton({
	icon: addRowIcon,
	onClick: () => {
	this.content.jexcel!.insertRow();
	this.content.updateModel();
	},
	tooltip: this._trans.__('Insert a row at the end')
	});
	this.toolbar.addItem('spreadsheet:insert-row', addRowButton);

To convert formulas to values I think we would need to iterate over every cell and execute executeFormula function documented in https://jspreadsheet.com/docs/formulas and update values with it. PRs welcome!