What has been GAINED in the Numbers 3.0 upgrade?

Hi SG,

mention of "Yellowbox"

The article also mentions "SGIII". I'm chuffed (informal English English, to be thrilled).

Good to hear that not everybody is reading only the morbid news.

Regards,

Ian.

Hi Jerry,

Your Numbers 2 screen shot shows a Header Column already in place. With no Header Column(s) , Numbers 2 contextual menu:

Yes, we can convert, but no option to *insert* a Header Column. Converting is a pain, because any entries in Column A go into the Header Column, then (sigh) we have to copy and paste into Column B, remove the grey fill, remove bold text...

Numbers 3:

Done!

Regards,

Ian

Yellowbox wrote:

Yes, we can convert, but no option to *insert* a Header Column. Converting is a pain, because any entries in Column A go into the Header Column, then (sigh) we have to copy and paste into Column B, remove the grey fill, remove bold text...

Ian,

If you are having a body column inadvertently convert to a header column, you are going about it the wrong way. If you change the number of Header Columns from zero to one, you will get a header column to the left of your original non-header column. No body column will be converted, it will just move to column B position.

Jerry

Hi SG and Jerry,

So much depends on habitual work flow and muscle memory. I will have to learn how to take advantage of new features. My mouse hand keeps going for the old Inspector!

One all?

Regards,

Ian.

Yellowbox wrote:

...

Good to hear that not everybody is reading only the morbid news.

...

Agree.

Another improvement I found is in conditional formating. When I try out a conditional format, I usually do that on one cell before selecting all. Now, when I fonund the right conditions, I can "spread" that formating from this one cell to all others that I want.

To do that, select multiple cells where at least one has a conditional format, then the sidebar shows "combine rules".

If you miss "select all cells of this rule", see the little gear at the bottom, it moved down there.

In general, I think the usability of this feature is really much better. The only wish I have is that I could highlight an entire row based on one value, e.g. a date or priority column.

Hi papalapapp,

Thanks for this positive post. Thanks for pointing out the "combine rules" option where conditional formatting differs within a selection. Thanks for pointing out the gear wheel.

I tried your advice but first I had to create a conditional format in Numbers 2, then save and open the document in Numbers 3. Are you saying you have discovered how to create conditional formatting in Numbers 3?

Regards,

Ian.

Hi Papalapapp,

The only wish I have is that I could highlight an entire row based on one value, e.g. a date or priority column.

I can't do this in Numbers 2! Can you? Pray tell.

Regards,

Ian.

Not sure now whether we are talking about the same thing. I'll post a screenshot when I'm back on my Mac.

What I mean is to apply different colouring and other styles based on the cell's content. I don't mean custom cell format like currency erc.

Click on a cell and then in the sidebar in one of the panes there is conditional formatting. There you can apply conditions and pre-defined styles.

Apply conditional format to one cell.

Select other cells that should also have that format and click "combine".

The conditional format is then applied to all selected cells.

Yellowbox wrote:

Hi Papalapapp,

The only wish I have is that I could highlight an entire row based on one value, e.g. a date or priority column.

I can't do this in Numbers 2! Can you? Pray tell.

Regards,

Ian.

Unfortunately Numbers 2 doesn't have this feature either. But for maintaining lists, I find it very useful. It is a kind of visual grouping.

Just found another useful new feature. When you format a cell as a drop down menu, you can now re-arrange the sort order of the menu items in the inspector. And you can define the first value or "empty" as default value.

Additionally, if you add items to the list in one of the cells, you can select the others and "combine" them just like it is in conditional formatting. By that you can apply the list to all cells without changing the current value.

Another gain on conditional formatting:

The cell referencing in a conditional format can now be relative. As an example, if cell A2 has the format "make bold if equal to B2" you can copy (or combine) that format to cell A3 and the reference on that row will be to B3. In the prior versions it would have remained B2 and you would have to manually change it to B3.

Yes, that is an example of it. It makes conditional formatting much more useful.