[Libreoffice-bugs] [Bug 123510] Libreoffice calc checkbox when checked changes contents of linked cell but cell value is not evaluated properly when included in formulas in other cells.

[bugzilla-daemon at bugs.documentfoundation.org]

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

Andrew <aj.bar.ker at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|NOTABUG                     |FIXED

--- Comment #8 from Andrew <aj.bar.ker at gmail.com> ---
(In reply to m.a.riosv from comment #7)
> If all values in the range to sum are numbers or text numbers not other kind
> of strings, then =SUMPRODUCT(A1:A2*1) can work, because it forces the
> conversion. And direct references to one cell with text numbers should work
> also.
> 
> Another issue sure is that change the behavior can break existing forms.
> 
> Forms don't take care of what the receiver does with the values, in this
> case a spreadsheet.
> 
> If you want reopen as request for enhancement on the second box of
> Importance field, adapting the title.

That would be a workaround as it is not the default behavior when you hit the ∑
button and select the range that includes the affected cell. 

This isn't on a form. It's on a sheet with the checkbox control on it. See the
example I attached.

-- 
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/20190217/6529617b/attachment.html>