Category Archives: Numbers
Do you have any shady printer drivers installed? Thats what happened with svn. His solution? “It appears iWork hanged on my printer(s) configurated.
Also the pref. pane wouldnt open, that’s how I found the problem.
Deleted /etc/cups/printers.conf and the problem was solved.
I did have some shady windows printers installed..”
Well this article would want you to believe it Numbers Turns Scut Work to Fun Work. Numbers can be fun if they are working for you.
Barry has a brilliant suggestion for this. Some simple programming but it works great.
“For dates in column B, starting in B2.
Enter the first Monday date (May 10) in B2.
Select B2, then drag the round control at the lower right down four rows to B6 (May 14).
Click on B7 and enter =B2+7
Select B7 and drag the control down as many rows as you need.”
Barry’s explanation is a little long but correct. The poster did say it resolved the issue.
Interesting problem. If you are into Applescript you can find a possible solution here.
Of course. Isn’t this obvious to everyone? Thanks Barry! “Here’s an alternate method.
You’ll need two unused cells. I used E1 and F1. These establish the maximum permissible value for A1 and B1 respectively.
In E1: =C1-B1
In F1: =C1-A1
Condition for A1: Greater than E1
Condition for B1: Greater than F1
I set the action to fill bright red, text white. Both cells will change at the same time.
Yvan once again comes to the rescue. “Question asked and responded several times.
Here is my own response updated :
Select the chart and its legend.
Group the objects.
Copy the group in a Pages document, export this document as RTF.
Control click the .rtfd file which will be created.
Select “Show Package Contents”.
You will see the content of the doc. One file is a PDF containing the chart with its legend.
Some times ago, I wrote an AppleScript automating the process.
Go to my iDisk:
double click on “saveChart.applescript”
Read the given explanations and apply them.”
It is bizarre the kind of limitations it has. You can read more from Mr. Garcia here. “–iWork: ’09 files only. iPad iWork Apps do grant access to iWork.com–
For iWork users, the iPad may support Microsoft formats, but it does NOT support iWork ’08. If you want to have your iPad and Mac work off the same files, you need iWork ’09 on your Mac. However, an interesting remedy (which I haven’t tried fully yet) is iWork.com. In order to participate in the beta of the site, you need iWork ’09 or an iWork app for the iPad. (I was a little suprised, but I was able to sign up for and activate just owning Numbers for iPad, and not iWork ’09) From there, you should be able to interact with your documents using Safari on your Mac, without iWork ’09. Considering the time of year, I can’t justify upgrading to it, so I intend to try this solution until the next iWork comes out. The downsides are, of course, cloud computing, and iWork.com does not seem to allow creation of new documents, only working with existing ones uploaded from iPad or Mac. What that means is I must create a document on my iPad to work with it on iWork.com. And by interesting extension, while iWork.com works with all 3 apps, since I only have Numbers, I can’t use iWork.com to use Pages or Keynote in the cloud on the cheap, as I can’t create a document without owning their appropriate app.”