iWork is Apple's suite of productivity software for the mac as well as iOS. iWork includes "Pages" for word processing, "Keynote" for presentations, and "Numbers" for spreadsheets.

learn more… | top users | synonyms

0
votes
1answer
6 views

Can Numbers use 8 hour long days when converting from days to hours?

Using Numbers 3.6.2, I am using cells formatted as "Duration" in days. I then have a SUM cell that sums all the durations and shows for example "64d" (Suppose in cell D1). I then do in a new cell (D2 ...
0
votes
0answers
12 views

Multiple condition or Regular Expression matching with conditional formatting in Numbers?

I'm useless without colors to help my brain, so Numbers' conditional formatting works well for me.. up to a point. I'm afraid I'm hitting up against Apple's wont fix complexity threshold, but oh well. ...
0
votes
0answers
22 views

Summing data on multiple worksheets

I’ve recently run into a curious issue. I need to sum the values across multiple tables - basically to combine fields from the two pairs of tables I have, e.g. row 1 column 2 from table 1 with row 2 ...
0
votes
1answer
37 views

Is disk version of iWork 08 compatible with El Capitan

Opened a iWork 08 Pages file created in 2015 and very little appears. All text is white and can’t be changed to black. This was not a problem on my previous OS. IS this a El Capitan issue?
2
votes
0answers
23 views

How can I install template from 3rd party to Keynote?

After downloading a template for my Keynote program, I can't seem to install it correctly so that I can utilize the 200+ slides that are included when I wish to add a new slide in the presentation. I ...
0
votes
1answer
39 views

Getting the First Cell NOT Containing Certain Text in Numbers

I have a table in Numbers, and I'm trying to get the value of the first cell that contains the character …. In order to do so, I wanted to use MATCH(), but had no luck after I realized it could only ...
0
votes
1answer
64 views

Re-download OS X iWork suite (Pages, Numbers, Keynote)

Apple introduced Pages, Numbers, and Keynote as a Mac native platform for documents such as letters, spreadsheets, and presentations. These applications come pre-loaded with OS X, as they did with my ...
0
votes
0answers
31 views

Numbers: How to merge multiple sheets of products into one sheet, automatically update on change of data

What i'm trying to achieve is a database for food products split into three categories:- Frozen, Ambient and Chilled. Each category is on a separate sheet which is the data and in each category it ...
3
votes
2answers
90 views

The SUM function in Numbers 3.6.1 on my Mac OS X10.10.5 isn't calculating correctly. Why?

You can see in the attached screenshot that I have used the SUM function to add the values in column E. There are several "1" values (you can see one in cell E126) but the SUM always comes out at ...
0
votes
2answers
289 views

How does one use different languages in Pages headers and footers?

[EDIT] I'm afraid this language feature is gone in Pages 5.* How does one use different languages in Pages headers and footers? I don't need spell checking but language switching (for headers and ...
0
votes
1answer
92 views

Number 3.6.1: Cell value needs to be invisible, if the adjacent checkbox is checked

I'm not sure if this is the right forum, but here goes: I would like to keep the cell value (E8), if the adjacent cell (D8) is false (checkbox is not checked), else insert zero or null. I just keep ...
0
votes
1answer
35 views

Repeating a formula for every row in Pages

I'm working on a simple formula in Pages where I have a table with 4 cells per row. Product Name, Purchase Price, Quantity and Total. I've created a simple formula that multiples Purchase Price ...
0
votes
0answers
80 views

“Database” report writer for Numbers?

I serve on the Board of a Baroque Orchestra and have begun helping them get organized. The management of the orchestra does not have extensive technical skills so I've endeavored to help provide them ...
3
votes
1answer
6k views

Why are Pages/Numbers/Keynote not free in the App Store on new iPhone 6s?

I got a new iPhone in the US, but am using it abroad (Israel) and with my old Apple ID. In the App Store I see the Apple Pages/Numbers/Keynote with a price tag on them (not free) when they should be ...
1
vote
1answer
330 views

iWork and iLife are not free after reinstall

I recently bought a Macbook Pro 13" Early-2015 from a guy who used it only once and then reinstalled it for selling (already upgraded to the latest El-Capitan). After I set up my Apple ID I couldn't ...
1
vote
1answer
26 views

Numbers Between Formula

IF(AND(B13≤74,B13≥75,B13>90),"0","3, 5") I'm trying to generate an if statement that outputs either 0 if under 74 or under 3 between 75 - 89 and 5 if over 90. I have been trying the above however ...
0
votes
0answers
24 views

How can I change the behavior of alt-return and return in Numbers 3.6?

According to https://discussions.apple.com/thread/2448952?start=0&tstart=0, there's a box at the bottom of the table inspector: There are at least two ways to make multiple lines in a cell. ...
1
vote
0answers
21 views

In Numbers.app, Is there any function to identify if another cell is a formula, or contains a specific function?

I have a cell in a row that is either a directly entered number, or a SUM() of some other cells. Is there any function I can use in a different cell to know if the value in the former cell was ...
1
vote
2answers
101 views

How to correctly uninstall an App Store application [duplicate]

Recently I installed Pages which I purchased with version of iWork '09. Unfortunately this operation downloaded and installed version Pages 5.5.3 which is not exactly an upgrade of Pages '09. ...
1
vote
1answer
26 views

Pages: line break appears before end of line

For some very strange reason, I cannot seem to fit the text on line 2 inside the empty space of the 1st line. I tried deleting the words and re-writing them, which didn't work. I tried changing font ...
0
votes
1answer
72 views

In Numbers, how can I sum only if adjacent cell is certain value? [duplicate]

In excel, as shown here, it is possible to find and sum only cells with have a specific value next to them. Is there a way to do a similar thing in numbers? Specifically, I have a very long table ...
0
votes
4answers
7k views

iWorks no longer free after fresh install of El Capitan

I just installed a fresh copy of El Capitan on my MacBook Pro Retina (2013 model), and iWorks are no longer free in the App Store, as has been the case in Yosemite. See the screenshot: What are the ...
0
votes
1answer
96 views

Get pages and iMovies free

I got macbook pro late 2013 and normally Pages and iMovies they are free for mac after 2013 but when I got to app store I can't get them for free. Any help here or how to get them free ?
3
votes
1answer
1k views

Where are iWork templates saved?

I'm using iWork (specifically Pages 5.5.3) and I can't find the templates I created for this anywhere on the HD. Library > Application Support > iWork > Pages > Templates > My Templates Only shows ...
0
votes
1answer
142 views

Link tables for auto new rows - Numbers

Is there a way I can "link" tables in Numbers so that when rows are added to the "master" table that the identical rows and containing data are added in a linked table? I know I can "link" cells using ...
0
votes
1answer
13 views

Apple software - Numbers [closed]

How do I identify and add(sum) only specific cells in a row - they are not continuous cells. Ex. I1, O1, U1 total sum and show in BG1
0
votes
1answer
402 views

How do I plot two data streams in Numbers as a graph?

I have two different streams of fractional values I want to visualize using Numbers for Mac. They both have one value per line and both look would look something like this (with different values ...
1
vote
1answer
337 views

Can Numbers create stacked column charts with two columns for each category?

I'm trying to create a column chart in Numbers where each column is also stacked. For example, consider the following data. Here we have numbers for the total sample and numbers for how that total ...
2
votes
1answer
351 views

How to change chart colors in Pages 5?

I cannot change the individual colors in my charts. Under "Chart Colors" there is only this list of 12 predefined color swatches called "fill sets". Most of them are ugly. Not being able to change ...
2
votes
2answers
225 views

Launch an older version of an application by default?

There are two sets of applications where I'm running into this issue: iWork, where I only have the new stuff installed because Software Update harasses you to install the new stuff if it detects you ...
0
votes
1answer
152 views

How can I create a live updating slideshow?

I have a need to create a short slideshow style presentation (doesn't have to be a slideshow particularly if something else is more appropriate) which updates it's contents on the fly. The content is ...
0
votes
0answers
91 views

Apple Numbers … SUM all rows below cell (But NOT the summary row) dynamically

I have the following formula: =SUM(B4:B12) The cell this is in is B3. It works fine with the formula above. The problem happens when I add a row after B12. Then I have to readjust formula. to ...
0
votes
1answer
485 views

Safe to Delete Keynote Cache under /Library/Container/com.apple.iWork.Keynote/Data/Library/Caches

While the question "is it safe to delete /Library/Caches" is commonly seen, OSX also has another path for storing caches (not sym link). Keynote has another cache stored at ...
1
vote
1answer
3k views

How do I get to my Keynote 6.5 themes folder?

I've created a theme using File > Save Theme and would now like to share it with others. Where in the world is it though? It's visible in the File > Change Theme area but I can't find the source ...
2
votes
0answers
52 views

Looking for a grandma-safe way to create two-fold greeting cards

My Mom (+ 70) longs for the day when her Windows Paint Shop program would walk her through creating a 2-fold 8 1/2 x 11 card. She could assemble the card one page at a time and not think about what ...
2
votes
1answer
53 views

Pages question on Apple yosemite

How can I get rid of the Right hand column (with Margin, layout info) on the Pages. I just want the page to show my letter when sending. I run Pages v5 on OS X Yosemite.
4
votes
1answer
11k views

New version of Keynote won't open old versions

When using a newer version of iWork software such as on Yosemite to open older documents and presentations, Pages reports "This document can’t be opened because it’s too old. To open it, save it with ...
1
vote
1answer
29 views

How to mark some columns as ignored for calculations Numbers?

I'm creating a template on Numbers and I would like to know if there is a way for the formula to ignore, or skip over some cells or even entire columns. I need these columns for some calculations, but ...
2
votes
0answers
550 views

batch convert iWork 08 files to new version on Yosemite

TL;DR Short version: I have a bunch of files that were created with iWork 08. Is there a way, maybe using AppleScript or Automator, to convert them to the new format (Pages 5.5, Numbers 3.5) without ...
1
vote
1answer
337 views

Are older versions of iWorks available?

Can I download a version of iWorks from Apple that will work with 10.6.8 before I upgrade to 10.7 or above. I have a lot of Appleworks files I want to convert before I upgrade the system.
1
vote
2answers
3k views

Linking between tables in Numbers

I have a table in numbers, and I want a cell to equal the value of a cell in a different table. Following the advice of this Apple discussion, I tried =Units Sold::B2 , with Units Sold being the ...
0
votes
1answer
1k views

Two value-based axis for chart in Numbers 3.5

I am trying to achieve a chart in Numbers 3.5 where both axis scale linearly. Right now, my chart looks like this: Obviously, I want the x-axis to scale because the 100.000 bytes message is MUCH ...
1
vote
1answer
10k views

How to get iWork and iLife after upgrading to Yosemite from Mavericks?

I bought a mid-2014 MBP Retina (activated on 30/09/2014) from a friend and did a re-installation of Mavericks, then upgraded to Yosemite right after the re-installation (without associating the mac to ...
3
votes
3answers
5k views

Auto-Populate A Pop-Up Menu in Numbers 3.5

I'm trying to steer clear of Excel, despite my sister's nagging, and I've done pretty well to create a Quote and Invoice workbook in Numbers. The problem I am having is working out how to ...
1
vote
0answers
44 views

How to quit a file without modification & without changing its modification time?

Within my work I regularly open files with Pages, Numbers, Keynote… and even if I typed anything within these files I want to be absolutely sure I didn't modify them in any way. Moreover I want to be ...
1
vote
5answers
2k views

Paste HTML into Pages

I'm trying to copy stuff (including tables) from a web page and paste it into a Pages document, retaining html formatting (as much as possible). With Pages'09 this used to work using OpenOffice as ...
6
votes
1answer
757 views

How did the function “Save As…” change to “Duplicate”?

I recently noticed that within Pages ('09), Numbers ('09), Keynote ('09), the menu entry: File > Save As… had been replaced by a new one: File > Duplicate On the other hand I still use this ...
0
votes
1answer
5k views

How do I add media not in iPhoto to a Keynote presentation

I want to use folders other than IPHOTO and PHOTOBOOTH when adding media in iWork applications. For example when using Keynote, this pops up. How do I add folders to the pop-over meniu?
2
votes
1answer
741 views

Disabling warnings in iWork

Is there any way of disabling the warning popups in the current versions of Numbers, Pages and Keynote that popup when files are opened? For example: They are pretty useless warnings, in the sense ...
2
votes
1answer
2k views

Installing just Pages 09 from old iWork 09 Disk on Yosemite

I still love the old pages '09 I run it side-by side with the new pages on my two iMacs. However, on my new Macbook it is not installed and I want to run it on there (the new pages doesn't have some ...