🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

Firefox field auto-formatting problem

Answered
Ben RABIER asked on December 4, 2020

HI,
We encounter a strange phenomenon under firefox, we have a column with a text type field “2020/12/1” (it is not a date, it is an invoice number) and Flexmonster explodes this field into three fields <FIELD NAME> .YEAR <FIELD NAME> .MONTH and <FIELD NAME> .DAY

Only under firefox (not chrome)
How to prevent this?
 
Thanks for your help

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster December 7, 2020

Hello,
 
Thank you for reaching out to us.
 
We want to explain that Flexmonster tries to infer the field’s data type automatically if it is not explicitly specified.
The component relies on the browser when parsing dates. In its turn, Firefox supports the wider list of date formats. It leads to a false-positive result when trying to parse the “NUMERO F” field as a date.
 
To avoid this behavior, define the data type of this field as string. Fields’ data types should be defined in the mapping object as described in our documentation.
 
We hope it works for you.
 
Regards,
Illia

Please login or Register to Submit Answer