[Libreoffice-bugs] [Bug 135125] calc: formula: autocalc: autofilter: calc-recalc-autocalculate-broken-if-autofilter-was-active-during-formula-creation

[bugzilla-daemon at bugs.documentfoundation.org]

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

NISZ LibreOffice Team <libreoffice at nisz.hu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |libreoffice at nisz.hu

--- Comment #2 from NISZ LibreOffice Team <libreoffice at nisz.hu> ---
Created attachment 171674
  --> https://bugs.documentfoundation.org/attachment.cgi?id=171674&action=edit
Simplified example file

Repro with this simple example. Steps:

* Have some texts in column A, I entered two letters in most rows, except 4-5
* Hide some of them with autofilter. I hid "cccc" in rows 4-5
* Have a simple formula such as LEN(A1) in B1

The file contains this setup. Now the action:

* Pull down the formula from B1 until B8
* Overwrite the still visible values in Column A

Result: The formula are not recalculated in B2:B3 before the hidden rows 4-5 
but they are recalculated in B6:B8 after the hidden rows.

Happens in:
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 9bfe083adf1fd9d470b600d0a801d144db24474f
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: threaded

-- 
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/20210506/76801d5e/attachment-0001.htm>