[Libreoffice-bugs] [Bug 120670] Formula handling in Writer tables

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Jan 16 16:43:18 UTC 2019


https://bugs.documentfoundation.org/show_bug.cgi?id=120670

--- Comment #6 from Hans-Peter Jansen <hpj at urpla.net> ---
Thanks Timur, for your reply.

(In reply to Timur from comment #5)
> (In reply to Hans-Peter Jansen from comment #4)
> >  * Adding a row for another item is missing to clone the sum formula for the
> > new row (amount * unit price).
> I don't understand what you would like. Clone what, row where cursor is? 

Done: https://bugs.documentfoundation.org/show_bug.cgi?id=122763

> We need steps, with Experienced and Expected result. But, that must be a new
> request.
> 
> This bug with multiple issues is Invalid report. 
> But we can convert it to a proper bug for this:

Okay, understand. Lesson learned.

> (In reply to Hans-Peter Jansen from comment #0)
> >  * 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. 
> 
> Looks like a bug. Please explain what's value format here. So that we can
> understand what happens with s simple change, let's say from 12,3% to 17%.

The value format is '0,0%" VAT"'. If you load the attached document, put the
cursor in the VAT field (A10), and edit the value to say "13,2", and tab out of
the field, the format is lost (-> Text '@'), the new value is displayed left
aligned, although the field is still right aligned(!), and the calculation in
B10 fails (-> 0,00 €). I wasn't able to recover from this without reassigning
the specific %-format (0,0%" VAT"), and *enter* the plain value again. The only
proper way to change the VAT value for an experienced user is selecting the
whole value, and replacing it with a plain number.

I would expect the field A10 to keep the assigned format, and just accept the
new value. Then, the calculation in B10 wouldn't fail as well, I bet.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190116/4e5cd764/attachment.html>


More information about the Libreoffice-bugs mailing list