LibreOffice

481 readers

1 users here now

LibreOffice is a powerful free and open source office suite, used by millions around the world.

founded 2 years ago

MODERATORS

[email protected]

[Solved - Setting ]Why F9 after any edits? LibreCalc 7.3.4.2 vs 7.4.7,2 (lemmy.one)

submitted 1 month ago* (last edited 1 month ago) by [email protected] to c/[email protected]

2 comments fedilink hide all child comments

Solved by u/[email protected] 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!

you are viewing a single comment's thread
view the rest of the comments

[–] [email protected] 1 points 1 month ago (1 children)

F9 is also the 'calculate' shortcut in Excel...
it's just that most spreadsheets will havr auto-calculation enabled.
Maybe your sheet just has autocalculate off...

To access this command...
From the menu bar:
Choose Data - Calculate - AutoCalculate.

https://help.libreoffice.org/latest/lo/text/scalc/01/06070000.html

[–] [email protected] 2 points 1 month 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!