0
votes
0answers
16 views

Numbers never responds

When I try to run Numbers, it bounces for a while, and then just stops. No windows, no menu bar, nothing. When I Ctrl-click the icon, it says not responding, so I force-quit. I have never actually ...
0
votes
0answers
10 views

Loading xlsx file in Numbers, Filter Table is disabled on columns

I loaded an Excel file (XLSX format) with a table in Numbers, where I had filtered out some data based on a column (using Excel's column-based filtering options). In Numbers, I only see the filtered ...
1
vote
0answers
12 views

How can I restore an older version of a Numbers document (before the sync)

I'm using Numbers on my iPad and my Macbook. Yesterday I opened my Macbook and for some reason it opened the Numbers app but didn't sync. I didn't really need to work on the file so I just left it ...
0
votes
0answers
18 views

Sort selected columns by row

In Numbers, how is it possible to sort selected columns by a row? In the following example I want to sort the columns B, C and D by using the values in row 1. So far, I have only found the reverse ...
1
vote
0answers
45 views

Can't use any of the iWork apps

I'm unable to use any of the apps included in the iWork package. If I try to open any one of them, the app opens but I can't perform any action. I click on the bar menu items to see that even 'About ...
2
votes
1answer
35 views

How to handle Numbers' automatic Data Formatting?

I'm trying to put together a sheet that calculates hours I work. One thing I want to do is calculate hours that are billable. So I have something like this: Things that aren't billable or are ...
0
votes
0answers
38 views

Copy Paste formula in Number 3.2

I have20 three-member groups with different individual measures. So, I have a sheet in which I have 60 (20*3) rows and number of columns )+ heading row). I also have another sheet in the same file ...
1
vote
1answer
32 views

How do I change the sheet color in Numbers 3.x?

Right now the sheet color is white. But it is hard on my eyes. How do I change the sheet color to black? I'm using a Numbers 3.x in OSx 10.9.3
2
votes
1answer
18 views

Sequential numbering for pseudo-“Rows”

tl;dr: Formula to number rows that doesn't break when some "rows" are made of multiple, merged spreadsheet rows. Scenario: I am making a check-list (of things to look at when apartment-hunting) in ...
1
vote
1answer
28 views

One Odd-Sized page in Pages Document for PDF

Need to embed a Numbers spreadsheet in a Pages doc that will “live” as a PDF. Generating a scaled image that I then embed results in mediocre resolution.
2
votes
0answers
27 views

Numbers 2: Create a new header cell, listing once the contents of a column

Not sure how to search for this question, and moreover I rather think that what I want might not be possible, but just in case I am asking it here. I am looking for a way to create a new table where ...
3
votes
1answer
251 views

Numbers v3.1: Automatically link URLs in spreadsheet?

I've inherited a spreadsheet that has a loooong column (thousands) of URLs, all unclickable. I'd like to make them clickable. I have tried the following: Highlighting the column. Select column, ...
3
votes
1answer
631 views

Swap X and Y axes on Numbers 3.1

This link is now outdated with the new release of numbers. I want to transpose the X- and Y-axes on a chart in Numbers 3.1. How the heck can I do this? The first chart I made was able to sum my ...
2
votes
2answers
371 views

Connecting MySQL DB to Apple iWork Numbers?

I'd like to visualize some data from a MySQL database using a Mac, but it hasn't been easy finding a solution to this. I understand Excel has DB connectivity, but currently I only have Apple Numbers. ...
2
votes
1answer
88 views

Reinstall Numbers?

I got myself into a state where App Store says that I have numbers "installed" but in fact I don't have it installed. I tried the recommended option/click and shift/click over the installed button and ...
6
votes
2answers
108 views

Is this possible to link the value to a database in Apple's iWork suite?

For example, I would like to make a Pages document that has a value that's linked to the company information and Keynotes and Numbers as well. So, when our company information changes, all the ...
1
vote
1answer
263 views

Numbers: How to change cell text conditionally?

I am trying to change the text of a cell in Numbers 3 according to a condition. E.g. if A1-A2 is a negative value, the text shall be 'Negative'. If the value is positive the text shall be 'Positive'. ...
0
votes
0answers
28 views

iWork Numbers 3: detect change in row

I'd like to update the datetime in a cell whenever any cell in the row changes. Is this possible in iWork Numbers 3? If not possible to look for changes in entire row then perhaps only "watching" a ...
5
votes
3answers
1k views

How to store new iWork (2013) documents in a flat file (for version control)?

