Have To Use F9 On One Cell

English
#1

Version: 24.8.4.2 (X86_64) / LibreOffice Community
Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002
CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: en-CA (en_GB); UI: en-GB
Calc: CL threaded

Sheet named by month.
Trying to use the sheet name to automatically calculate the weekdays per day of the month. I have a cell that looks at the sheet name, which in turn is used to return the month number.
The hiccup is the cell that looks at the sheet name. It will only update after F9, despite autocalculate being active. All other formulae update automatically bar this simple one: =Cell Ref eg D5.

I see there has been some similar issue(s) with early Calc versions. Has this problem returned in some mutation ?

Any Gurus out there ?

Thanks

#2

Assuming the sheets starts with »January« and they are ordered?!

=DATE( 2025; SHEET(); 1)
#3

How does it do that?
Generally:
If you know the result type of a formula for sure, you can make it volatile by appendig either + RAND()*0 or & T(RAND()) (e.g.).
If you don’t want it fully volatile you can use any cell of which you know that it will be recalculated in time to trigger the recalculation of your “stubborn” cell by referencing the trigger cellt with a similar NULL effect part appended to the original formula.
Again generally: I would strictly dissuade from misusing a sheet name as “data”.

1 Like
#4

Hello Karolus

Your suggestion does work but in my view for what I am doing, has a small risk of sheet number not necessarily tallying with the month, hence a risk of error.

I’ve since found that any cell containing the Sheet Name field, does not update after re-naming the sheet. It updates with F9 or by quickly scrolling the screen up and down.

That to me indicates an underlying issue linked to using the Sheet Name field in a process, as once F9 or scrolling triggers the update, the dependent subsequent processes then automatically update.

#5

Will there be an answer?

#6

Karolus

Seems an issue has developed today.

I’m unable to login to reply. The redirection after entering login details (Login) results in a blank page, the address of which I can no longer obtain as in doing so, I was directed to the change password page. In entering a new password (my original working password + additional character (alpha numeric + $ character)), the result was “password contains not allowed character” error…

Are you in a position to remedy ?

Simon

#7

Hello Wolfgang

Insert cell fields

You can insert a field linked to the date, sheet name, or document name in a cell.

  1. Select a cell and double-click to activate edit mode.

  2. Right-click and selectInsert Field > Date, Time, Sheet Name or Document Titlein the

context menu.

  1. Alternatively use the similar options in theInsert > Fieldmenu on the Menu bar.

72 | Calc Guide 24

As for a solution, that is for the gods themselves to create. As a mere mortal, I only have F9 or rapid screen scroll.

Simon

#8

Hmmm
This was introduced with LibO V6 - and I hadn’t noticed it till now.
Thanks for the info,

#9

Menu>Data>Calculate>Recalculate hard [Ctrl+Shift+F9]

Bug 165151 - Calc: Sheet Name field in cell does not update after sheet rename

#10

You’re welcome

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.