https://bugs.documentfoundation.org/show_bug.cgi?id=95440
--- Comment #4 from m.a.riosv <[email protected]> --- Looking into the file, K2 has the value '0'. The difference between 3.6 and the new versions is that 3.6 always does an auto-calculate at opening while the new versions has an option to do that at opening to avoid large calculation in that moment with large spreadsheets. Menu/Tools/Options/LibreOffice calc/Formula/Recalculation on file load, putting both with Always recalculate and works like in 3.6. While no any precedent of K2 is changed then it is not recalculated. But changing the value in a precedent like F2 it is recalculated. Hard recalc solves the issue because it forces a wholw recalculation of the spreadsheet. Maybe th file was saved in a LibreOffice with Auto-calculate disable. OR() function only return two values 0 or 1 so there is no need for to compare with 1. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
