Hi all,
I have now a solution with idea (B) in
https://gerrit.libreoffice.org/c/core/+/195203
Do you have any concerns about solving the problem in this way?
Kind regards,
Regina
Regina Henschel schrieb am 25.11.2025 um 20:03:
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