Auto Fill Not Working

[snakeman10]

When I type 1 in one cell, then 2 in the cell below that, and then drag once the cell with 2 is selected, the cells below that fill in with 2's. It used to be that it would continue on with the projected sequence of numbers (1,2,3,4 etc.) but it doesn't work anymore, any idea what's wrong?

[RoryOF]

Do you drag by the little black square at bottom right of the selected cell?

[snakeman10]

Do you drag by the little black square at bottom right of the selected cell?

yes

[RoryOF]

Check that /Tools /Cell Content : AutoCalculate and AutoInput are checked.

[snakeman10]

Check that /Tools /Cell Content : AutoCalculate and AutoInput are checked.

both are checked

[RoryOF]

Then I'm beyond my knowledge of Calc - you'll have to wait for a serious Calc user to come online.

[acknak]

Check what version of OO you're using--some older versions had this feature disabled. This was on Linux only as far as I know, never for Windows.

If that doesn't help, you might try a fresh OO settings profile: [Tutorial] The OOo user profile

[Alex1]

The control key changes the behaviour of the fill handle, or you can select both cells before using the fill handle.

[snakeman10]

Check what version of OO you're using--some older versions had this feature disabled. This was on Linux only as far as I know, never for Windows.

If that doesn't help, you might try a fresh OO settings profile: [Tutorial] The OOo user profile

using 4.1.1

The control key changes the behaviour of the fill handle, or you can select both cells before using the fill handle.

Control did did nothing, selecting both cells didn't work either. I can live with it.

[snakeman10]

I found a little trick......I opened a new spreadsheet and auto fill works fine, I can copy and paste my numbers to my working spreadsheet. I have a hunch that I must have done something in the regular sheet to disable the feature, but it just takes a second to copy and paste.

[rhowl]

I am having the exact same problem. Tried everything mentioned here and nothing works. So I did what snakeman suggested, I opened a new sheet and auto fill worked fine, so I just copied and pasted to the new sheet. Thanks for that tip! I wonder why the auto fill works in new created spreadsheets but not the one I'm working on?