Auto Fill Not Working
-
- Posts: 13
- Joined: Mon May 27, 2013 6:47 am
Auto Fill Not Working
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?
OpenOffice 4.1.1 Win 7
Re: Auto Fill Not Working
Do you drag by the little black square at bottom right of the selected cell?
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
-
- Posts: 13
- Joined: Mon May 27, 2013 6:47 am
Re: Auto Fill Not Working
yesRoryOF wrote:Do you drag by the little black square at bottom right of the selected cell?
OpenOffice 4.1.1 Win 7
Re: Auto Fill Not Working
Check that /Tools /Cell Content : AutoCalculate and AutoInput are checked.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
-
- Posts: 13
- Joined: Mon May 27, 2013 6:47 am
Re: Auto Fill Not Working
both are checkedRoryOF wrote:Check that /Tools /Cell Content : AutoCalculate and AutoInput are checked.
OpenOffice 4.1.1 Win 7
Re: Auto Fill Not Working
Then I'm beyond my knowledge of Calc - you'll have to wait for a serious Calc user to come online.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Auto Fill Not Working
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
If that doesn't help, you might try a fresh OO settings profile: [Tutorial] The OOo user profile
AOO4/LO5 • Linux • Fedora 23
Re: Auto Fill Not Working
The control key changes the behaviour of the fill handle, or you can select both cells before using the fill handle.
AOO 4.1.15 & LO 24.2.2 on Windows 10
-
- Posts: 13
- Joined: Mon May 27, 2013 6:47 am
Re: Auto Fill Not Working
using 4.1.1acknak wrote: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
Control did did nothing, selecting both cells didn't work either. I can live with it.Alex1 wrote:The control key changes the behaviour of the fill handle, or you can select both cells before using the fill handle.
OpenOffice 4.1.1 Win 7
-
- Posts: 13
- Joined: Mon May 27, 2013 6:47 am
Re: Auto Fill Not Working
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.
OpenOffice 4.1.1 Win 7
Re: Auto Fill Not Working
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?
OpenOffice 4.1.5 on Windows 7