With the October 2013 iWork update, the new UI is great but it seems one cannot store documents as 'flat file' any more. This really limits my ability to store the files, essentially ruling ...
1
vote
1answer
152 views

How do I sum up specific things in Numbers?

I have a spreadsheet in the newest iWork Numbers.app, with something like: CATEGORY | POINTS HW | 100 HW | 100 NW | 12 HW | 50 NW | 23 I want to just sum up all the ...
0
votes
0answers
50 views

Pages mail merger with numbers formulas in pages not working afterwards

I have the following setup for my invoices: Numbers file with client info, daily rate and days worked on a project. Pages file with mail merger fields. The merging works fine, and all infos are in ...
1
vote
0answers
297 views

Converting a float to hours:minutes in Numbers

Probably this is a very easy thing to do, but as handicapped as I am using Apple's iWork applications, I just can't find it. I have made a calculation in Numbers which results for example in 14,25 or ...
1
vote
1answer
743 views

How to convert a Numbers file to .pdf and still have its formula work

Is there a pdf creator or something that I can convert my Numbers file with all its formula still working. The file is a price calculator with choice of products. I dont want the client to change ...
1
vote
1answer
104 views

Is it possible to change the font and button size of the format bar in numbers '09

I need to increase the size of buttons and front on the format bar in numbers '9
0
votes
1answer
139 views

iWork Numbers increase column size for sum

If I have columns that sum at the bottom, how can I have the sum function automatically include a newly inserted row. a +---+ 1 | 1 | 2 | 1 | 3 | 1 | 4 | 1 | +---+ |=sum(a1:a4)| Then when ...
1
vote
1answer
4k views

How to install Pages, Numbers and Keynote on Snow Leopard?

I just purchased a used 2006 MacBook Pro with OS X 10.6.8. I went to the Mac App Store and tried to load Pages, Numbers and Keynote, and it said it could not load them unless I had 10.7. When I try ...
5
votes
2answers
4k views

How can I change the data source of a chart in Numbers '09?

I have made a chart in Numbers '09 and now I want to create another very similar chart but with different data, so I have copied and pasted the chart and now I want to make it take its source data ...
2
votes
1answer
462 views

Is it possible to change text size & formatting of Numbers' formula input field?

Is it possible to set the text-size and possibly other formatting of the actual values/formula input field in Apple iWork Numbers? Comparing these two screenshots, it seems possible to set the size ...
2
votes
2answers
1k views

How do I move a row between two rows in Numbers?

Simple question. In iWork's Numbers, is there any way to move a row of data between two rows, as opposed to just plopping it on top of existing data? You can easily do this in Excel if you hold down ...
0
votes
1answer
179 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
1answer
4k 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 ...
3
votes
1answer
326 views

Is there an equation in Numbers that will give me the sum of numbers based on a separate column?

I'm trying to find out if there is a way to create an equation that looks at one column, if it is equal to a certain value, then add the value in the other column? Example: #Table of running values: ...
0
votes
1answer
464 views

iWork Numbers evaluate string

I have a cell with the following content 2262/4121. I want to have a cell next to it that contains the result of that expression. Is there a function for that?
2
votes
2answers
465 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
2answers
2k views

iWork '09 Keeps asking to be Registered

I'm a teacher in a classroom with 8, 9 10 and 11 year olds who each have a macbook or a macbook pro. Fun job. We have a standard 10.6.6 image with iWork '09 (4.03). In previous images, iWork would ...
0
votes
1answer
2k views

Conditional SUM() based on text of a cell using iWork

I have some basic data Name | Amount Jake | 10 Jake | 12 Jake | 13 Ben | 1 Ben | 14 Ali | 9 Ali | 4 I want to total up the amount for each person so I end up with something like Jake | 35 Ben ...
3
votes
2answers
9k views

Swap X and Y axes in Numbers?

I'm taking an economics course, and for whatever reason economists create graphs with the independent variable (price) on the Y axis and not the X axis. If I only have 1 dependent variable to graph, ...
3
votes
2answers
9k views

Can Numbers ’09 import an Excel XML file?

Can Numbers ’09 (part of the iWork suite) import XML files? Specifically, the format created by Excel when exporting as "XML Spreadsheet 2003." I can't just use Excel's native format because the ...
5
votes
3answers
7k views

How to convert .number file to any of the readble format including excel and pdf without having mac

I have an important .number iworks file. My Mac is now no more... How do I convert .number file to any of the readble format including excel and pdf without having mac.