[Libreoffice-bugs] [Bug 129541] New: calc CALCULATING: autocalculate with 'shared formulas' still broken if a shared formula has #REF! problem

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 129541
           Summary: calc CALCULATING: autocalculate with 'shared formulas'
                    still broken if a shared formula has #REF! problem
           Product: LibreOffice
           Version: 4.2 all versions
          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:
shortest: 

load attachment from next comment, 
click button to provoke error, 
calculate cells B2 and B3 manualy, 
displayed values are wrong, 

short: 

A3: 3              '(any number will fit), 
B3: =SUM(A2:A4)    'similar formulas will fail too, 
A3:B3: copy 
A1:B3: paste

observe B1: '#REF!' - correct, 

play with values in A1:A3, B2:B3 cut off from autocalculation - not correct,  

alternative: 

A1:B1 must not! be filled with the same formula, 
A3:B3: copy        '    
A2:B4: paste

play with values in A2:A4, B2:B4 should react correctly, 

long: 

there have been several cases where autocalculate was broken for 'shared
formulas', delete or insert in referenced ranges, changing formulae, inserting
columns and so on, 

some have been patched in the nearby past, this one remains, 

i think it's already adressed in another case treating nested formulas, 

may be this is the essence causing the errors there, 

have fun, 

merry x-mas

b. 

P.S: 

call me crazy ... i only want this program to become reliable again - if
possible, 

bug flooding? - imho the original bug is only one, something 'bigger', more
fundamental, in the past (4.1 -> 4.2), as of now and as of how bugs are
handeled there's nothing i can do than observe and report, 

forum trolls: pls. do NOT! ask if i have / had <data-calculate-autocalculate>
enabled, also resetting user profile won't help, 

will provide testsheet with macro to produce the error in next comment, 

Steps to Reproduce:
see above

Actual Results:
cells cut off from auto recalculation

Expected Results:
all cell should be recalculated correctly in any case, 


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.5.0.0.alpha0+ (x64)
Build ID: 209fc9fd7fa433947af0bf86e210d73fa7f5a045
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: 

last verson i've seen without this bug: 4.1.6.2

-- 
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/20191221/2a94d4d5/attachment.htm>