https://bugs.documentfoundation.org/show_bug.cgi?id=87058
--- Comment #10 from Oliver Brinzing <[email protected]> ---
Created attachment 149067
--> https://bugs.documentfoundation.org/attachment.cgi?id=149067&action=edit
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
- 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 3.6.7.2 (Build ID: e183d5b)
will update after hard recalc, no need to save and reload:
- LO 4.4.7.2
needs a save and reload followed by a hard recalc:
- LO 5.4.7.2 (x64)
- LO 6.1.5.2 (x64)
- LO 6.3.0.0.alpha0+ (x64)
btw:
Tools/Options.../LibreOffice Calc/General
[ ] Expand references when new columns/rows are inserted
seems to have no influence
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
