| View previous topic :: View next topic |
| Author |
Message |
sookietex
Power User
Joined: 16 Jul 2003
Posts: 76
Location: NYC
|
 Posted: Tue Dec 14, 2004 11:46 am Post subject: Autoformat Disabled |
 |
|
Hello all. Sorry if this is a RTFM question [i have to no avail  ] i'm new to OOCalc, using version 1.1.0 After selecting the desired range of cells using the SUM function, the autoformat function on my main toolbar is disabled. i've right clicked on the toolbar to customize it, and checked the box next to the autoformat icon. when i click add, apply and/or OK, i get "this feature already exists", but when i return to the spreadsheet autoformat is still greyed out. i've selected format and the autoformat button is greyed out. Visible buttons on main toolbar has a checkmark next to autoformat, but when i try to access the function, it's still greyed out. Please, what am i doing wrong?  any/all help much appreciated. Thanks
_________________
"Choose well, for your choice is brief, yet endless"~Goethe |
|
| Back to top |
|
 |
r_vinoya
Super User
Joined: 03 Dec 2003
Posts: 619
Location: Somewhere in the Philippines
|
| Posted: Tue Dec 14, 2004 4:57 pm Post subject: Re: Autoformat Disabled |
|
|
| sookietex wrote: | | Hello all. Sorry if this is a RTFM question [i have to no avail ] i'm new to OOCalc, using version 1.1.0 After selecting the desired range of cells using the SUM function, the autoformat function on my main toolbar is disabled. i've right clicked on the toolbar to customize it, and checked the box next to the autoformat icon. when i click add, apply and/or OK, i get "this feature already exists", but when i return to the spreadsheet autoformat is still greyed out. i've selected format and the autoformat button is greyed out. Visible buttons on main toolbar has a checkmark next to autoformat, but when i try to access the function, it's still greyed out. Please, what am i doing wrong? any/all help much appreciated. Thanks |
Hello,
First of all I like to thank you for the "AUTOFORMAT" option. I never notice its existence and never tried to use it until your post. 
BUT Unfortunately, after trying it for a minute or so, I tried replicating your problem.
1) Got to Tools=>Configure
2) Customize my custom toolbar
3) Add AutoFormat Option
And after I did this, the autoformat function icon turns dark, and it is grayed out as you said. Now I can't get it back to work again 
At least now your not alone with this problem. I'll check if this is posted in Bugs&Issues after I submit this post.
_________________
# : - ) |
|
| Back to top |
|
|
r_vinoya
Super User
Joined: 03 Dec 2003
Posts: 619
Location: Somewhere in the Philippines
|
|
| Back to top |
|
|
sookietex
Power User
Joined: 16 Jul 2003
Posts: 76
Location: NYC
|
| Posted: Fri Dec 17, 2004 4:33 pm Post subject: Autoformat Disabled [info update] |
|
|
Hi r_vinoya, everyone. As Homer Simpson would say D'oh! i figured out what i was doing wrong. i didn't know that when selecting the cells for autoformat that the cells must not contain any data. As i'd mentioned i'm a calc newbie so i hope you'll all forgive such a silly mistake [i thought you could enter the data and then select the autoformat to change the sheet's appearance  ] Live & learn Thanks again everyone for your time. Hope my screw-up will save others the same fate 
_________________
"Choose well, for your choice is brief, yet endless"~Goethe |
|
| Back to top |
|
|
r_vinoya
Super User
Joined: 03 Dec 2003
Posts: 619
Location: Somewhere in the Philippines
|
| Posted: Fri Dec 17, 2004 7:10 pm Post subject: Re: Autoformat Disabled [info update] |
|
|
| sookietex wrote: | | Hi r_vinoya, everyone. As Homer Simpson would say D'oh! i figured out what i was doing wrong. i didn't know that when selecting the cells for autoformat that the cells must not contain any data. As i'd mentioned i'm a calc newbie so i hope you'll all forgive such a silly mistake [i thought you could enter the data and then select the autoformat to change the sheet's appearance ] Live & learn Thanks again everyone for your time. Hope my screw-up will save others the same fate |
Yeah!
I also noticed that AUTOFORMAT works (At least in my case) ONLY when selecting range for AT LEAST 3 columns AND 3 Rows:
Ex.
When selecting 2x3, or 1x3 or 2x5 cells, AUTOFORMAT won't work
But when selecting 3x3 or 4x5 or 10x3, AUTOFORMAT can work, Irregradless if It contains data or not.
_________________
# : - ) |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
