We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

XlsIo: Bug with conditional formattings and more than one sheet created

Thread ID:

Created:

Updated:

Platform:

Replies:

149527 Nov 28,2019 10:58 PM UTC Dec 17,2019 05:14 PM UTC WinForms 8
loading
Tags: XlsIO
Stefan Falz
Asked On November 28, 2019 11:02 PM UTC

Hi guys,

I'm using the current version of your really great XlsIo component (17.3.0.29) to generate Excel files from the scratch, extend existing files, ...

Currently I'm working with a data list containing a boolean property. The column in the worksheet should display True values with a green background, False values with a red background. No problem with the columns ConditionalFormats property.


This works great if the excel file exists and/or I'm adding only one sheet to an existing file.

But in my case, I must add two, three, ... sheets in one file. And in this case, the conditional formattings in the second, third, ... sheet are lost when saving the file.


I've created a small demo in VB.NET (but happens in C# also) to enable you to reproduce the problem.

It doesn't make any difference if I use the ASP.NET, WinForms, ... component. The problem exists in all platforms.

Thank you in advance.

Best Regards,
Stefan

Stefan Falz
Replied On November 28, 2019 11:03 PM UTC

Test project.

Attachment: ConsoleApp1_3fcfd830.7z

Konduru Keerthi Konduru Ravichandra Raju [Syncfusion]
Replied On November 29, 2019 06:55 AM UTC

Hi Stefan, 

Greetings from Syncfusion. 

We are able to reproduce the reported issue with conditional formats and validating it currently. We will update further details on 2nd December 2019. 

Regards, 
Keerthi. 


Stefan Falz
Replied On November 29, 2019 07:02 AM UTC

Hi Keerthi,

thank you very much.

One additional info: If you double line ExcelHelper.CreateExcel( Arguments2 ) in my test project, all is fine. (In production this is not an option because there are many more columns, rows, formattings, formulas, ...)

Module1.vb
ExcelHelper.CreateExcel( Arguments1 )
ExcelHelper.CreateExcel( Arguments2 )
ExcelHelper.CreateExcel( Arguments2 )

Best Regards,
Stefan

Konduru Keerthi Konduru Ravichandra Raju [Syncfusion]
Replied On December 2, 2019 12:19 PM UTC

Hi Stefan, 

Thanks for your update. 

We are still checking the root cause for the issue. The provided additional information helps us in further validation. We will share the validation details on 3rd December 2019. 

Regards, 
Keerthi. 


Konduru Keerthi Konduru Ravichandra Raju [Syncfusion]
Replied On December 3, 2019 04:57 PM UTC

Hi Stefan, 

Thanks for your patience. 

We have confirmed the issue Conditional Formats are missing while creating more than one worksheets and logged a defect report. We will provide the patch for this issue on 17th December 2019. You can track the status of defect report through the following link. 


Meanwhile we suggest you to close the workbook without parsing the parameter, as a workaround, to overcome the issue and continue your work. 

Code Snippet: 

Existing Code Snippet 
Suggested Code Snippet 
Workbook.Close( True ) 
Workbook.Close() 

Regards, 
Keerthi. 


Stefan Falz
Replied On December 3, 2019 05:31 PM UTC

Hi Keerthi,

thank you very much for your info and the workaround.

I can confirm, calling the Workboook.Close() method without any parameter works as expected and all conditional formattings are saved in all sheets.

Kind Regards,
Stefan


Konduru Keerthi Konduru Ravichandra Raju [Syncfusion]
Replied On December 4, 2019 02:56 PM UTC

Hi Stefan, 

We are glad that the provided workaround helped you. 

We will provide the patch as promised on 17th December 2019. 

Regards, 
Keerthi. 


Konduru Keerthi Konduru Ravichandra Raju [Syncfusion]
Replied On December 17, 2019 05:14 PM UTC

Hi Stefan, 

Thanks for the patience. 

We have fixed the issue Conditional Formats are missing while creating more than one worksheets and generated custom assemblies for the version v17.3.0.29. The custom assemblies can be downloaded from the following link. 


We will include the fix in our release version 17.4-SP1 which will be rolled out by end of January 2020. 

Regards, 
Keerthi. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon