I have a requirement to create a report in the form of an excel spreadsheet from data in an OutSystems Reactive application. Advanced Excel covers almost all of the tasks I need to do this (cell formatting, row insertion, conditional formatting), but does not facilitate range sorting as far as I can see. I know that I can just sort the aggregate prior to loading into Excel with Record List to Excel, but given that I believe EPPlus supports range sorting, I was wondering if there were any plans to expose that facility in the Advanced Excel component?
Hi @Matthew Fyleman,
Good suggestion and you're right that EPPlus supports it. I've checked it against the version the component uses and range sorting works there, including multi-column sorts, with cell formatting correctly following its row.
I'm adding a Worksheet_SortRange action: you give it a range, one or more columns to sort by (each ascending or descending), and a flag for whether the range includes a header row so it's kept in place rather than sorted into the data. That last part matters — sorting a range that includes its header will otherwise shuffle the header in with the rows.
It'll be in an upcoming release.
Hi @Matthew Fyleman, check version 2.11.0 that I just released and check the new Worksheet_SortRange action. Hope it helps ;)