[SOLVED] AutoFormat wizard

UmTheMuse · Posted: Tue Apr 24, 2012 2:09 pm Post subject: [SOLVED] AutoFormat wizard

I've come across something that seems to be a bug, but I thought it best to ask about it instead of reporting it.

Under Format, there's an option called AutoFormat. It's got a bunch of spiffy formats that I really enjoyed using, the one time that I could. Unfortunately, after I applied a format a couple of times, AutoFormat refuses to work. The option in the menu is always grayed out now.

Does anybody know what I did wrong or can back me up here?

ozzie · Posted: Tue Apr 24, 2012 8:39 pm Post subject:

For autoformat option to be available a minimum range of 4x4 cells must be highlighted.
Is this the problem?
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

UmTheMuse · Posted: Wed Apr 25, 2012 7:05 am Post subject:

Oh, that's probably it. My information was two columns wide and far more than eight rows deep. I figured that it would pass the minimum threshold without any problem, but if it has to be that wide as well, that would explain it.

I wonder why it's implemented that way? I mean, aren't they basically patterns based on conditional formatting? I thought I remembered seeing a way to save your own patterns. Would they have the same restriction?

ozzie · Posted: Wed Apr 25, 2012 3:18 pm Post subject:

The auto format is related to making nice looking tables and a 5x3 is ok.
But for 2 rows or columns it doesn't seem to be available at all no matter how far into the wild blue yonder you want to go.
At least on my testing!
Cheers
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

UmTheMuse · Posted: Thu May 10, 2012 8:05 am Post subject:

Hrm. Are you sure about the 5x3 being ok? I thought I tried that out. Anyway, it's not all that great, because it turns out that it doesn't use styles. I mean that they're implemented like they're manually adjusted styles and you can't update all of your tables at once. Kind of defeats the purpose for me.

Also, most of the styles assume that your tables have a certain look to them--most assume that you want subtotals along the right and bottom. That's probably why they insist on 4x4.