Description: Naming sheets by month. Copying/adding a sheet from a master sheet (Sheet name: Copy) and then renaming to required month. The sheet contains Sheet Name field in a cell. During experimenting with it and formulae, I noticed this issue: It only changes/updates by F9 or fast up/down screen scroll. Steps to Reproduce: 1.Enter Sheet Name field to cell 2.Click OK or press enter to confirm 3.F9 or swift up/down screen scroll 4. Rename sheet then step 2. & 3. Actual Results: Step 1 & 2 may result in correct sheet name. Step sequence: 4, 1, 2, 3 updates name in cell Expected Results: Step 2 should cause update Reproducible: Always User Profile Reset: No Additional Info: 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 Can't see what user profile has to do with this issue.
Menu>Data>Calculate>Recalculate hard [Ctrl+Shift+F9] update the field.
(In reply to m_a_riosv from comment #1) > Menu>Data>Calculate>Recalculate hard [Ctrl+Shift+F9] > update the field. I know. I was looking for automatic update, not manual, as that can be prone to error. Creation of correct day name to day of the month relies on the field automatically updating on sheet rename, as does adjusting for days in the month. F9 restarts the creation process. Just have have a note to cross check sheet name to required month.
Created attachment 199124 [details] Sample file with external link to the same file. Seems the issue is the view not being updating properly. In the attached file: - Edit the sheet name - Wait 5 seconds. - External link it's updated, but the cell no. From the attached file, it appears that the cell value is updated, but the cell display is not updated. Fail from the first version supporting those fields. Version: 4.4.7.2 Build ID: f3153a8b245191196a4b6b9abd1d0da16eead600 Locale: es_ES up to Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 6042e60d69c40d1f307710e60a278cb286d68603 CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded