Apache OpenOffice (AOO) Bugzilla – Issue 18224
Fill Right/Down with formulas behaves unexpectedly
Last modified: 2003-09-08 16:55:29 UTC
Reproducible problem - tested in both 1.0.2 and 1.1 rc3: Create a column with text values (e.g A1=fish, A2=bicycle, etc) - at least 5 values. Create a row where B1 contains '=A1', C1 contains '=A2', D1 contains '=A3' The use the fill option (either from Edit menu or the 'black button') to fill right. Fill repeats formula instead of increasing them: =A1, =A2, =A3, =A1, =A2, =A3 etc instead of =A1, =A2, =A3, =A4, =A5 etc This seems to happen regardless of the isolation of the values (similar problem is you use =$A1, or =$A$1). However, if you repeat the process in a column, using 'Fill Down' then it behaves 'properly'. I have just discovered that if you reverse the process (create a 'row' of words, and then create a column of 'formula' and try 'Fill down' the same repetition problem occurs.
Hi, this is not a bug. If you autofill to the right, you will, in most cases, extend the column reference and if you use down, you want to increase the line number. If you select B1:D1 and drag them to the right it will increase the column to start at D1 (in E1) and then increase the number of the row to read D2 and D3 and so on. This is how it should work and how most other Spreadsheets act. So closing this one as invalid. Frank
closed invalid
Created attachment 8473 [details] Demonstration of reported bug.
I think you may have misunderstood me on this one. If you along the row: 1,2,3 and then fill right, you would expect the row to read 1,2,3,4,5,6 yes? But if you do what I reported as a bug, you get 1,2,3,1,2,3,1,2,3 etc Which isn't expected behaviour at all. I have included an example spreadsheet to demo this problem, in case my explanation isn't clear... The presence of the $ in the formula should clearly indicate to the fill command which value should be incrementing - in fact it doesn't increment either, it just repeats the selection.
Hi, an autofill is similar to an copy and paste with adjusting the relative references. In your example the $ makes the column absolute and the rownumber doesn't change, so no change in the relative position of the row is given. This functionality works as designed and the other spreadsheets act in the same way. It's just a convention of common use of such an functionality. So this works as expected and therefore this Issue is Invalid. Best regards Frank