Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Mar 16, 2022 9:41 am

Hi,

after nuget upgrade workbook.SaveToStream does not convert to CSV as expected. It worked until version 10.10.6 Starting from version 10.11.2 the conversion fails.

test3.zip
(6.3 KiB) Downloaded 89 times


Code: Select all
            MemoryStream stream = new MemoryStream();
            Workbook workbook = new Workbook();
            workbook.LoadFromFile("test3.xlsx");
            workbook.SaveToStream(stream, ";");
            Console.WriteLine("==========");
            Console.WriteLine(Encoding.UTF8.GetString(stream.GetBuffer()));
            Console.WriteLine("==========");
            Console.ReadKey();


Output of version 10.10.6:
Code: Select all
1,00
(1,00)


Output of version 10.11.2:
Code: Select all
"1,00"
"(1,00)


* Why are there double quotes I did not request?
* Double quotes of second number is not closed correctly.

KR,
Gerhard

P.S.: This is the third bug I am reporting for the version upgrade from 10.10.6 to 10.11.2. There's a fourth one I did not even report because there was an easy workaround to apply at our side. Something went terribly wrong in development. I am starting to feel as a beta tester.

GerhardFinee
 
Posts: 26
Joined: Thu Nov 07, 2019 7:57 am

Thu Mar 17, 2022 3:01 am

Hello,

Thank you for your inquiry.
I tested your Excel file and did reproduce the issue you mentioned. I have logged the issue into our bug tracking system with the ticket number SPIREXLS-3742. Our development team will investigate and fix it. Once it is resolved, I will inform you in time. Sorry for the inconvenience caused.

Sincerely,
Annika
E-iceblue support team
User avatar

Annika.Zhou
 
Posts: 1643
Joined: Wed Apr 07, 2021 2:50 am

Fri Apr 15, 2022 9:55 am

Hello,

Thanks for your patience.
Glad to inform you that we just released Spire.XLS Pack(Hotfix) Version:12.4.1, which fixes the issue of SPIREXLS-3742. Please download the new version from the following links for testing.

Website link: https://www.e-iceblue.com/Download/download-excel-for-net-now.html
NuGet link: https://www.nuget.org/packages/Spire.XLS/12.4.1

Sincerely,
Annika
E-iceblue support team
User avatar

Annika.Zhou
 
Posts: 1643
Joined: Wed Apr 07, 2021 2:50 am

Return to Spire.XLS