There's a long time ago (in a galaxy far far away ;-) old Excel versions had a very useful feature for list.
Anywhere on the sheet, you did start your list by writing column headers.
On the second line, you did create line template buy adding functions, formatting or conditional formatting in each cell.
Then you selected the 2 lines and define them as a list.
So the second line did start with a * to indicate this is the entry line.
Then you entered your datas in * line and validate. The line added under the header line and the * line. You entered other datas, validate again and a second line added between first line and * line. And so on…
List completing was useful as it was automated and you could avoid a lot of errors.
More : you could use an automated total line at the end of the list (with classical functions like SUM…) which recalculated each time you add, suppressed or modified a line.
And I don't remember well but perhaps sub-total feature was working too…
I know that managing list should be better in Base but many times it is quicker and simpler to start and use it in spreadsheet. So, this would be a great thing if you could bring this feature back to life in Calc.
Thanks for your attention and be the force with you ;-)
(If needed, I could create a draw to show you.)
UX: yay or nay?
Sorry I've juste made a mistake in my description. Third paragraph : i wrote "The line added under the header line and the * line." The right sentence is : The line added BETWEEN the header and the * lines.
The * line is still the last one. But there could be an option for it is the first one (or the one just under the header line).
Another thing is list could be sorted at anytime.
We're replacing our use of the 'ux-advise' component with a keyword:
Component -> LibreOffice
Add Keyword: needsUXEval
(In reply to charled from comment #0)
> (If needed, I could create a draw to show you.)
Please do so. But be prepared to get referred to extensions, solver, Base etc. On the first glance it sounds not in-scope.
Created attachment 127886 [details]
Entry line for coml-pleting lists
Hope this helps…
Nay from my side since this feature would be another hidden gem. However, an extension or macro could serve this purpose well. Would need to clarify use case and requirements, though.
Keeping ticket as NEW with UX in CC, other opinions are welcome.
Please add keyword 'needsUXEval' and CC 'firstname.lastname@example.org' if input from UX is needed.