[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

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|NEEDINFO                    |RESOLVED

--- Comment #7 from m.a.riosv <miguelangelrv at libreoffice.org> ---
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.

-- 
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/b08a07e0/attachment-0001.html>