# Change Log

## Version 8.0.0
1. Add `rowGroup` property for exporting Table widget to excel and big spreadsheet.
2. Fix Chart bug not showing in MS Excel since PHPSpreadsheet 1.10

## Version 7.2.0
1. Several bug fixes for chart axis and big spreadsheet's column setting.
2. Add more axis options for excel chart.
3. Add "hideChartDataSheet" setting when exporting with excel template.
4. Update "phpoffice/phpspreadsheet" and "box/spout" versions.

## Version 7.1.1
1. Fix bug for ExportHandler when data is empty.

## Version 7.1.0
1. Fix `PieChart` and some single-series charts to be correct format in MS Office.

## Version 7.0.0
1. Add BigSpreadsheetDataSource to read huge excel, ods and csv files.
2. Add BigSpreadsheetExportable trait to export to huge excel, ods and csv files.

## Version 6.0.0
1. Change excel template file from <file>.excel.php to standard <file>.view.file
2. Add "filtering", "sorting", "paging", "showHeader", "showBottomHeader", "shotFooter", "map" and "excelStyle" to Excel's Table widget
3. Add "hideSubTotalRows", "hideSubTotalColumns", "hideGrandTotalRow", "hideGrandTotalColumn", "showDataHeaders" and "excelStyle" to Excel's PivotTable widget
4. Add Excel's Text widget

## Version 5.1.0
1. Internal: move functions from exportable trait to export handler object to prevent polluting report object
2. Fix excel export column order problem

## Version 5.0.0

1. Export to Excel using php template file.
2. Support text, table, pivot table and multiple chart types in template export.
3. Customize style including font, alignment, border and fill for text, table.

## Version 3.2.0

1. CSVExportable: Adding BOM options.

## Version 3.0.0

1. CSVExportable: New trait allows exporting to CSV files.
2. Add option like 'columns' for ExcelExportable.

## Version 2.1.0

1. ExcelDataSource: Add: sheetName and sheetIndex properties for loading only those sheets.