xlsx generation with charts, images, automated column width, customizable styles and full schema validation. Axlsx excels at helping you generate beautiful Office Open XML Spreadsheet documents without having to understand the entire ECMA specification. Check out the README for some examples of how easy it is. Best of all, you can validate your xlsx file before serialization so you know for sure that anything generated is going to load on your client's machine.
I created a few simple 2-column pivot tables from a data sheet and in LibreOffice they seem to be sorted by the string value of the first column. In Excel they are all over the place.
Im looking for a way to pre-sort the pivot table by one of the columns.
Is it possible? Since i can only pre-sort the data sheet by one value and can't make it work for multiple pivot tables.
I created a few simple 2-column pivot tables from a data sheet and in LibreOffice they seem to be sorted by the string value of the first column. In Excel they are all over the place.
Im looking for a way to pre-sort the pivot table by one of the columns.
Is it possible? Since i can only pre-sort the data sheet by one value and can't make it work for multiple pivot tables.
Any help would be appreciated.