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
