Skip to content

Number formatting with a mask #1760

Description

@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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions