Number formatting in the XLS export

12 views
Skip to first unread message

Q&A Bot

unread,
Oct 26, 2022, 10:42:53 AM10/26/22
to seektab...@googlegroups.com

Q:  is there a way to force the number formatting of the fields in the XLS export? Namely, we'd want them to be formatted as numbers, so that they always have two digits after the comma, e.g. 2799.9 -> 2,799.90. 

Dimensions with number values are exported to Excel as numbers, and their SeekTable formatting ("Format" specifier) is converted to Excel format equivalent if present. 
You can set desired "Format" either in the cube configuration (for all reports) or for the concrete report (use 'gear' icon next to "Columns" or "Rows"). In particular, to force 2 digits after the decimal point you may specify {0:0.00} or, if you want a thousands separator, {0:#,##0.00} :
image.png


In SeekTable values are formatted with standard .NET String.Format (+ some custom format specifiers), so all format specifiers that may be used with String.Format can be used in SeekTable.

Reply all
Reply to author
Forward
0 new messages