https://bugs.documentfoundation.org/show_bug.cgi?id=152080
johnks <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #1 from johnks <[email protected]> --- (In reply to erietmeijer from comment #0) > Description: > When I select 2 cells below each other containing the formulas > "=SUMPRODUCT(A1=B1:B50)" and "=SUMPRODUCT(A2=B1:B50)" and 'drag' them (I > don't know the technical term), I expect the next created cell to be > "=SUMPRODUCT(A3=B1:B50)". Instead the next cell is "=SUMPRODUCT(A3=B3:B52)". > I am making the assumption this is not expected behaviour. > > Steps to Reproduce: > 1. In cell C1: "=SUMPRODUCT(A1=B1:B50)" > 2. In cell C2: "=SUMPRODUCT(A2=B1:B50)" > 3. Select both cells and 'drag' to next unoccupied cell > > Actual Results: > Cell C3 contains the formula "=SUMPRODUCT(A3=B3:B52)" > > Expected Results: > Cell C3 contains the formula "=SUMPRODUCT(A3=B1:B50)" > > > Reproducible: Always > > > User Profile Reset: No > > Additional Info: > There is no other information. this is intended behaviour. please do =SUMPRODUCT(A3=$B$1:$B$50) by going to b1 and pressing f4. this will put $ sign before and after each character, making it "sticky". same for b50. now when you drag down, it will only move A3 to A4 and down and down... hope that helps -- You are receiving this mail because: You are the assignee for the bug.
