Conversion excel to PDF giving exception Index out of bounds.

during the conversion of a excel file to pdf, it was throw the exception "The index was out of bounds [...] [ Name of parameter: Index ]".

The excel is a model that uses tags to fill through code, then we convert the result to pdf. Attached I will the result that should be converted to pdf.

Hi Cláudio, 

Greetings from Syncfusion. 

We are able to reproduce the reported issue and validating it currently. We will share the validation details on 24^th January 2020. 

Regards, 

Keerthi. 

Hi Claudio, 

Thank you for your patience. 

We confirmed the issue with “Exception throws while ExcelToPDF conversion on creating PivotTable only with Row Fields” is a defect and logged a defect report for the same. The patch for this issue is estimated to be available on 7^th February 2020. You can track the status of defect report through following feedback link. 

 

https://www.syncfusion.com/feedback/11512/exception-throws-while-exceltopdf-conversion-on-creating-pivottable-only-with-row 

 

Regards, 

Abirami 

Hi Cláudio, 

Thanks for your patience. 

We have fixed the issue Exception throws while ExcelToPDF conversion on creating PivotTable only with Row Fields and generated patch in the version v17.4.0.39.  

We suggest you to use the patch with following code snippet. 

Code Snippet: 

The patch with fix to resolve the reported issue can be downloaded from the following link. 

Recommended approach - exe will perform automatic configuration       

   

Please find the patch setup from below location:       

http://syncfusion.com/Installs/support/patch/17.4.0.39/911214/F150841/SyncfusionPatch_17.4.0.39_911214_2072020055156772_F150841.exe  

       

Advanced approach – use only if you have specific needs and can directly replace existing assemblies for your build environment       

   

Please find the patch assemblies alone from below location:       

http://syncfusion.com/Installs/support/patch/17.4.0.39/911214/F150841/SyncfusionPatch_17.4.0.39_911214_2072020055156772_F150841.zip  

NuGet : http://syncfusion.com/Installs/support/patch/17.4.0.39/911214/F150841/SyncfusionNuget_17.4.0.39_911214_2072020055156772_F150841.zip  

     

Assembly Version: 17.4.0.39 

Installation Directions :        

This patch should replace the files “Syncfusion.XlsIO.Base.dll” under the following folder.       

$system drive:\ Files\Syncfusion\Essential Studio\$Version # \precompiledassemblies\$Version#\4.6       

Eg : $system drive:\Program Files\Syncfusion\Essential Studio\17.4.0.39\precompiledassemblies\17.4.0.39\4.6    

       

To automatically run the Assembly Manager, please check the Run assembly manager checkbox option while installing the patch. If this option is unchecked, the patch will replace the assemblies in precompiled assemblies’ folder only. Then, you will have to manually copy and paste them to the preferred location or you will have to run the Syncfusion Assembly Manager application (available from the Syncfusion Dashboard, installed as a shortcut in the Application menu) to re-install assemblies.       

       

Note :        

You can change how you receive bug fixes by navigating to the following link and updating your preferences.        

https://www.syncfusion.com/support/directtrac/patches  

    

Disclaimer :   

Please note that we have created this patch for version 17.4.0.39 specifically to resolve the issues reported in forum 150841.      

              

If you have received other patches for the same version for other products, please apply all patches in the order received.       

      

This fix will be included in our release version 18.1 which will be rolled out by end of March 2020.  

Regards,     

Keerthi.