XLSIo and XlsIORenderer, renders are different

[LSE Crew]

hi,

We use your Excel document generator and we have a difference in rendering depending on whether we save in xlsx or if we use the PDF converter.

If we save in XLSX all styles are ok, lines take an automatic height depending on their content, cell formats are automatic, etc.

On the other hand, as soon as we want to save in PDF, we use XlsIoRenderer but in this case many Excel "automations" do not work, in particular those mentioned previously (saving in xlsx).

 

I am attaching the C# code (  Generator.zip ) and two example screenshots :

Excel XLSX : it's ok

XlsIoRender PDF : it's not OK

Thx

Attachment: Generator_ffeae2f8.zip

[Atchaya Sekar]

Hi Castandet,

 

Could you please share the input Excel document so we can validate the reported issue from our end? It will help us proceed further and provide assistance.

 

Regards,

Atchaya S.

[LSE Crew]

hi,

Here is the model

thx

Attachment: template_40bcdf20.zip

[Atchaya Sekar]

Hi Castandet,

 

Could you please share the document in which the issue is occurring? This will help us reproduce and diagnose the issue more effectively, as we are currently unable to reproduce it with the provided input template.

 

Regards,

Atchaya S.

[LSE Crew]

hi,

I am attaching the files hoping that this is what you are expecting.

thx.

Attachment: File_15c0ff85.zip

[LSE Crew]

An another example.

thx

Attachment: Recap_c8b85901.zip

[Atchaya Sekar]

Hi Castandet,

Regarding the document named "File_15c0ff85"	We are unable to reproduce the issue at our end. We have attached the working sample tried at our end. We request you modify the sample to reproduce the issue. It will help us to proceed further and provide.
Regarding the document named "Recap_c8b85901"	We have reproduced the reported issue at our end and validating it currently. We will share the validation details on August 01, 2024.

Regards,

Atchaya S.

Attachment: ForumPDFConversion_d23b5373.zip

[LSE Crew]

hi,

I'm going on vacation and I'll get back to you with a specific case as soon as I get back.

thx

[Atchaya Sekar]

Hi Castandet,

Have a great vacation!

Regarding the document named "File_15c0ff85"	We’ll be here and look forward to hearing from you when you're back.
Regarding the document named "Recap_c8b85901"	Due to the complexity of the issue, we are unable to share details today. We will share details on August 2, 2024.

Regards,

Atchaya S.

[Atchaya Sekar]

Hi

 

Sorry for the inconvenience, currently we are validating this, we will share the further validation details on August 5, 2024.

 

Regards,

Atchaya S.

[Atchaya Sekar]

Hi Castandet,

 

We have confirmed the issue as "Cell text in the pivot table is incorrectly rendered in bold while converting Excel to PDF" and logged a defect report. We will include the fix for this issue in our upcoming weekly NuGet release scheduled for August 20, 2024.

 

You can track the status of the defect report through feedback link.

 

 

Regards,

Atchaya S.

[Atchaya Sekar]

Hi Castandet,

 

We have resolved the font bold issue that you reported. However, we have identified an existing issue with the PivotTable range from A$9:$D$10 and A$11:$A$13, where conditional formatting is applied, causing the bold font properties to be ignored. We have logged this as a defect report. A fix will be provided to you on September 3rd via a custom patch.

You can track the status of the defect report through the feedback link

 

If you would like to verify the fix before the next release, please let us know if you are interested in receiving a custom patch.

 

Regards,

Atchaya S.

[Atchaya Sekar]

Hi Castandet,

Regarding "Cell text in the pivot table is incorrectly rendered in bold while converting Excel to PDF"

We have included the fix to resolve the issue "Cell text in the pivot table is incorrectly rendered in bold while converting Excel to PDF " in our weekly NuGet release version 26.2.12. Kindly upgrade your Syncfusion packages to this new 26.2.12 version and let us know if the issue is resolved.   NuGet Package:NuGet Gallery | Syncfusion.XlsIO.Net.Core 26.2.12     Root cause for this issue:   While converting an Excel file to PDF, if the pivot table includes a grand total and a specific pivot table style is applied, XlsIO does not handle the font style correctly, resulting in the cell text in the pivot table being rendered as bold.

Regarding  PivotTable range from A$9:$D$10 and A$11:$A$13, where conditional formatting is applied, causing the bold font properties to be ignored.

We apologize for the inconvenience. We are unable to include the fix for this issue in today's  weekly release.However, this fix will be included in the next weekly release scheduled for September 10, 2024. We have attached the custom NuGet package below for this issue; please refer to it.

Regards,

Atchaya S.

[Atchaya Sekar]

Hi Castandet,

 

We appreciate your patience.

 

We have included the fix for both issues ("Cell text in the pivot table is incorrectly rendered in bold while converting Excel to PDF" and "PivotTable range from A$9:$D$10 and A$11:$A$13, where conditional formatting is applied, causing the bold font properties to be ignored") in our weekly NuGet release, version 26.2.14. Kindly upgrade your Syncfusion packages to this new version 26.2.14 and let us know if the issue is resolved.

 

NuGet Package:NuGet Gallery | Syncfusion.XlsIO.Net.Core 26.2.14 

 

Root cause for this issues:

 

1.While converting an Excel file to PDF, if the pivot table includes a grand total and a specific pivot table style is applied, XlsIO does not handle the font style correctly, resulting in the cell text in the pivot table being rendered as bold.

 

2.When converting an Excel file to PDF, if a cell contains both a pivot table and conditional formatting, the XlsIO default applies the conditional format to the cell. However, in Microsoft Excel, the pivot table formatting is applied, causing cells with bold formatting to be missing in the PDF conversion.

 

 

Regards,

Atchaya S.