https://bugs.documentfoundation.org/show_bug.cgi?id=157466
Bug ID: 157466
Summary: autofill of ascending references fails with
non-sequential cell references
Product: LibreOffice
Version: unspecified
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: e...@x84.org
Description:
Working example, followed by non-working example:
Autofill function works correctly with sequential ascending cell references.
Example:
Create spreadsheet as follows:
A1: meow
A2: woof
A3: cluck
A4: moo
A5: bark
B1: =A1
B2: =A2
You may now select B1 and B2, and then you may drag the the fill handle in the
bottom right corner of the selection across the cells B3, B4, and B5, and
release the mouse button.
Result: The cells B3, B4, and B5 will auto-fill correctly, showing values of
"cluck", "moo", and "bark" respectively. Column B now contains these cell
references:
B1: =A1
B2: =A2
B3: =A3
B4: =A4
B5: =A5
Autofill of ascending references fails with non-sequential cell references.
Example:
Creat spreadsheet as follows:
A1: cat says
A2: meow
A3: dog says
A4: woof
A5: chicken says
A6: cluck
A7: cow says
A8: moo
A9: dog says
A10: bark
B1: =A2
B2: =A4
You may now select B1 and B2, and then you may drag the the fill handle in the
bottom right corner of the selection across the cells B3, B4, and B5, and
release the mouse button.
Result: The cells B3, B4, and B5 will auto-fill incorrectly, showing values of
"woof", "cluck", and "cluck" respectively. Column B now contains these cell
references:
B1: =A2
B2: =A4
B3: =A4
B4: =A6
B5: =A6
The expected behavior would have been for column B to instead contain these
cell references:
B1: =A2
B2: =A4
B3: =A6
B4: =A8
B5: =A10
Steps to Reproduce:
Autofill of ascending references fails with non-sequential cell references.
Example:
Create spreadsheet as follows:
A1: cat says
A2: meow
A3: dog says
A4: woof
A5: chicken says
A6: cluck
A7: cow says
A8: moo
A9: dog says
A10: bark
B1: =A2
B2: =A4
You may now select B1 and B2, and then you may drag the the fill handle in the
bottom right corner of the selection across the cells B3, B4, and B5, and
release the mouse button.
Actual Results:
Result: The cells B3, B4, and B5 will auto-fill incorrectly, showing values of
"woof", "cluck", and "cluck" respectively. Column B now contains these cell
references:
B1: =A2
B2: =A4
B3: =A4
B4: =A6
B5: =A6
Expected Results:
The expected behavior would have been for column B to instead contain these
cell references:
B1: =A2
B2: =A4
B3: =A6
B4: =A8
B5: =A10
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Version: 7.4.0.3 (x64) / LibreOffice Community
Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug.
