Hi all,
The problem that it is not clear whether a label line is present or not
also affects bug report Bug 169545 - Data Provider Transformations
Aggregate Functions: Average counts header.
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