Identify the Format type using the format String #2601

New Issue

2020-12-22T06:49:46Z

jasdeep-compro commented

2020-12-22 06:49:46 +00:00

(Migrated from github.com)

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.

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.

reviewher commented

2022-03-10 10:19:51 +00:00

(Migrated from github.com)

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

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

Sign in to join this conversation.