Menu
It looks like you can only choose 3 criteria from Data -> Sort. Is there a way (potentially programmatic) to use additional criteria?
324
Just as in a spreadsheet, Writer allows data in a table to be sorted. Up to three levels of sorting can be specified (for example, sort first by age numerically, then alphabetically by name within each age).
You can use either Data → More Filters → Standard Filter… to define multiple criteria and ranges, which for a bunch of ranges can be quite tedious, or you set up an Advanced Filter where you can easily define and modify filter criteria in a range of spreadsheet cells and then with the data range selected (or just the ...
Calc provides three types of filter: Standard – specifies the logical conditions to filter your data. AutoFilter – Automatically filters the selected cell range and creates one-row list boxes where you can choose the items that you want to display. Advanced – uses filter criteria from specified cells.
No, without adjusting the code it is not possible to do that. In theory it should be quite easy to adjust this and remove this limitation. For the 3-5 release a voluteer did something similar already for conditional formatting.
The code is in http://opengrok.libreoffice.org/xref/core/sc/inc/sortparam.hxx but it is not just done with increasing MAXSORT. There needs to be a according change in the ui too and ideally switching to a std::vector or another dynamic datastructure. This is an easy task and I just created https://bugs.freedesktop.org/show_bug.cgi?id=45747 for this. So if you wanna join in Libreoffice development you can easily do this.
187
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
