https://bugs.documentfoundation.org/show_bug.cgi?id=152091
--- Comment #7 from LeroyG <iavs.le...@gmail.com> --- (In reply to Julien Nabet from comment #6) > (In reply to LeroyG from comment #1) > > Just try in B1 with =A1:A2 and you will get only the A1 value. And with the > > same formula in B2 you will get only the A2 value. > > > Yes and if I do =A1:A2 in A18, I got "#VALUE!" quite weird! Not weird, because formula references only until A2. Change the formula to =A1:A10 and you will get "0". Otherwise use =SUM(A1:A2). -- You are receiving this mail because: You are the assignee for the bug.