https://bugs.documentfoundation.org/show_bug.cgi?id=166505
--- Comment #2 from Alfio <[email protected]> --- (In reply to elliot from comment #0) The filling results you saw are common to other spreadsheet applications. The link you provided talks about incrementing values, but your Actual Results refers to formulas, not to values. When you use the "fill handle" starting from a cell containing a formula, the automatic filling do not act as filling values. It simply copy formulas applying the relativity corrections. Try to copy-paste the A1 cell to A2, A3 and A4: you will get the same results as the "fill handle". Do you remember how the copy of formulas works? When a cell is copied to a position in the same column from which it originated, the column references contained in the formula remain unchanged, also if that references was relative (that is without the dollar sign). Same happens for row references, when they are copied to the same row as origin. So, this is not a bug. But I thank you, because you left a hint to enhance the contents of the help pages. -- You are receiving this mail because: You are the assignee for the bug.
