sheetjs icon indicating copy to clipboard operation
sheetjs copied to clipboard

Identify the Format type using the format String

Open jasdeep-compro opened this issue 4 years ago • 1 comments

Is it possible to identify the type of format using the format string ? For examples, i would like to have a function like:

SSF.getFormat("m-d-yy h:mm;@") should return "Date"

Similarly, SSF.getFormat("(* #,##0.00);(* (#,##0.00);(* "-"??);(@_)") should return "Accounting"

This is in context with what is displayed in the Ribbon Format Dropdown.

Please let me know, if there is any existing function to support this or is it in your road map for future enhancements.

jasdeep-compro avatar Dec 22 '20 06:12 jasdeep-compro

SSF.is_date(fmt) will test if a format is a date.

reviewher avatar Mar 10 '22 10:03 reviewher