gc-excelviewer icon indicating copy to clipboard operation
gc-excelviewer copied to clipboard

Published 20 hours ago • verified publisher icon jjuback

Scientific notation?

Open znd4 opened this issue 7 years ago • 4 comments

It would be nice to have scientific notation (maybe something that could be toggled on and off)

znd4 avatar May 30 '18 13:05 znd4

There is now a setting that lets you specify a .NET-style format string for numbers: csv-preview.numberFormat. It defaults to g2, which uses fixed-point or scientific notation, whichever is more compact. You can also use the e format to force scientific notation everywhere. If present, the digit refers to the number of significant digits.

jjuback avatar Jun 20 '18 19:06 jjuback

I just learned that we don't support the e format for scientific notation. See this page for information on supported formats.

jjuback avatar Jun 22 '18 14:06 jjuback

Please, fix this. Adding support to scientific notation is not so hard..

reinert avatar Mar 29 '19 12:03 reinert

Any update on this? I've noticed that scientific notation does not show up correctly when I open excel files.

AlexVillarra avatar Aug 05 '20 10:08 AlexVillarra