How to properly format the total row in PHPExcel?

Question

PHP

Let's say we need such a sign:

Additionally, we need filters in the header, I do everything like this:

$objPHPExcel = new PHPExcel();

        $objPHPExcel->setActiveSheetIndex(0);

        $active_sheet = $objPHPExcel->getActiveSheet();

        $active_sheet->setCellValue('A3', '№');
        $active_sheet->setCellValue('B3', 'Товар');
        $active_sheet->setCellValue('C3', 'Цена');

        $active_sheet->setAutoFilter('A3:C3');

        $active_sheet->setCellValue('A4', '1');
        $active_sheet->setCellValue('B4', 'Товар 1');
        $active_sheet->setCellValue('C4', '200');

        $active_sheet->setCellValue('A5', '2');
        $active_sheet->setCellValue('B5', 'Товар 2');
        $active_sheet->setCellValue('C5', '500');

        $active_sheet->setCellValue('A6', '3');
        $active_sheet->setCellValue('B6', 'Товар 3');
        $active_sheet->setCellValue('C6', '120');

        $active_sheet->setCellValue('A7', '4');
        $active_sheet->setCellValue('B7', 'Товар 4');
        $active_sheet->setCellValue('C7', '245');

        $active_sheet->setCellValue('A8', '5');
        $active_sheet->setCellValue('B8', 'Товар 5');
        $active_sheet->setCellValue('C8', '130');

        $active_sheet->setCellValue('A9', 'Итог');
        $active_sheet->setCellValue('C9', '=SUM(C4:C8)');

        $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

        header("Content-Type:application/vnd.ms-excel");
        header("Content-Disposition:attachment;filename=simple.xls");

        $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
        $objWriter->save('php://output');

        exit();

We get the table:

Everything would be fine, but when choosing a filter: The

final row also falls under filtering, and if you apply a filter by price, for example, the amount in the final row does not change..
How to properly implement a table with filters and a row of totals?

Answer 1

You need to use the SUBTOTAL function:
en.stackoverflow.com/questions/455156/%D0%9A%D0%B0...