Description: Please reference the help article titled "Automatically Filling in Data Based on Adjacent Cells" found here: https://help.libreoffice.org/25.2/en-US/text/scalc/guide/calc_series.html When the user clicks the "fill handle" and drags to fill cells with ascending values, in some cases Calc does not properly increment the values. Specifically, letters are never incremented when dragging downwards or upwards. Likewise, numbers are never incrementing when dragging left or right. Steps to Reproduce: Assuming a starting cell contents of =A1 if you click the "fill handle" and drag downwards over the following three cells, Calc will "AutoFill" differently with different permuations of A1, yeilding the following correct and incorrect results: Actual Results: =$A$1 actual result (is correct): =A1 =A1 =A1 =A$1 actual result (is incorrect): =A1 =A1 =A1 =$A1 actual result (is correct): =A2 =A3 =A4 =A1 actual result (is incorrect): =A2 =A3 =A4 Expected Results: =$A$1 expected result: =A1 =A1 =A1 =A$1 expected result: =B1 =C1 =D1 =$A1 expected result: =A2 =A3 =A4 =A1 expected result: =B2 =C3 =D4 Reproducible: Always User Profile Reset: No Additional Info: On this bug report form, providing the user with text entry boxes that are 4 rows in height seems way too generous, a waste of resources. Maybe if these text entry boxes could be reduced down to just 1 row, then the quality of bug reports would improve. Or if you really want to show users that you respect their time and effort submitting bugs, go ahead and reduce the height of the text entry box down to a height of just a single pixel...
(In reply to elliot from comment #0) > Description: > ...... > =A1 > expected result: > =B2 > =C3 > =D4 > > ... How do you think it could be.
(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.