[Libreoffice-bugs] [Bug 128975] New: WORK: EDIT: issues left in fixing shared-formula / autocalculate problems?

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 128975
           Summary: WORK: EDIT: issues left in fixing shared-formula /
                    autocalculate problems?
           Product: LibreOffice
           Version: 4.2.0.4 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:
short try: load file from next comment, delete value in B10, observe C10,
D8:D12 and E6:E14 changing. copy row 20 and paste over rows 1:20 - it's the
same content as before!, delete value in B10, observe only C10 reacting to it,
while D8:D12 and E6:E14 show wrong - unchanged - values. 

hard recalc (shift-ctrl-F9) corrects the view, but it is not sustainable, not
thorough, when changing other cells in column B, again the cells in D and E are
excluded from refresh

long story: i think the problem is 'related' to plenty bugs and reports
regarding shared formulae blocking autocalculate, e.g.
https://bugs.documentfoundation.org/show_bug.cgi?id=123736, i was asked there
to file a new bug, 

on checking old fault descriptions i stumbled on
https://ask.libreoffice.org/en/question/12165/calc-auto-recalc-does-not-work/,
the procedure mentioned there by Budi B L: 

"Still having similar problem Version: 4.4.0.3. This is my case: B10= number,
data for these formula C10= formula: =IF(IFERROR(B10,0),1,0) D10= formula:
=SUM(C8:C12) E10= formula: =SUM(D8:D12) And those cells copied to B1:B20 The
result: ONLY the col C that changed by input or edit the cell in col B. NO
changes in col D and com E, related option already been set."

fails in ver 6.4.0.0.alpha1+ for linux, x64, build id ends with 3d60d7. 

it does not! fail loading a saved file with the formulae, but it does! fail if
you create the sheet from scratch, or take one row in that sheet and copy it to
a range of rows, e.g. 1:20

the following versions failed too (for win german, lo englisch, german locale,
i had to change the delimiter in the formula from ',' to ';': 

Version: 6.2.8.2 (x64)
Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee
CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: 

Version: 6.4.0.0.alpha1 (x64)
Build ID: cc57df8f942f239d29cb575ea5a7cb01405db787
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default;
VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: 

Version: 6.4.0.0.alpha1+ (x64)
Build ID: d456ca6efb98d707427228e8131dfe8a5f27e2f6
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default;
VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: 

have fun in debug and coding, thanks for any help to get finally rid of this
problem

Steps to Reproduce:
see above description and 'script' by Budi B L

Actual Results:
under special circumstances some cells are excluded from automatic
recalculation, 

Expected Results:
recalc - autocalculate should work for all! cells, 


Reproducible: Always


User Profile Reset: No



Additional Info:
see above,

-- 
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/20191123/4cae2772/attachment-0001.html>