[Libreoffice-bugs] [Bug 87058] column label functions do not update after inserting rows below title - needs save and reload including a hard recalc

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=87058

Buovjaga <ilmari.lauhakangas at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |ilmari.lauhakangas at libreoff
                   |                            |ice.org
           Keywords|bibisectRequest             |bisected

--- Comment #11 from Buovjaga <ilmari.lauhakangas at libreoffice.org> ---
(In reply to Oliver Brinzing from comment #10)
> 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 6.1.5.2:
> - 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

Bibisected with Linux 42max to
https://git.libreoffice.org/core/+/ac645e88b91e95bc19ce7a8852fe45b0ec8780e7%5E!/
Extract this code into a local function.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200604/7f11747e/attachment.htm>