A spreadsheet application developed by Apple as part of its iWork suite. The iWork equivalent of Microsoft Office Excel.
1
vote
2answers
300 views
What causes all iWork apps to have blank, unusable documents after a reinstall?
After deleting and re-installing the apps, I can't use iWork. Specifically, the document area is always empty, no matter if I create a new document or open an existing one. This applies to Pages, ...
2
votes
1answer
2k views
iWork '09 Numbers: How to set the default language of the document
I would like to set the default language of a Numbers document. I figured out how to do it for a Pages document:
How Do I Set the Default Language in Pages?
but I cannot find the corresponding ...
2
votes
1answer
132 views
exporting numbers 09 to excel with photos in spreadsheet
When I export my numbers spreadsheet with photos in the column the photos do not transfer when I import it into excel. How can I do this?
1
vote
1answer
26 views
Select statements in Apple Numbers '09
I've got a table as follows
| Name | Year | Price |
|____________|_______|_______|
| Foo | 2013 | $10 |
| Bar | 2009 | $3 |
| Baz | 2010 | $100 |
What I'd ...
1
vote
1answer
327 views
Cannot create new documents or open any existing ones in iWork(Pages, Keynote, Numbers)
For some reason I can't seem to create new documents in any of the iWork apps. Whenever I press the File->New button nothing happens. I've tried turning on and off iCloud synchronization but it didn't ...
1
vote
1answer
73 views
How can I assign custom colors to groups in a dispersion chart in Numbers?
I have a table with measurements of the runtime of different sorting algorithms. This data should be shown in a chart, with the number of items on the X axis and the runtime on the Y axis. To make the ...
1
vote
1answer
140 views
Numbers: How can I display negative values in a column chart?
I am using Numbers '09 v2.1 (436) and I have a table having positive and some negative values. When in my project I add a column chart mapping properly data from that table it displays a chart without ...
0
votes
1answer
101 views
Style text in Numbers formula
I have a numbers formula used in invoice generation:
="Invoice terms: "&CONCATENATE(Terms)&", please pay by ..."
Which returns:
Invoice terms: 14 days, please pay by ...
Is there a ...
2
votes
0answers
65 views
What is the Numbers keyboard shortcut to get in the formula bar of a cell?
I am looking for a keyboard shortcut in Numbers to edit the current cell via the formula bar (if that is the right word). Screen shot:
Please note, I am not looking for this answer. That is how to ...
2
votes
0answers
821 views
How do I do a pivot table in Numbers?
I can't find any equivalent of the Excel Pivot Table or Open Office Data Table features. I'd like to sum up my data grouped by values in various columns.
For example, if I have
A B C
red ...
1
vote
0answers
49 views
Is there a way to have a formula in numbers 09 return an empty value (ie isempty() returns true?)
I've got a list of times and ages, and want to extract ages for a particular range of time values. So I've used an 'if' formula to copy the age for an entry if its time is between two values. The ...
0
votes
0answers
51 views
How to build a *dynamic* dropdown in numbers?
how can I define a cell as dropdown and source its values from the column of another table?
(I know there is the cell format "Pop-Up Menu". But the disadvantages of this is that you cannot reorder ...
0
votes
0answers
139 views
Apple Numbers: ignore blank cells (until filled) when graphing charts?
I have an exercise log spreadsheet set up in Numbers, and I want to use a bar chart/graph to plot my progress. I set up the tables to extend to the end of the year, so when I plot a chart I end up ...
0
votes
0answers
63 views
Designing Character Sheets (and other complex not-quite-forms) in Numbers '09
I need some way to display certain tables depending on other inputs. I am entirely sure that there's some combination of filters, categories, and formulas that can do what I want, but I'm not ...
0
votes
0answers
89 views
Numbers nested index and match - Excel solution does not work in Numbers
I asked similar question on Stack Overflow for Excel. Unfortunately, the Excel solution does not work in Numbers. So asking here how to do the same thing in Numbers.
I have an two tables data and ...
0
votes
0answers
65 views
How can I use only certain parts of a categorized table?
For Uni, they want me to do some assignments and use MS Excel. I want to do them in Numbers, but I run into the occasional snag.
The latest assignment requires me to use Excel's 'pivot table' ...
0
votes
0answers
82 views
How do I evaluate multiple equations in a single cell?
I have two equations in a Numbers spreadsheet:
COUNTIF(PROMO,FALSE)
COUNTIF(Purchases :: WL,FALSE)
I need to merge these to satisfy one cell's value.
Something similar to countif( A && B , ...
