search

jjuback / gc-excelviewer

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

Number format for .xlsx file #153

Open Z1Wu opened 3 years ago

Z1Wu commented 3 years ago

There is a setting of number format (Csv-preview: Number Format) in the congiruation of this extension. I change the setting to 'g5' to show 5 significant number. But it seems that this setting only works for .csv format. When I open a .xlsx file, the numerical number still shows 2 significant number. xlsx file in vscode excelviwer extension: image same xlsx file in Windows Excel : image

How can I change the number format for xlsx file? Thank you in advance.

xwjBupt commented 3 years ago

Hi @Z1Wu how did you change the way to show 5 significant number? i do also change the csv-preview number format to g5, but it still only shows 2 number? thank you so much!! image image

BeinerF commented 3 years ago

also does not work for *.csv on my side

Gerrie-Cui commented 3 years ago

@Z1Wu @BeinerF @xwjBupt Have you solved this problem now?