Use: https://snippet.webix.com/lls6bj7b
To reproduce the problem enter a date in cell F2, for example 2021-02-08 when pressing enter changes to 02/05/2176 and from that moment on, no value in the entire column F can be edited.
Hi @JorgeQuiros
If the cell has the default format (“Common”), the type of the entered value will be deliberated automatically.
JS algorithm here is quite strict, so by default, it is expected that the entered date corresponds to the specific format declared in the locale.
All date-related patterns are specified in the webix.i18n.spreadsheet.formats
The default pattern is “mm/dd/yyyy” (standard for en-US
locale). Unfortunately, any unexpected pattern may be mishandled and provide the mentioned result.
To change only the default date format, you can modify this part of the locale as follows (time is untouched): Code Snippet
The full locale object is provided on our GitHub.
In the UI, the format for data visualization of the specific cell can be selected in the toolbar. Here’s the additional information about changing format via UI (User Guide, regular documentation).
The same can be done through API with the setFormat method: Code Snippet
Still, the overall handling of dates is based on the patterns defined in the locale object.
Regarding another issue,
from that moment on, no value in the entire column F can be edited
Unfortunately, I couldn’t repeat it - all values seem to be accessible.
If I had missed any condition for repeating it, please specify the precise steps to check it.
Editor for dates always has the dropdown calendar, which can be opened by the double-click on a cell.
Please note that the default editor for text/numeric values is the input on top of the grid (liveEditor
can be set to false
to enable inline editing of all cells).