Bug 157466

Summary:	autofill of ascending references fails with non-sequential cell references
Product:	LibreOffice	Reporter:	antifascist <es20>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	VERIFIED DUPLICATE
Severity:	normal
Priority:	medium
Version:	unspecified
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	spreadsheet demonstrating the reported bug

Description antifascist 2023-09-27 04:55:50 UTC

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

Comment 1 antifascist 2023-09-27 04:59:07 UTC

Created attachment 189842 [details]
spreadsheet demonstrating the reported bug

attached is a spreadsheet demonstrating the reported bug

Comment 2 antifascist 2023-09-27 05:57:34 UTC

I found this bug is a duplicate of 139681.  will update bug 139681 with the info from this bug.

Comment 3 Werner Tietz 2023-09-27 05:58:42 UTC

NOT A BUG

Use in B1:
=OFFSET(A1;ROW();0)
and pull down

Comment 4 antifascist 2023-09-27 06:05:51 UTC

Werner, I disagree because the behavior is inconsistent.  For numbers, the autofill works one way, but when the same numbers are present as cell references, then the autofill produces chaotic results.  I appreciate the workaround method you have shared, however, this autofill should be fixed.  It is normal to be able to produce the same result with different methods, however in this case, the autofill method seems to be malfunctioning.  There can not seem to be a rational explanation to explain why the autofill function should produce the behavior that we see here.  If there is an explanation for it, I would be curious to know about it?  Thank you!

*** This bug has been marked as a duplicate of bug 139681 ***