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@lists.freedesktop.org
Reporter: aj.bar....@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
