[Libreoffice-bugs] [Bug 135125] New: 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

            Bug ID: 135125
           Summary: calc: formula: autocalc: autofilter:
                    calc-recalc-autocalculate-broken-if-autofilter-was-act
                    ive-during-formula-creation
           Product: LibreOffice
           Version: 5.2.3.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: newbie-02 at gmx.de

Description:
this bug is based on a question ins ask: 

https://ask.libreoffice.org/en/question/82528/calc-recalc-autocalculate-broken-if-autofilter-was-active-during-formula-creation/?comment=256845#post-id-256845

see there for details, 

be aware: repro only under very special conditions, 

be aware: as @Lupp writes: 'The issue vanishes for a formula after a fake edit
and doesn't come back after undo.', and 'The issue did not persist after a
Save/Load cycle. It may therefore be exerienced very rarely.'

@erAck: you fixed plenty similar issues in the past :-)  would you mind having
a look, stable reproducer and simple case are avail

Steps to Reproduce:
(recipe from pmfrench)

1. In cell A1 enter "Letters" In cell A2 enter "ab" In cell A3 enter "abc" In
cell A4 enter "ab" In cell A5 enter "abc"

1a. on my tests it didn't hit with two pairs of ab abc, used five in rows 2-11, 

2. With the cursor in one of those cells, select DATA/AUTOFILTER from the
menus. 

3. From the drop-down arrow in cell A1, deselect ALL and tick the box in front
of "abc", then click the OK button. 

4. The list should now show only the "abc" entries.

5. In cell C3, enter the formula =LEN(A3) Copy the forumla down to the row
below which should be row 5. The results for both formulas should be "3"

5a. needed to copy (pull down) til row 11, all results '3', 

6. Now if you edit the contents of A3 or A5 to change the length of the string,
the results of the formulas in column C should auto update, but do not.

6a. on my tests C3 and C11 updated, while C5, C7, C9 didn't, 


Actual Results:
some cells with formulas are not updated on changes in their references, 

Expected Results:
all cells updated as it's defined for autocalculate on, 


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 7.1.0.0.alpha0+ (x64)
Build ID: 0d45380c99c7200075d01860a2315d0ddb450f1c
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render:
Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc:

-- 
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/20200725/fbf55d44/attachment-0001.htm>