https://bugs.documentfoundation.org/show_bug.cgi?id=95525
Bug ID: 95525 Summary: Dedicated entry line for lists Product: LibreOffice Version: unspecified Hardware: All OS: All Status: UNCONFIRMED Severity: enhancement Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: jlt...@free.fr Hi, 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.) -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs