Bug 95525 - Dedicated entry line for lists in Calc
Summary: Dedicated entry line for lists in Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Calc-Enhancements
  Show dependency treegraph
Reported: 2015-11-02 14:10 UTC by charled
Modified: 2023-05-07 16:30 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Entry line for coml-pleting lists (28.97 KB, application/vnd.oasis.opendocument.graphics)
2016-10-09 09:20 UTC, charled

Note You need to log in before you can comment on or make changes to this bug.
Description charled 2015-11-02 14:10:53 UTC

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.)
Comment 1 Buovjaga 2015-11-11 12:53:58 UTC
UX: yay or nay?
Comment 2 charled 2015-11-11 13:12:42 UTC

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. 

Comment 3 Robinson Tryon (qubit) 2016-08-25 05:49:44 UTC Comment hidden (obsolete)
Comment 4 Heiko Tietze 2016-10-05 10:03:14 UTC
(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.
Comment 5 charled 2016-10-09 09:20:37 UTC
Created attachment 127886 [details]
Entry line for coml-pleting lists

Hope this helps…
Comment 6 Heiko Tietze 2017-01-17 15:43:49 UTC
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.
Comment 7 Xisco Faulí 2020-03-09 13:28:34 UTC
Please add keyword 'needsUXEval' and CC 'libreoffice-ux-advise@lists.freedesktop.org' if input from UX is needed.