xlsgen 4.9 adds the following support to LibreOffice/OpenOffice files :
- read existing pivot tables
- write pivot charts (introduced in libre office 5.4.1)
- read cell data validations
- read auto filter and custom filters
- improved writing of custom filters