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.

Thu Nov 17, 2022 3:51 pm

Hi,

following example code + test file produces unexpected behavior:

Code: Select all
using (MemoryStream outputStream = new MemoryStream())
{
    Workbook workbook = new Workbook();
    workbook.LoadFromFile("Test.xlsx");
    workbook.Worksheets[0].SaveToStream(outputStream, ";", Encoding.UTF8);
    Console.WriteLine(Encoding.UTF8.GetString(outputStream.ToArray()));
}


IF the formula in column B evaluates to a non-empty string, the generated CSV will render this string as expected.
If the formula in column B evaluates to an empty string, then the generated CSV will render the formula itself instead of an empty string.

Exptected output:
Code: Select all
Row 1;ok
Row 2;


Generated output:
Code: Select all
Row 1;ok
Row 2;"=IF(A2=""Row 1"",""ok"","""")"


KR,
Gerhard
Attachments
Test.zip
(6.28 KiB) Downloaded 154 times

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

Fri Nov 18, 2022 6:17 am

Hello,

Thanks for your inquiry.
I reproduced your issue and logged it into our bug tracking system with the ticket number SPIREXLS-4297. Our development team will investigate and fix it. Once it is solved, I will inform you in time. Sorry for the convenience caused.

Sincerely
Doris
E-iceblue support team
User avatar

Doris.Liu
 
Posts: 66
Joined: Mon Nov 07, 2022 8:10 am

Fri Dec 23, 2022 8:35 am

Hi,

Thanks for your patient waiting.
Glad to inform you that the reported issue SPIREXLS-4297 has been resolved and the hotfix (Spire.XLS Pack Hotfix Version:12.12.3) is available. Please download it from the following link.
Website download link: https://www.e-iceblue.com/Download/download-excel-for-net-now.html
Nuget download link: https://www.nuget.org/packages/Spire.XLS/12.12.3

Sincerely,
Doris
E-iceblue support team
User avatar

Doris.Liu
 
Posts: 66
Joined: Mon Nov 07, 2022 8:10 am

Return to Spire.XLS