Tables Part 7: Good-looking, well-behaved table formatting made easy …

re: Tables Part 7: Good-looking, well-behaved table formatting made easy …

Chartman — Tue, 08 Nov 2005 02:58:20 GMT

This is a dream come true. It may just save me from developing carpel tunnel syndrom. Thanks!

re: Tables Part 7: Good-looking, well-behaved table formatting made easy …

Nigel Harper — Tue, 08 Nov 2005 13:01:15 GMT

Dave,

I have never really used styles in the past precisely because of the limitations about inserting new rows or deleting existing ones etc. I can see these new dynamic ones as being very useful.

Can the printing of these 'auto-styled' formats be switched of. Often what one wants on screen and the printed page are different things. Printouts can quickly become cluttered with too much going on on the page.

One of the main things I do is to highlight input cells (cells without precedents) in one colour and output cells (cells without dependents) in another. Input cells I divide into two types where one is a result of a query and the other is a cell into which the user types directly. A style which could do this kind of detection and highlighting work would be very useful. I find that once users pick up on these styles and their meanings they are adopted very quickly and it helps when sheets are doing the rounds and being viewed and updated by more than one user.

This may all fall under formula auditing and precedent/dependent detecting so you may have more to say on this at a later stage. Will you be covering these issues and calculation engines any time? I still cannot see how Excel 12 is going to deal with a, say, 10-nested IF array formula scanning 500000 rows when it already struggles (timewise) to deal with a 3-nested IF array formula over just 5000 rows. All the new specs and multi-threading, dual-core handling will be for nought if it takes half an hour to calc a single column of cells.

Thanks again,
Nigel

re: Tables Part 7: Good-looking, well-behaved table formatting made easy …

Syndrome — Tue, 08 Nov 2005 20:43:56 GMT

And when everyone's super... (laughs maniacally)... no one will be.

re: Tables Part 7: Good-looking, well-behaved table formatting made easy …

Tianwei — Tue, 08 Nov 2005 22:05:03 GMT

David, wrapped up tables already? Is pivottable going to be a section of its own?

When do you plan to unveil the new charting?

re: Tables Part 7: Good-looking, well-behaved table formatting made easy …

Jean Martineau — Wed, 09 Nov 2005 02:21:03 GMT

Nice improvement David.

|If the “first column” option is enabled, then |Excel will always make sure the first column |is formatted appropriately no matter which |column is in the first position.
In some tables, it would be nice if we could have more than one "first column".

Jean

re: Tables Part 7: Good-looking, well-behaved table formatting made easy …

David Gainer — Wed, 09 Nov 2005 04:44:55 GMT

Howdy folks, thanks for the kind words.

Nigel – You can turn the styles off and then print, and there is another solution I can think of that I will cover later when I talk about themes, but these styles are formatting, so the default behaviour is to print, just like “direct” and conditional formatting. Also, we have improved cell styles, and they will now include styles for things like input, output, calculation, linked, check, and external data cells. Are there others you use typically? (More on cell styles in a later post too.) With regards to the calculation engine, we do further performance tuning each version, but the largest performance gains this version will come from multi-threading.

Tianwei – PivotTables are definitely going to get a lot of posts of their own … lots and lots of features left to cover. New charting around Christmas at current pace.

Jean – Thanks for the feedback.

re: Tables Part 7: Good-looking, well-behaved table formatting made easy …

Jason Moser — Wed, 09 Nov 2005 08:29:24 GMT

Will the table definition be adjustable to deal with multiple header rows? If for example I have 2 rows of titles (with a higher level grouping and then the titles themselves) then will I be able to define this?

re: Tables Part 7: Good-looking, well-behaved table formatting made easy …

Jean-Marc Decouleur — Wed, 09 Nov 2005 12:38:53 GMT

Hi David,

That's good stuff. Would be nice to have specific formatting for freeze rows or columns (freeze panes) that are part of the table.
Also having a style that visually indicates when some rows or columns are hidden (or filtered) would be wonderful. That's one common issue with Excel beginners, they don't notice that some pieces of information are not currently displayed.

Jean-Marc

re: Tables Part 7: Good-looking, well-behaved table formatting made easy …

David Gainer — Wed, 09 Nov 2005 19:15:02 GMT

Jason - not as currently implemented, though I have heard several requests for this revently.

Jean-Marc - thanks for the feedback. If you turn on headers and first columns and freeze panes where those intersect, I think you will get the effect you are looking for. Also, we have done work to try and make filtered rows more obvious (see autofilter improvements post).

Excel 2007 documents – easy on the eyes

Microsoft Excel 2007 (nee Excel 12) — Mon, 13 Mar 2006 21:27:41 GMT

One of the themes we focused on with Office 2007 was “great looking documents”.&nbsp; For the next half-dozen...

But wait, there’s more (styles) … Table Styles in Excel 2007

Microsoft Excel 2007 (nee Excel 12) — Fri, 31 Mar 2006 08:15:36 GMT

Last post we looked at Cell Styles – both the changes we made to the feature as well as the set of Cell...

Give us your thoughts on chart and table styles

Microsoft Excel 2007 (nee Excel 12) — Tue, 23 May 2006 21:39:51 GMT

In previous posts, I have talked about new features we have added around chart styles and table styles.&nbsp;...

Microsoft Excel Tables Part 7 Good looking well behaved table | Outdoor Decor

Microsoft Excel Tables Part 7 Good looking well behaved table | Outdoor Decor — Sun, 14 Jun 2009 01:06:10 GMT

PingBack from http://outdoordecoration.info/story.php?id=4544

Microsoft Excel Tables Part 7 Good looking well behaved table | patio cushions

Microsoft Excel Tables Part 7 Good looking well behaved table | patio cushions — Sun, 14 Jun 2009 19:17:53 GMT

PingBack from http://patiocushionsource.info/story.php?id=2120

Microsoft Excel Tables Part 7 Good looking well behaved table | fix my credit

Microsoft Excel Tables Part 7 Good looking well behaved table | fix my credit — Wed, 17 Jun 2009 04:54:18 GMT

PingBack from http://fixmycrediteasily.info/story.php?id=17449

Microsoft Excel Tables Part 7 Good looking well behaved table | patio set

Microsoft Excel Tables Part 7 Good looking well behaved table | patio set — Thu, 18 Jun 2009 05:23:21 GMT

PingBack from http://patiosetsite.info/story.php?id=965

Microsoft Excel Tables Part 7 Good looking well behaved table | storage bench

Microsoft Excel Tables Part 7 Good looking well behaved table | storage bench — Fri, 19 Jun 2009 11:05:52 GMT

PingBack from http://thestoragebench.info/story.php?id=10422

Microsoft Excel Tables Part 7 Good looking well behaved table | adirondack chairs

Fri, 19 Jun 2009 12:26:22 GMT

PingBack from http://adirondackchairshub.info/story.php?id=3616