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
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 ...
1
vote
1answer
27 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
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 ...
3
votes
1answer
600 views

How to move “section”/change “section” margin in Pages

I've been a full-time Mac user for 5 or so years now, but sometimes the Apple way still confuses my Microsoft-conditioned mind. This is especially true of iWork. In the screenshot below, can someone ...
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
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 ...
2
votes
4answers
2k 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. ...
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. ...
4
votes
2answers
35k views

Pages templates for Resumes

I'm looking for some Pages templates for Resume (software developer CV). Do you have any suggestions?
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
24 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
65 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 ...
3
votes
4answers
717 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, ...
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 ...
2
votes
1answer
361 views

How can I upgrade all my Pages '09 documents to Pages '13?

I have a very substantial body of Pages 09 documents that I work on. I've upgraded to Pages '13 recently. Now, every time I open one of those old documents to work on it, I am greeted with the ...
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
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 ...
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 ...
0
votes
2answers
342 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 ...
3
votes
2answers
357 views

Pages 5.1 underlines some words as misspelled, but does not allow me to “Ignore/Learn Spelling”

I am using Pages 5.1. When I misspell words, spellchecker underlines them in red. I am usually able to either "Ignore Spelling" or "Learn Spelling" when I right-click the word: But for some words, ...
3
votes
3answers
9k views

'Show Package Contents' in new iWork (Yosemite) File Formats

After installing both Yosemite and the new iWork suite updates (Pages 5.5 and Keynote 6.5), I've noticed I can't 'Show Package Contents' in order to access/modify the media associated with these ...
0
votes
1answer
94 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 ...
2
votes
1answer
328 views

Why is the Page Number menu item greyed out in Pages '09?

I want to insert a page number in my iWork document. I clicked on Insert and the Page Number title is grayed out. How can I get the page number feature to activate? I used to insert it in other ...
1
vote
1answer
331 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 ...
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. ...
3
votes
4answers
42k views

How do I convert a pages document to a word document without access to pages?

Suppose I didn't have access to a Mac with pages. How can I convert a pages document to a word document using only a windows environment? Is there a freeware converter available?
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 ...
4
votes
3answers
4k 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 ...
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. ...
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
2answers
6k views

How can I save a document from Pages in RTF format?

I only found descriptions were you use the export function of Pages. But there is no RTF option anymore. So is it possible to export a Pages file to RTF?
1
vote
1answer
27 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 ...
1
vote
1answer
632 views

Which animations will work on Keynote export to PowerPoint?

I have a Keynote (iWork 9) presentation and need to export it as PowerPoint. When doing it using File : Export : PPT the slides work properly, but most of the animations are broken. Is there a ...
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 ...
1
vote
1answer
254 views

Pages 4.3 on Mavericks - data loss with filenames beginning with tilde (~)

I had a client report the sudden loss of files after upgrading to Mavericks. It wasn’t difficult to duplicate the problem, on both her Mac and mine. I’m wondering if someone may have seen this ...
0
votes
0answers
3k views

Can I split a cell in a table in the newest version of pages?

I want to split a cell in the newest version of pages. This was very easy in the previous version but now I can't seem to do it. Any help is appreciated.
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 ?
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 ...
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
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
407 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
340 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
355 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
227 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 ...
3
votes
4answers
5k views

Remove header columns in Page 5.0

In the new iWork Pages, there is by default 3 cells or columns in the header and I cannot remove the column back to its original one column header just like the normal header in Pages 09'. If you see ...