https://bugs.documentfoundation.org/show_bug.cgi?id=166505
--- Comment #2 from Alfio ---
(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.
