This discussion is archived
1350 Views 10 Replies Latest reply: Feb 3, 2009 7:37 AM by KOENIG Yvan
As I get the basic things working with Numbers, there are some smaller issues I wonder if there are solutions for.
I wanted to have a save button on the toolbar like I do with Excel, but I can't find that option - does it exist?
Happily there is not such a button.
When I want to make a change to borders (or any "fill" option), Numbers makes me select each item again (what border, general type - like thin, then the width, and finally the color. Is there no way to have the last choice selected stay there - at least until Numbers is launched again? Sure would save me time.
No such feature.
_Go to "Provide Numbers Feedback" in the "Numbers" menu_, describe what you wish.
Then, cross your fingers, and wait _at least_ for iWork'10
Again, with borders, I have two major situations where I used them with my gradebook. In the attendance table, I have a series of weeks (just the weekdays) and I use a heavier verticle border to separate them. Without that, it is much harder to keep track of where I am. I also have horizontal, heavier borders, to separate groups of instruments for the same reason.
Well, I was experimenting with using categories and while it has some possibilities for me (and some problems), whenever I use it, I lose all those borders! Losing the horizontal ones would be okay since the categorizing would accomplish about the same thing, but I sure don't want to lose those that separate each week!
Finally, if I decide I don't want to use categories for whatever reason, is there a way to get those borders separating instrument groupings automatically?
I do have a field I sort by for the instruments. If there was something that would take what instrument that was in a certain row and compare it to the prior row and changing the border if it was different, but leave it normal if it was the same, that would do it. Didn't see any way to do that though. Maybe Applescript could, but I haven't gotten into that yet (but if that will work and is the only way, it would be nice to know if Applescript can or can't).
AppleScript would be able to set a background according to a condition (not a border) but you will have to run the script by yourself to apply it.
It would be more logical to apply a rule setting a background according to the content of a given cell.
This is perfectly described in the PDF User Guide which every user may get from the Help menu.
Yvan KOENIG (from FRANCE lundi 26 janvier 2009 12:20:31)To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.11)
Well, pretty much what I thought - I just hoped I had missed something on at least some of them.
Setting the background won't work in my situation. It would be fine in cases where the number of students on an instrument was small, but in the larger sections, not so good. It is too easy to lose your place on long rows when a bunch together are all the same color. I do the alternating colors for this reason, though, if I had a choice, I'd rather have rows change colors in groups of three.
Oh well, I guess I'll just continue with the manual borders - or maybe I'll add a blank row, make it very narrow, and color that in as a divider. That way I should be able to just move it when the instrumentation changes rather than remove a border and put it someplace else.Macbook, Mac OS X (10.5.6)
I just wanted to echo some of what you're saying. I'm switching my gradebook from Excel to Numbers '09 this semester and I'm finding a few things frustrating. Like you, I want to have a 2 pt. vertical line to separate the weeks in my gradebook. In Excel, copying the border format is cake. You select a group of columns (one week in our case) and use the Format Painter to copy that border style to the rest of the columns. I can't find a way in Numbers to do this without selecting each week and clicking about 7 times to set the border type set. What a pain! I tried the Copy Style/Paste Style functions, but it doesn't appear to work for copying border style.
I really want Numbers to be better than Excel for something basic like a gradebook. It's not like I'm trying to do any heavy lifting with this spreadsheet.Mac Pro, MacBook, 2 Mac Mini's, iPhone 3G, Mac OS X (10.5.6)
The Copy Style and Paste style buttons in the Tool palette do that .
I just made a new test.
Set a cell with a red border of 1 point.
Select its style with the button "Copy Style"
Select a group of 40 cells
Click "Paste Style"
The 40 cells have now a red border
Yvan KOENIG (from FRANCE mercredi 28 janvier 2009 19:59:47)To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.11)
Now that's interesting. I had done a few attempts at copying and pasting styles the way I would with Excel and get strange results - at least strange compared to what I expected!
Your comments may have revealed the problem I had. I wasn't trying to copy the style of a single cell, but of a whole column or row. Works in Excel so that different formats within the selection can be applied elsewhere.
From what you wrote, would I be correct that Numbers only deals with the style of one cell as the original, not a range of cells, but you can apply a style from a single cell to a bunch of cells only?Macbook, Mac OS X (10.5.6)
Well, Numbers doesn't have everything Excel has. Though some things may be better and some things are fine once you adjust how you approach things.
For example, my Excel gradebook has all the attendance and various test categories in one big sheet. And I have vba routines that work from buttons on the sheet to jump around and run routines (like adding and deleting students, clearing all data except names, etc).
But with Numbers, I need to break that down into smaller tables for different sections and then a summary table to let me see the big picture easily.
I'm still working on my new gradebook. I'm pretty happy with what I have so far - does pretty much what I did with Excel, but Applescript is much slower that vba (and I really don't know how to do Applescript yet without help). And no buttons on the sheet to make running them easy.
Don't know how long you've worked with Numbers, but I've only had it for two weeks or so and I can say I had plenty of frustrations. But most of them were because of the natural adjustments I had to make in how things worked. Fortunately, people here have been a HUGE help!
I also read a lot of the other threads and little by little pick up useful info.Macbook, Mac OS X (10.5.6)
I respond to two messages in a single one.
(1) if you select several cells before pressing "Copy Styl", only the attributes of the first cell are copied so the behavior will be the same than the one get with a single cselected cell.
(2) You may get help here but it would be more efficient to get the resources delivered by Apple.
In each program of iWork you may activate:
Help > program User Guide
Help > Functions and Formulas User Guide
When you reach them, save them on your disk so they will be available instantaneously.
As the three programs share a lot of resources, Functions and FormulasUser Guide is the same for the entire package.
Yvan KOENIG (from FRANCE jeudi 29 janvier 2009 16:05:32)To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.11)
That's what I figured out the copy styles must be doing after reading your other post.
As for getting answers, I do it every way possible - I've taken weekly lessons at the Apple store, read documentation, read a fair percentage of other questions people ask and the answers, and, of course, ask questions myself.
I'm working to solve a lot of things all at once. Some problems that come up are not as critical as others so I set them aside temporarily (like the copy styles thing), but conveniently your answer to the original poster clarified that before it became a bigger priority so that was nice.
There are a bunch of things I've learned on my own but, of course, you don't see those mentioned here.Macbook, Mac OS X (10.5.6)
This only works if you select "outside edges" (i.e., surround the cell with a box). Try to put a line above and below the cell (which takes MANY mouse moves) -- as an accountant would do to show a subtotal -- and you cannot copy and paste the style. (An accountant would want a double-underline beneath the grand total too, and that's impossible in "Numbers".)Mac Pro dual core, Mac OS X (10.5.6)
Just for info:
Your tracking number for this issue is Bug ID# 6551043.
Given a cell whose four sides are defined with the same red border.
If I select it
click the "Copy Style" buttonin the Tool Palette
select a range of cells and click the "Paste Style" I get every cells of the range with their sides in red.
Why is this feature applying only if the source cell has four borders?
If only one, the top side for instance is a red border, the described protocol does nothing.
It looks like a bug.
Yvan KOENIG (from FRANCE mardi 3 février 2009 16:37:26)To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.11)