Number formatting with a mask

[glib-0]

Related to #614.
When using a mask (e.g. "$ #,##0") or currency format (eg., taken from docs: {locale: 'en-IN',options: { style:'currency', currency: 'INR' }}), if the first value entered in an empty cell is zero, the cell is blanked and the onafterchanges event does not fire. If you enter any non-zero value and then enter zero, the zero is retained.

You can see this behaviour in the jspreadsheet docs: https://bossanova.uk/jspreadsheet/docs/format.

In the "Currency Formatting" example - trying to enter 0 into column A demonstrates the described behaviour. Same lower down in the "Data Grid with Different Currencies" example. There are values with zero already present, so they will accept typing zero - but empty cells below will not unless you enter something else first.

[glib-0]

For anyone else with this issue, my workaround (in React) is using the Spreadsheet oneditionend event like so:

const handleEditCellEnd = (instance,cell,x,y,value) => {
	if (value === 0) {
		instance.setValue(cell, value);
	}
}

---

<Spreadsheet oneditionend={handleEditCellEnd} />