https://bugs.documentfoundation.org/show_bug.cgi?id=166505
Bug ID: 166505
Summary: asymmetric failure of AutoFill to fill cells with
ascending values (AKA auto-increment or autoincrement)
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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...
--
You are receiving this mail because:
You are the assignee for the bug.
