Solved by u/InEnduringGrowStrong@sh.itjust.works Thanks! A setting: Choose Data - Calculate - AutoCalculate.

Hi all,

I’m experiencing an issue in LibreOffice Calc where I have several columns that check a single column for any value (i.e., not blank) before showing their own values. Whenever I make changes, I need to press F9 to correctly update and show the edited values.

For example, I’m using the following formula: =IF(s1+“”,“”,IF(n1>5,“big”,“little”))

Instead of showing “big” or “little,” it shows “0” until I press F9. After pressing F9, it updates to “big” or “little” based on the condition for s1.

Some context:

My setup: LibreOffice Calc 7.4.7.2, running on Linux Debian

My wife's setup: LibreOffice Calc 7.3.4.2, running on Windows, and her spreadsheet works as expected without needing to press F9.

This issue started about 11 days ago, and it used to work correctly before.

Has anyone experienced a similar issue or know how to fix it? Any help would be greatly appreciated!

Thanks in advance!

  • WasPentaliveOP
    link
    fedilink
    English
    arrow-up
    2
    ·
    11 days ago

    Yes, this was it. I remember seeing that but tonight I could not find it, and I don’t remember changing it but I must have. Thanks!