Excel number format

[Zanzacar]

Issue Type: Bug

Before updating to this current version I was able to save a report to excel and the numbers would be saved as numbers. However now that I have updated when I run the same report and save as excel it comes in as text for some reason. Switching it back seems to be problematic.

Azure Data Studio version: azuredatastudio 1.35.0 (e9c8eb8, 2022-02-23T17:36:02.883Z)
OS version: Windows_NT x64 10.0.19044
Restricted Mode: No

System Info

Item	Value
CPUs	Intel(R) Core(TM) i7-8850H CPU @ 2.60GHz (12 x 2592)
GPU Status	2d_canvas: enabled gpu_compositing: enabled multiple_raster_threads: enabled_on oop_rasterization: enabled opengl: enabled_on rasterization: enabled skia_renderer: enabled_on video_decode: enabled vulkan: disabled_off webgl: enabled webgl2: enabled
Load (avg)	undefined
Memory (System)	31.76GB (18.84GB free)
Process Argv
Screen Reader	no
VM	50%

Extensions (1)

Extension	Author (truncated)	Version
azdata-sanddance	msr	3.3.0

[cympaulife]

having the same issue also

[Zanzacar]

having the same issue also

As a quick solution you can export to csv then open it in excel and save as an excel document. Isn't great but got the job done for me without having to fuss around with cell formats or whatever else.

[PVanOste]

This issues is resulting in downstream problems, and needs to be addressed quickly.

[alanrenmsft]

@Zanzacar Thanks for reporting the issue, a new version with the fix for this issue should be available later this week.

[cheenamalhotra]

Closing as issue had been fixed.