https://bugs.documentfoundation.org/show_bug.cgi?id=120670
--- Comment #2 from Hans-Peter Jansen <[email protected]> ---
Dear Mike,
thanks for your quick response and valuable suggestions.
I've no idea, why I stuck with the silly sum formula. Most probably by
simulating the ∑ method...
'=sum(<D2:B7>)' is almost fixing 2 of the 4 issues mentioned.
I say almost, because, it doesn't work for removing the first item, but then
'=sum(<D1:B7>)' is doing fine for that case, too.
Thank you very much, will incorporate such adjustments to all invoice and offer
templates in a second.
What's remaining is the third bullet, and the first half of the first. I'm
sorry for not describing the first bullet properly, and for not splitting this
topic in two issues, which it deserved. Here is the first part, which wasn't
formulated properly:
* Adding a row of another issue is missing to clone the sum formula for the
new row (amount * unit price).
I've attached an updated version of the test file, incorporating the changes,
you suggested for further discussion and hopefully, to support somebody, who
might want to tackle the remaining issues.
--
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
