[Libreoffice-bugs] [Bug 123510] New: 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

            Bug ID: 123510
           Summary: Libreoffice calc checkbox when checked changes
                    contents of linked cell but cell value is not
                    evaluated properly when included in formulas in other
                    cells.
           Product: LibreOffice
           Version: 6.0.7.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: aj.bar.ker at gmail.com

Description:
I create a checkbox linked to a cell.  set the "Reference value (on)" to "25"
and the "Reference value (off)  to "0"(zero)  No quotes are used in Calc. Used
quotes here to isolate values used. 

Switching design mode off and clicking the check box to mark it as checked
shows the check mark. And the displayed value of the cell changes to "25" and
unchecking the box changes the text value of the cell to "0", it changes to
match when the value of the checkbox cell changes. 

Checkbox control created and linked to H16.  Values set as above. 

If I assign the value of another cell to equal the value of that cell like
"=H16", then the value of the cell matches that of cell H16. 

If I create a sum() function in another cell that includes the H16 in it, the
sum() value does NOT include the value of the checked cell. 

Using =SUM(H14:H20) does not handle the value of H16 properly. 

Formatting the cell H16 as a number has no effect. 

This behavior is the same on Armbian Libreoffice version 6.0.7.3 
and Windows 10 Libreoffice 6.1.3.2


Workaround is to use the value() function when the cell value is included
anywhere. 

As such:

=SUM(H14:H15,H17:H20,VALUE(H16))

Using ranges around the affected cell and then using the value() function to
include the desired cell is clumsy and should not be necessary. 


I'm guessing this behavior is endemic to Libreoffice and is to be found in all
versions and hardware types. 



Steps to Reproduce:
1.Open Calc
2.create a checkbox control and link it to a cell and set the on and off values
to 25 and 0.
3.include the value of the linked cell in a complex sum(include values of
multiple cells. Not just one cell) in another cell. or any function that tries
to evaluate the contents of the cell as a number. 
4. Check or uncheck the checkbox. If the desired result is a number, then any
function that relies on the result will fail. 

Actual Results:
The value of the complex sum does not include the value of the cell linked to
the checkbox. 

Expected Results:
The value of the complex sum() function should include the value of the linked
cell in its result. 


Reproducible: Always


User Profile Reset: Yes



Additional Info:
The software should properly recognize the type of value when assigning the
cell contents from the checkbox control.  

Formatting the cell as number has no effect.

Other controls should be evaluated for similar behavior.

-- 
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/5835d166/attachment.html>