Hello Andrew,

To apply bold formatting to summary cells when exporting a grid to Excel, you can utilize the summaryExporting event. This event provides access to each summary cell, allowing you to format it individually during the export process.

The key to achieving this is correctly identifying the summary row’s position in the exported worksheet. This is done by calculating the actual row index using summaryRowIndex + xlRowIndex. The summaryRowIndex represents the summary iterative position within the column, while xlRowIndex accounts for its placement in the Excel worksheet.

Once the correct row is determined, the specific column index (columnIndex) is used to locate the exact summary cell within that row. The formatting is then applied by retrieving the cell and setting its font to bold using row.getCellFormat(columnIndex).font().bold(1). This ensures that only the relevant summary cells are affected, rather than formatting the entire row.

Here is the code implementation:

{
                        summaryExporting: function (sender, args) {
                            var worksheet = sender._worksheet; // Get the worksheet object
                            var targetRowIndex = args.summaryRowIndex + args.xlRowIndex; // Calculate the correct summary row index
                            var columnIndex = args.columnIndex; // Get the column index

                            if (worksheet && targetRowIndex >= 0) {
                                var row = worksheet.rows(targetRowIndex); // Access the correct row in the worksheet

                                if (row) {
                                    row.getCellFormat(columnIndex).font().bold(1); // Bold the specific cell in the summary row
                                }
                            }
                        }
 }

Best Regards,
Arkan Ahmedov,
Infragistics