Hi, I’m using LibreOffice Calc version 220.127.116.11 on Windows 10. I’m trying to make a function that spits out a true or false depending on whether a certain cell has a number in it. I will be updating this list, not just doing a one and done deal, so I need it to recalculate on its own in case any of the cells’ values change.
I’m trying to get the function to work, but only the first instance of it will autocalculate. If I want any subsequent iteration of the function to calculate I have to hit CTRL+SHIFT+F9. I’ve tried enabling and disabling autocalculate, but nothing seems to do the trick.Sometimes even hard recalculating doesn’t work. Any advice?