Bug 87058 - column label functions do not update after inserting rows below title - needs save and reload including a hard recalc
Summary: column label functions do not update after inserting rows below title - needs...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: bibisected, bibisectRequest, regression
Depends on:
Blocks: Cell-Name
  Show dependency treegraph
Reported: 2014-12-06 23:08 UTC by aaker
Modified: 2019-02-10 13:27 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Readings table 4 cols: timestamp; 3 readings (29.11 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-12-06 23:08 UTC, aaker
bibisect "need save/reload" in till51 repo, tail of terminal output (2.40 KB, text/plain)
2018-08-16 02:28 UTC, Terrence Enger
column label function.ods (9.20 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-02-10 13:23 UTC, Oliver Brinzing

Note You need to log in before you can comment on or make changes to this bug.
Description aaker 2014-12-06 23:08:38 UTC
Created attachment 110518 [details]
Readings table 4 cols: timestamp; 3 readings


Creating "dynamic" named range: $Tabelle1.$B3:$B$3 (note missing $-sign on row indicator on range start)
This is expanding as expected to $Tabelle1.$B3:$B$4 when inserting row above row 3
Functions using referencing name do not update during runtime. Update done when saving/reopening file.

Same happening when deleting row from "dynamic" range
Not tested with column
Comment 1 raal 2014-12-07 11:09:11 UTC
I can confirm with Version:
Build ID: a26222f5af55e8ffe9784dd411485d3c5c72e983
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-12-07_01:55:26

Steps to reproduce:
open file 
insert empty for above row 3 
insert value 10 into cell B3
watch cell B1 (no change)
CTRL+SHIFT+F9 -> B1 change value
Comment 2 QA Administrators 2015-12-20 16:15:16 UTC Comment hidden (obsolete)
Comment 3 aaker 2015-12-20 22:05:03 UTC
Mint 17.3

Build-ID: 1:5.0.3~rc2-0ubuntu1~trusty2
Gebietsschema: de-CH (de_CH.UTF-8)

still present

can't confirm CTRL+SHIFT+F9 behavior as reported by "raal"
Comment 4 QA Administrators 2017-01-03 19:54:59 UTC Comment hidden (obsolete)
Comment 5 aaker 2017-01-03 22:25:24 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2018-07-24 02:37:44 UTC Comment hidden (obsolete)
Comment 7 aaker 2018-08-01 09:36:21 UTC
Still present:

Build-ID: 1:6.0.5~rc2-0ubuntu0.18.04.1~lo1
CPU-Threads: 8; BS: Linux 4.15; UI-Render: Standard; VCL: gtk3; 
Gebietsschema: de-CH (de_DE.UTF-8); Calc: group
Comment 8 Timur 2018-08-01 15:19:00 UTC
aaker thanks for following your bugs. 
But when testing, it's always better idea to test also with master. Normally you get it from https://dev-builds.libreoffice.org/daily/master/ but in Linux it's very convenient to use Appimage in Linux from https://www.libreoffice.org/download/appimage/ or daily from https://libreoffice.soluzioniopen.com/.

As for this bug (test in Windows, so not Linux-only):
I first opened attachment 110518 [details] with LO 6.2+ with steps from raal. Hard recalc doesn't help.
Even setting to prompt user on fileopen for recalc, it asks, but doesn't solves the issue.
Then I saved and reopened and it works. That's what puzzles me. 

I remember we had few bugs with "hard recalc doesn't help". 
Works with LO 4.1. I'll mark regression but that needs to be confirmed.
Comment 9 Terrence Enger 2018-08-16 02:28:34 UTC
Created attachment 144221 [details]
bibisect "need save/reload" in till51 repo, tail of terminal output

Working on debian-buster in the till51 bibisect repository, I see that
<Ctrl>+<Shift>+<F9> stopped recalculating B1 and save/reload became
necessary somewhere in the 74 or so commits:

          commit    s-h       date
          --------  --------  -------------------
    good  b0072876  46564fd9  2015-06-15 00:07:25
    bad   34b2392f  80ec99db  2015-06-15 21:49:07

The hard recalc became necessary somewhere in the the 42max
repository.  Is this of any interest?

I am setting keyword bibisected.
Comment 10 Oliver Brinzing 2019-02-10 13:23:57 UTC
Created attachment 149067 [details]
column label function.ods

this issue is not an issue about a problem with named ranges.

average function uses column labels instead:

Tools/Options.../LibreOffice Calc/Calculate
[X] Automatically find column and row labels

steps to reproduce with LO
- open attached "column label function.ods"
- enter 400 in cell C7
- sum/average functions will update results
- select row 4, context menu "Insert Row Above"
  (or row 3, context menu "Insert Row Below"
- enter 50 in cell C4
- sum/average functions will *not* update results
- CTRL+SHIFT+F9 (hard recalc)
- sum/average functions will *not* update results
- save and reload
- sum/average functions will update results
  (if Tools/Options.../LibreOffice Calc/Formula
   "Recalculation on File Load" is activated
   otherwise use a hard recalc after reload)

not problem at all with: 
- AOO 4.1.5
- LO Version (Build ID: e183d5b)

will update after hard recalc, no need to save and reload:
- LO

needs a save and reload followed by a hard recalc:
- LO (x64)
- LO (x64)
- LO (x64)

Tools/Options.../LibreOffice Calc/General
[ ] Expand references when new columns/rows are inserted
seems to have no influence