Hi all,
in my ongoing work to collect the sorting methods in Calc
(https://wiki.documentfoundation.org/Faq/Calc/Sorting_in_Calc) I have
seen the sort transformation in the dialog "Data Provider..." in menu
Data. This transformation has several problems. One of these problems
is, that the user currently cannot determine whether the to be sorted
data has a label row or not.
I can imagine these ways to solve the problem:
(A)
Extend the sort item in the dialog (where you determine
ascending/descending and the index of to be sorted column) by a checkbox
for `my data has a label row`.
(B)
Use the setting of the database range. A database range is mandatory for
a Data Provider.
(C)
In case of a csv-file as source, always treat the first row as label.
Other ideas?
What idea would you prefer?
Kind regards,
Regina
