https://bugs.documentfoundation.org/show_bug.cgi?id=120670
Bug ID: 120670
Summary: Formula handling in Writer tables
Product: LibreOffice
Version: 6.1.2.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Writer
Assignee: [email protected]
Reporter: [email protected]
Created attachment 145796
--> https://bugs.documentfoundation.org/attachment.cgi?id=145796&action=edit
A Writer document with an invoice table
Dear everybody,
attached is a writer document, that demonstrates an area, where Writer could
improve a little, and any user of similar table will celebrate!
It shows a typical simple invoice table, containing a few items, and each item
line contains a formula for calculating the unit sum. Below that, it comes with
the usual summing, VAT, etc.
Issues:
* When adding an item below the microbes (add table row below), it is missing
the sum formula, and consequently, this item is missing in the net amount sum.
* Moreover, with removing an item (delete table row), all summing formulas are
invalidated, and have to be redone.
* Another minor issue lurks in the VAT field (A9), if simply editing the VAT
value, and leaving the field, it is loosing its special VAT value format.
Reassigning the format and replacing the content with just the value is
necessary to recover.
Discussion:
Of course, this behaviour could be changed by embedding a Calc table, but this
comes with a price to pay. Apart from the inconvenient handling, it creates
issues with page break, etc...
I'm using such tables since more than 15 years with SO, OO, LO, and I'm
enjoying todays state a lot, as it preserves the item row formatting, when
adding rows. This used to fail in former times.
Solving these issues would make a lot of people, that create invoices with LO,
very happy. I'm sure, I know some of them...
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
