search

best-practice-and-impact / gptables

Good Practice Tables - an XlsxWriter wrapper to write consistently formatted statistical tables to Excel.
http://gptables.rtfd.io
Other
35 stars 4 forks source link

Number formats #218

Open ldavies99 opened 1 year ago

ldavies99 commented 1 year ago

Is your feature request related to a problem? Please describe. The data contained in the gptables tables are in a 'general' format when I want the data to be in a 'number' format.

Describe the solution you'd like A way to set the number format of the data in the tables.

Additional context I believe this could be done by adding set_number_format() to the available additional formatting options.

ldavies99 commented 1 year ago

I've tried to use set_number_format() in additional formatting but have found that it is not possible when there are mixed data types in the column.

rowanhemsi commented 1 year ago

May require a different way of handling shorthand in order to support this

ldavies99 commented 2 months ago

The data in a column cannot be set to a number format if it contains short hand notation but can otherwise.