<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Formula handling in Writer tables"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=120670#c6">Comment # 6</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Formula handling in Writer tables"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=120670">bug 120670</a>
from <span class="vcard"><a class="email" href="mailto:hpj@urpla.net" title="Hans-Peter Jansen <hpj@urpla.net>"> <span class="fn">Hans-Peter Jansen</span></a>
</span></b>
<pre>Thanks Timur, for your reply.
(In reply to Timur from <a href="show_bug.cgi?id=120670#c5">comment #5</a>)
<span class="quote">> (In reply to Hans-Peter Jansen from <a href="show_bug.cgi?id=120670#c4">comment #4</a>)
> > * 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? </span >
Done: <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Improve writer table formulae handling"
href="show_bug.cgi?id=122763">https://bugs.documentfoundation.org/show_bug.cgi?id=122763</a>
<span class="quote">> 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:</span >
Okay, understand. Lesson learned.
<span class="quote">> (In reply to Hans-Peter Jansen from <a href="show_bug.cgi?id=120670#c0">comment #0</a>)
> > * 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%.</span >
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>