[13.0] Extend cell types

[tabuna]

Is your feature request related to a problem? Please describe.

I often have to show values in a specific format. For example, some number is like a currency. Or a date in a specific format. Each time ->render is used, it can cause a negative result (if you do not take out the transformation separately). It would be great if Orchid could set the cell type like in Microsoft Excel or Apple Numbers.

Number (Decimals, Thousand Separator)

Used for general display of numbers. You can specify the number of decimal places you want to use, whether you want to use a thousand separator.

100 000

100000

100 000,01

Currency (Decimal places, Thousand separator, Accounting style, Symbol)

Used for general monetary values and displays the default currency symbol with numbers. You can specify the number of decimal places you want to use, whether you want to use a thousand separator.

10 000,00 $

$ 10 000

Percentage (Thousand separator, Decimal places)

1,01 %

Date and time (Format)

2020-10-03 14:36:32

03.10.2020 14:36:32

Duration (Units: Weeks, Days, Hours, Minutes, Seconds)

1w 3d 0h 0m 0s

0w 3d 0h 0m 0s