correctFormat for date is not working

[chunnumunnu99 (Arslan Asif)]

hi I am registering my custom type as below

Handsontable.cellTypes.registerCellType('rawdate', {
editor: Handsontable.editors.DateEditor,
renderer: Handsontable.renderers.DateRenderer,
className: 'htCenter',
dateFormat: 'MM/DD/YYYY',
correctFormat: true,
defaultDate: '01/01/2018',

})

Everything works fine except correctFormat. If I select from calendar the format woks fine. but when I load date or type date manually in any other format it does not change to format specified. I have followed other articles too and tried rendering and using validateCells() after data load through hooks. But noting worked for me. All other formats are just working fine.
code sample (not executable) https://jsfiddle.net/ArslanAsif/w56j2umy/2

[aleksandra_budnik]

Hi @chunnumunnu99

does it work when you call instance.validateCells() after loading the data?
The format does not apply automatically. It needs to be validated.

[chunnumunnu99 (Arslan Asif)]

@aleksandra_budnik thanks for quick response. I followed through these articles

Date-format not working in hot-column directive

I try to format a date column as follows, both with the settings as well as the direct date-format attribute. Neither works. The column type is set to date and the provided data is of type date. <hot-column data="createdAt" title="'Date'" type="'date'" settings="{dateFormat:'DD/MM/YYYY', type: 'date'}" date-format="'DD/MM/YYYY'" correct-format="true" allow-empty="true" read-only></hot-column> The date column would just not format. Other kinds of formatting, such as nume…

How to display date correctly in "DD/MM/YYYY"

Try to add instance.render() method after table initializes. It should rebuild the table and change the format.

I have tried
var hot = new Handsontable(container, hotSettings);
Handsontable.hooks.add(‘afterLoadData’, hot.validateCells);

but noting worked in my case

[aleksandra_budnik]

I’ve filled the missing HTML but still it would be better to analyze if we could fake some data https://jsfiddle.net/AMBudnik/y1rpmj23/
Can you please fill the data with something that has the same format as your real data (array of arrays, array of objects).

ps. I can see that none of those cell types use validator. You may consider adding it as the format won’t work without a validator.

[chunnumunnu99 (Arslan Asif)]

Sorry my mistake. you were right. there was issue with my validator in column definitions Its working fine now thanks

[aleksandra_budnik]

Its working fine now thanks

you’re welcome