Excel borders

[Charles Eichelberger]

Hi, I have an issue where excel borders are not showing up, even though I define them in the excelHeaderQueryCellInfo fucntion. Below is the function and the excel output. Attached is the full code for review.

Attachment: report.component_5df4bad6.zip

[Balaji Sekar]

Hi Charles, 

Greetings from the Syncfusion support. 

Currently we are working your query with provided the information and we will update further details on December 15, 2021 

Until then we appreciate your valuable patience. 

Regards, 

Balaji Sekar. 

[Charles Eichelberger]

Hello,

Thank you for the update I look forward to more details and information.

Thanks,

Charles

[Balaji Sekar]

Hi Charles, 

Thanks for your valuable patience. 

We have validated the provided information and we have confirmed it as a bug and logged the defect report “Border is disappear in Excel exporting”. Thank you for taking the time to report this issue and helping us improve our product. At Syncfusion, we are committed to fixing all validated defects (subject to technological feasibility and Product Development Life Cycle ) and including the defect fix in our upcoming weekly release which is expected to be rolled out on 5^th January 2022. 

    

You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link.    

    

Feedback Link: https://www.syncfusion.com/feedback/31317/border-is-disappear-in-excel-exporting

 

Regards, 

Balaji Sekar. 

[Charles Eichelberger]

Hi,

Thank you for the update. Good to know that it is being worked on and is expecting to be fixed soon!

Thanks,

Charles

[Balaji Sekar]

Hi Charles, 

We have achieved the Border disappear in the Excel exporting in sample level and we suggest you to define the lower case value in style.borders.lineStyle like “thin” instead of “Thin”. Please refer the below code example sample for more information. 

[app.component.ts] 

  excelHeaderQueryCellInfo(args) { 

    args.style = { 

      backColor: '#90AFC4', 

      fontColr: '#003f74', 

      hAlign: 'Center', 

      borders: { color: '#000000', lineStyle: 'thin', bold: true }, 

    }; 

  } 

Sample link: https://stackblitz.com/edit/angular-ecdrhy-h38hin?file=app.component.ts 

Please get back to us, if you need further assistance. 

Regards, 

Balaji Sekar.

[Charles Eichelberger]

Hi,

I can confirm changing the input args from ExcelQueryCellInfoEventArgs to any and changing the lineStyle to lowercase has fixed the issue.

Thank you,

Charles

[Balaji Sekar]

Hi Charles, 

  

Thanks for the update. 

  

We are happy to hear that your issue has been resolved. 

  

Please get back to us if you need further assistance. 

  

Regards, 

Balaji Sekar. 

[Sujith Kumar Rajkumar]

Hi Charles, 

 

Due to some internal complexities we could not include the fix for the issue as promised. We are currently working on it with high priority and will include it in our weekly patch release scheduled to be rolled out by 19^th January 2022. We apologize for the inconvenience caused and appreciate your patience. 

  

Until then we suggest you to use the workaround solution provided in our previous update. 

 

Regards, 

Sujith R 

[Sujith Kumar Rajkumar]

Hi Charles, 

 

Due to some internal complexities we could not include the fix for the issue as promised. We are currently working on it with high priority and will include it in our weekly patch release scheduled to be rolled out by the end of January 2022. We apologize for the inconvenience caused and appreciate your patience.  

   

Until then we suggest you to use the workaround solution provided in our previous update.  

  

Regards,  

Sujith R 

[Sujith Kumar Rajkumar]

Hi Charles, 

 

Thanks for your patience. 

 

We are glad to announce that our Essential Javascript2 Volume 4 SP release (v19.4.48) has been rolled out successfully and in that release we have added the fix for this issue. So please update your packages to this version to include this fix. 

 

Now you can refer the ‘ExcelHeaderQueryCellInfoEventArgs’ and ‘ExcelQueryCellInfoEventArgs’ argument types itself for the excelHeaderQueryCellInfo and excelQueryCellInfo events respectively and the type issue for border line style will not occur. 

 

We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance. 

 

Regards, 

Sujith R