igniteui-angular

igniteui-angular copied to clipboard

Is your feature request related to a problem? Please describe.

I want IgxExcelExporterService to format the cells in excel exactly how I display them on the grid. I use ng-template to display cells in the grid.

However, when I download excel all the formatting done by me is removed as the IgxExcelExporterService uses cell.value of igxCell.

Describe the solution you'd like

I would like to provide custom formatting in excel for columns for which I have custom formatting enabled in the grid. For ex: We can provide the formula for formatting the values. For the above template, the excel formula would be 0.00X;(0.00X)

Describe alternatives you've considered

If somehow the final values were to be modified according to our formatting just before generating the excel file.

Additional context

If the solution would only format the column we provide and format the rest of the columns the existing way, would be great.

@hanastasov can you let us know if this is possible/ can be considered as a feature request? or you can suggest us some alternative way.

Our clients want the excel export to have summaries, row grouping, and column grouped header in the excel export.

@hanastasov can you let us know if this is possible/ can be considered as a feature request? or you can suggest us some alternative way.

Our clients want the excel export to have summaries, row grouping, and column grouped header in the excel export.

@igdmdimitrov maybe you can give more information on these questions.

Hello @KaushikEDS,

By looking at your issue, the best way to achieve what you described is by providing a formatter to the igx-column you want to format. I've created a sample for you to check how this can be done.

Hi, I understand about formatter, but what about having summaries in the excel export as well? Can we have summaries in excel export as well?

Hi @amitmoondra we have created a new feature request for supporting of summaries in the excel exporter.

this is great, thank you @radomirchev

There has been no recent activity and this issue has been marked inactive.