search

jjuback / gc-excelviewer

Visual Studio Code extension for viewing Excel spreadsheets and CSV files.
Other
218 stars 41 forks source link

Scientific notation? #66

Open znd4 opened 6 years ago

znd4 commented 6 years ago

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

jjuback commented 6 years ago

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 commented 6 years ago

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

reinert commented 5 years ago

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

AlexVillarra commented 4 years ago

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