I am trying to apply formatting to the excel cells (both data cells and footer cells) using the cellOptions, footerCellOptions and groupFooterCellOptions. Although the formatting works fine with dataCells, it doesn't gets applied to footerCells.
In my project we have complex template for the footer, I thought that might be the reason its not working, but I created a simple sample project to show what I am trying to achieve.
https://stackblitz.com/edit/angular-qarfdv?file=app%2Fapp.component.ts
https://angular-qarfdv.stackblitz.io
it can be seen here that the dataCells having negative values are getting formatted, but footerCells are not
Although the formula does gets applied, but it shows an error in the cell. ( if you double click on the cell and click out it gets applied)
Appreciate your help
1 Answer, 1 is accepted
Hello Kaustubh,
Please check the answer of this case in the following thread reply:
Regards,
Martin
Progress Telerik