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