1087 Views 5 Replies Latest reply: Oct 17, 2007 10:26 AM by Marc Davies
Open the users manual found on the install DVD/CD. Go to page 135. This lists how to use "Tiered List"s. I am not at my computer, so I cannot check.
From the manual:
In Numbers spreadsheets, you can place text in text boxes, table cells, and shapes.
This would imply to me that the outlined text will appear inside the cell, as I read it, it says we can place text inside a cell, then it goes on to describe how to enter the outlined lists. I don't see anything talking about entering text into another cell to expand the list. just like entering a carriage return makes it show up as multiple lines of text in one cell. (wrapping does the same thing almost).
Maybe its just the way I am reading it, But I am thinking it wouldn't handle a tiered list in multiple cells going down. What would happen if you inserted a row?
Be interesting to find out, try it and let us know by responding to this post again,
It seems that a fair bit of the Pages text formatting capabilities is implemented inside cells in Numbers. The "Text Inspector" panel give control them; the tiered numbering is accessed through the "Bullets" tab in that inspector panel. Note, though, that this seems to apply only within a cell. That is, a multi-line cell made with soft or hard returns can be numbered or tier numbered, but I see no way to number across cells using this in any reasonable fashion.
In summary, it seems that you can have outline/numbered formatted items within a cell but not outlines/numbering across cells.
You could make a column that could be hidden that had what level of indent you wanted. then concatenate the REPT function results with a formula or text to create a certain number of spaces before the line of text within the cell. You could even use a text Bullet column and concatenate that in too.
That Text bullet could be grabbed via a vlookup off a table using the indent level number on that row.
If A had the indent level and B had the bullet text then C1 could contain a formula like this
=rept(" ",a1) & b1 & "Indented Text goes here"
Would that work for you?
I can see where you are going and I like your thinking, but it assumes that my thinking and list is organised to begin with, which is rarely the case! I usually use outlining (in Pages for e.g.) then transfer to Numbers, but I still need to move things about from time to time. I guess what I'm looking for is a number system in column A for cells with entries in column B (not counting blanks) to define my top level. Then another column C with sub-numbers (decimal points) for any entries in cells in column D, level 2 etc. It just doesn't sit well visually. I could just use Pages, but I'm after an updatable scoring system in column Z (ish).
Anyway, thanks for your solution.