Hi All,
Just wanted to share an auto-recalculate bug in LibreOffice that is in the current FreeBSD package repository. The potential of this to wreak havoc is incredible. Basically, recalculate on a cell works only in some cases, even when the auto recalculate is set. F9 triggers to recalculate correctly. Steps to reproduce:
I think FreeBSD needs to update LibreOffice in the repo to 7.0.3 ASAP as the bug was fixed (bug #81 here: https://wiki.documentfoundation.org/Releases/7.0.3/RC1).
Just wanted to share an auto-recalculate bug in LibreOffice that is in the current FreeBSD package repository. The potential of this to wreak havoc is incredible. Basically, recalculate on a cell works only in some cases, even when the auto recalculate is set. F9 triggers to recalculate correctly. Steps to reproduce:
- Cell A1 is a number.
- Cells A3:A5 are numbers.
- Cell A6 = SUM(A3:A5).
- Cell A7 = A6-A1.
- A6 recalculates fine if any of the numbers in A3:A5 are changed.
- A8 recalculates fine if A1 is changed.
- A8 does NOT recalculate if any of the numbers in A3:A5 are changed.
I think FreeBSD needs to update LibreOffice in the repo to 7.0.3 ASAP as the bug was fixed (bug #81 here: https://wiki.documentfoundation.org/Releases/7.0.3/RC1).