xlsxtream icon indicating copy to clipboard operation
xlsxtream copied to clipboard

Published 20 hours ago • verified publisher icon felixbuenemann

Allow setting number format

Open fsateler opened this issue 5 years ago • 3 comments

Hi,

It would be nice if the number format could be set to something like #,##0 for the whole spreadsheet/book

fsateler avatar Oct 12 '20 15:10 fsateler

Would the setting apply to all numbers or only to decimals?

felixbuenemann avatar Oct 13 '20 12:10 felixbuenemann

I would think to all numbers. As a matter of fact, I would probably set it to #,##0.##### (that is, very similar to the general format, but with thousands separator).

fsateler avatar Oct 13 '20 22:10 fsateler

Hi! If #53 is merged, then what you asked can be achieved by just (a) adding a class to hold number formats (I had put a todo at line 13) and (b) enabling global options to accept num_format key.

gafrom avatar Apr 30 '21 20:04 gafrom