Formatting rowHeaders with timestamps

Tags: #<Tag:0x00007f8b2a1643f8>
#1

Hi,

I am using handsontable to display timeseries data and the rowHeaders contain a timestamp.
At this point I am creating a string with the formatted date on our servers (i.e. ‘14.03.19 08:00:00’) and add this array into the rowHeaders.

I was wondering if it would also be possible to use the timestamp in milliseconds (i.e. 1552550400000) and let handsontable to the formatting dynamically. Are there any options to format the row/colHeaders in a similar manner to the capabilities of formatting the actual data in the table?

Thanks
Nils

#2

Hello,

Unfortunately headers don’t have cells features. You can use function as rowHeaders option to return formatted strings. Or format them just after ajax request / handsontable initialization.

Kind regards,
Wojciech

#3

Hi,

thanks for the answer. My tables are large (usually 20k+ rows) so I am not sure how well this might perform.

For the time being I just tweaked the API output.

Thanks.
Nils

#4