search

microsoft / azuredatastudio-postgresql

azuredatastudio-postgresql is an extension for Azure Data Studio that enables you to work with PostgreSQL databases
Other
196 stars 37 forks source link

Save as Excel creates Excel file where numbers are stored as text #318

Closed steveleish closed 1 year ago

steveleish commented 2 years ago

All Excel spreadsheets created from a query have the numbers stored as text - which makes the resulting spreadsheet a pain to work with.

This happens with all kinds of queries - currently I have only tested this against AWS Postgres instances Version details: PostgreSQL 12.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-11), 64-bit

Steps to repeat:

Execute the following query: SELECT 1 AS testvalue;

In the result panel, select "Save as Excel" option.

Review the created Excel file and the number is stored as text.

Similar happens for much more complex queries / other numeric types.

Version details:

Version: 1.36.1 Commit: e56e1d931bbb110fe8f24751423c4e184bb8f22d Date: 2022-04-21T21:26:00.881Z (4 days ago) VS Code: 1.59.0 Electron: 13.6.6 Chrome: 91.0.4472.164 Node.js: 14.16.0 V8: 9.1.269.39-electron.0 OS: Darwin x64 21.4.0

nasc17 commented 1 year ago

Hello, issue has been addressed in our unstable release of PostgreSQL extension v0.4.3-insiders. We would appreciate your verification that it has been handled appropriately.

nasc17 commented 1 year ago

Bug has been addressed in latest stable release of PostgreSQL extension v0.5.0. Please reopen if issue is still present, thank you.