https://bugs.documentfoundation.org/show_bug.cgi?id=120670
--- Comment #1 from Mike Kaganski <[email protected]> ---
Hi! Thanks for the suggestions.
While I agree that the last suggestion is a valid issue, I suppose that first
two bullets in the list are not.
> * 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.
This one is because the sum formula in your Net Amount lists individual cells.
In this case, the program has no way of knowing that adding a row requires to
modify the arguments to a formula. If you use simply `=sum(<D2:B7>)` instead of
`=sum(<D2|D3|D4|D5|D6|B7>)`, it will work as expected. Well - you could have
valid reasons to not include the last line (Shipment) into the range; then you
could simply add an empty row below the Microbes, assign it a minimal height,
remove inner borders (so it would look like simply double-border), and include
it into the range formula (in that case, it would look like
`=sum(<D2:D7|B8>)`). Then adding rows below Microbes would work fine, and
removing rows also would work (except for the rows explicitly mentioned in the
formula).
--
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
