Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [iwork]

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.

Filter by
Sorted by
Tagged with
2 votes
1 answer
76 views

Editing one column of table based off another

It seems like something that should be simple, and it probably is but my mind is being dense and not helping me. I have a table with two columns. The first acts as a master list of titles, and the ...
user717452's user avatar
0 votes
0 answers
12 views

"Floating" image in iWork Numbers?

Is it possible to make an image "float" in Numbers? That is, similar to how the heading row can remain visible ("float", "freeze pane" in Excel lingo) when scrolling down ...
d-b's user avatar
  • 3,348
0 votes
1 answer
80 views

How to convert any duration to days in Numbers?

I have something like this Start time (A) End time (B) Time passed (C) Units done (D) How many units per 24h (E) 08:25 15:40 7h15m 43 ??? I can manually calculate that 7h15m = 26 100 seconds. 26 ...
d-b's user avatar
  • 3,348
1 vote
0 answers
62 views

How to move an equation in a diagram in iWork Numbers?

I have a diagram in macOS Numbers 12.2.1 with two trendlines where I also inserted the equation for each trendline. The problem is that those two equations are on top of each other and I can't find a ...
d-b's user avatar
  • 3,348
1 vote
0 answers
25 views

Valid UUID for iWork database items

Starting with this post, I am trying to insert my own Shapes into Pages and one of the challenges is being to generate a valid UUID for the identifier. I have tried UUID version 1, 3, 4 and 5, none of ...
MikeiLL's user avatar
  • 515
4 votes
1 answer
365 views

How to import file to shape in Pages

I recently downloaded a resume template file for Pages, which has a some "shapes" in it and I'd like to add my own icons as shapes (for Github, StackExchange, etc), which I haven't come ...
MikeiLL's user avatar
  • 515
0 votes
0 answers
30 views

iWork ‘06 apps won't start due to missing files after restore

Recently I restored my PowerBook G4 with macOS Tiger. I copied the all apps and QuickTime Pro license too. But when I open Pages, Number or Keynote a message that tell me that some files are missing ...
Paolo's user avatar
  • 97
1 vote
1 answer
145 views

Time spent in each slide during rehearsals in Keynote?

Is it possible to measure the time spent in each slide in Keynote, during a rehearsal? Something like this feature of PowerPoint: https://support.microsoft.com/en-us/office/rehearse-and-time-the-...
a06e's user avatar
  • 262
3 votes
2 answers
439 views

How do I prevent Pages from hyphenating a specific word?

I have read Wrap words in Pages but my question is different. How do I prevent a specific word from being hyphenated (because Pages is wrong - "IS-P:er" (!!))? I have a vague memory that ...
d-b's user avatar
  • 3,348
0 votes
0 answers
416 views

Numbers: How do I refer entire rows in different sheets?

I am trying to create a table that contains all entries from other sheets in the numbers file. In all of these other sheets, the structure will be identical. The reason for why I do this, is because ...
Nachtfunke's user avatar
0 votes
1 answer
410 views

How do I get rid of "The formula uses a Boolean in place of a number"?

I'm using a formula to convert stone and lbs to lbs only. Here is the formula that I am using: INT(B13)×14+IF(INT(B13)≠B13,(B13−INT(B13))×10^(LEN(B13)−FIND(".",B13))) My stone and lbs are ...
Klitiko's user avatar
  • 15
0 votes
2 answers
2k views

(Pages) Keyboard shortcut to change colour of selected text

Is it possible to make a shortcut in Pages to change just the selected text (not entire paragraph or part with the same style) to any colour of choice? I am trying to achieve some sort of a quick ...
Josh E.'s user avatar
  • 133
0 votes
1 answer
88 views

iWork'09 retail installation DVD : does the language and/or region matter?

Does iWork'09 retail DVD allow installation in any language or shall one care about it? Example: Can on install iWork in German from a DVD purchased in the US? Is iWork'09 retail DVD the same ...
OuzoPower's user avatar
  • 405
1 vote
2 answers
98 views

How to know if a iWork'09 DVD is retail?

Some sellers of second-hand iWork'09 specify that their product is "Retail", and show the original packaging. Others don't, but the pictured DVD seems however being the same. My question is: ...
OuzoPower's user avatar
  • 405
2 votes
1 answer
2k views

Install new LaTeX packages in Keynote, Pages [duplicate]

I was trying to make a presentation in Keynote since it had a direct LaTeX equation writer embedded. However, I soon realised that some of the commands (and therefore packages) were not supported. I'...
PensoGlide's user avatar
3 votes
0 answers
189 views

Run Numbers '09 (v 2.3) under Catalina or later

I vastly prefer running the older Numbers for Mac (Numbers '09). I've kept my iMac running Mojave for this reason. But I'd like to upgrade my OS. What (if any) is the best way of running Numbers '09 ...
Questulent's user avatar
0 votes
1 answer
44 views

(Pages, iWork) Defining a space between some characters

Is it possible to make a "small" space after certain characters such as before "%". The space should be shorter than standard space, e.g., half of the default space. An example: I ...
Josh E.'s user avatar
  • 133
1 vote
0 answers
37 views

Numbers for iPad If checkbox false then clear value so when ticked again cell is blank for next manually input value

I have 2 tables on top of each other. Table 1 contains a checkbox in cell F80, when ticked its cell background colour changes to dark green. On top is Table 2-1 which has text and outlines in sheet ...
Spiritvw's user avatar
0 votes
1 answer
788 views

Numbers, Pages, and Keynote crash immediately on launch (2020 M1 Mac Mini)

Just got a brand new M1 Mac Mini (2020) today. I opted for a clean install and did not restore from Time Machine. To my surprise, I'm experiencing a nearly immediate crash on launch for Keynote, Pages,...
jdobres's user avatar
  • 131
2 votes
0 answers
34 views

Are there any details available about the "password protection" in Apple's office suite (e.g. Numbers.app, etc.)?

I had a co-worker ask me if password-protecting a Numbers document was "safe" because we know that early-model MS Office versions had useless encryption and also "Zip 2.0" ...
Christopher Schultz's user avatar
1 vote
1 answer
79 views

(iWork) Numbers: Cut and Paste, macros

Is there a way to "cut" certain cells and paste them to another cells or sheet without losing formulas with references to other cells (such as MS Excel does with command+X). Numbers does not ...
Josh E.'s user avatar
  • 133
1 vote
1 answer
213 views

Getting Data back from damaged .pages file

This question is not duplicate as this thread didnot solve my problem since I cannot upload my data on Icloud. I am trying to restore data from a folder which I later found is similar to .pages ...
aneela's user avatar
  • 121
0 votes
3 answers
892 views

Apple Numbers use Actual date instead of formatted date

I have a spreadsheet with a list of months as the columns with the value 1/1/2020, 2/1/2020, 3/1/2020, etc. The cell format has been set to January, February, March, etc. When I attempt to use date ...
Chris Bartow's user avatar
2 votes
6 answers
12k views

Need Mac Numbers & Pages for Mojave

I have a 2010 MacPro running Mojave. I've been trying to buy, copy, or steal copies of Pages and Numbers for hours just so I can work on a client's Pages file. Why is this so hard?
Jeff Schalles's user avatar
0 votes
0 answers
37 views

Convert .pages to .pdf with images as a preview (or convert vectorized images to lossy formats within .pdf)

I have a long paper in which all of the pictures I drew and put them in the document as .pdf. Is there a way to protect these images from copying by conversion to image formats such as (.jpeg, .png, ...
Josh E.'s user avatar
  • 133
1 vote
1 answer
14k views

How can I install Pages or iWork on a Mac running High Sierra 10.13.6? [duplicate]

Is there any way now of installing a version of Pages or iWork on a Mac running High Sierra 10.13.6?
Giles Smeath's user avatar
1 vote
1 answer
1k views

Numbers : sum if tick-box on next column is true

I have 3 column in a numbers sheet (A) Text | (B) Currency | (C) Tickbox At the end of (B) Currency, I have a very basic formula SUM(B) What I'm trying to do is to have the same SUM(B) at the footer ...
Kevin's user avatar
  • 2,378
0 votes
1 answer
294 views

How to enter Unicode (or other) symbols in LaTeX within Keynote (iWork)

In Keynote and other iWork apps, it is possible to enter formulas (and text) in LaTeX. This is an immensely valuable feature. But... How can I enter an astronomical (or other) symbol, via Unicode or ...
TransferOrbit's user avatar
1 vote
1 answer
157 views

Import text from webpage directly into Numbers cells

In a numbers file I am using, whenever I open it I need to manually import a specific value from a webpage. Specifically, from this webpage I want to import the USD to EUR ratio. Any other similar ...
manosbar's user avatar
  • 131
0 votes
0 answers
31 views

Using Mouse scroll plus Control for iWork suite?

I would like to use zoom function in Pages / Keynote using Mouse scroll + Control while I work most of the time using an external monitor without trackpad. Such feature works in .pdf viewer or ...
Josh E.'s user avatar
  • 133
1 vote
0 answers
253 views

How can I downgrade from keynote 10.1 to 10.0?

Well, I updated to Keynote 10.1 and it hangs when starting the slideshow of the presentation. All of them went well on v10.0, but they don´t in v10.1. Any advice or suggestion. (Running in macOS 10.15....
José Antonio Díaz Navas's user avatar
1 vote
3 answers
594 views

Is there a way to automatically save Pages documents copies as PDF on every save?

Is there a way to enable Pages (version 10.1 (6913)) to automatically save a copy of the current document as PDF every time I save it to avoid a manual export?
Igor_Marques's user avatar
0 votes
2 answers
4k views

In Numbers make Y axes show smaller values

I have a table making a line graph with very small numbers that vary from 0,000149 to 40, and when I make a line graph out of this table of numbers the very small numbers are crunched in a horizontal ...
Tibério's user avatar
2 votes
3 answers
1k views

Numbers not creating a line graph

I'm quite new to Numbers (and spreadsheets programs in general) but I need to create a simple line graph based of a spreadsheet but for some reason Numbers is not making the lines of the graph even ...
Tibério's user avatar
0 votes
2 answers
706 views

iWork Numbers How To Calculate - In Once Cell Function - The Elapsed Time In Hours Between Two Date/Times?

Let's say I have two date/times. The start date/time is 29th May 2020 at 20:30 and the end date/time is 30th May at 02:30. This link shows how to calculate using two cell references. How to ...
Max MacLeod's user avatar
1 vote
1 answer
481 views

Is it possible to define a custom numbering style in Pages?

I would like to cite some articles, books. The standard form is to use square brackets, but Pages these are not within Pages numbering styles. I want to achieve: [1] 1st source [2] 2nd source . ....
Josh E.'s user avatar
  • 133
3 votes
4 answers
10k views

How to add hyperlinks to local files in Numbers?

How do I add a hyperlink to a local file? I know how to add a hyperlink to a website, so I tried something like file:///Users/MyUser/Documents/Invoices/Some%20Stuff.pdf However, adding this path to ...
WalterBeiter's user avatar
0 votes
1 answer
22 views

Is it possible to set opening certain apps such as Safari, iWork, MS Office in the full Window mode by default like Mail App (macOS Catalina)?

The only App I can set opening in the full window is Apple's Mail App - it can be set in the App setting. I suppose other application could be set via terminal commands, but I'm not that handy with ...
Josh E.'s user avatar
  • 133
1 vote
1 answer
597 views

Numbers - INDIRECT Call Error

I have a spreadsheet in Apple Numbers which I use to track debts and amortize payments. To do this, I use calls to INDIRECT on the Amortization table to load relevant data from the Debts table. ...
Luke's user avatar
  • 187
5 votes
2 answers
6k views

Heatmap in Numbers (colouring cells by their numeric value)

In Excel, it's possible to display a "heatmap", i.e. colouring a group of cells depending on each cell's numeric value: I'm looking to do the exact same thing in Numbers, but surprisingly I couldn't ...
Jivan's user avatar
  • 151
1 vote
3 answers
613 views

Pages - new paragraph in the same list item?

I create a numbered list: 1. Point 1 2. Point 2 and so on. Now I realised that the content of 2 requires two paragraphs 1. Point 1 2. Point 2, paragraph 1 Point 2, paragraph 2 but pressing ...
d-b's user avatar
  • 3,348
1 vote
1 answer
47 views

Opening any of the iWork suite brings up over 80 dialogs in a row

Upon opening Pages, Keynote or Numbers I'm informed that it "needs to download the font X" with a skip or a download button via a dialog (great choice, something that remains in the centre of the ...
ian's user avatar
  • 471
2 votes
1 answer
124 views

How can I autofill a formula in Numbers, but keep some referenced values the same?

So I have a chart in Numbers (iOS version, but I can use the macOS version, if needed,) which has formula that references some values from the chart, as well as some values from a different chart. I ...
At0micMutex's user avatar
  • 3,563
2 votes
0 answers
47 views

Pages exact same font, looks sharper when using template

I have been using the default fonts in the 'Business Resume' template and I wanted to use them in my handcrafted version due to this bug. The fonts are pretty simple and nothing extraordinary, for ...
monster's user avatar
  • 121
1 vote
1 answer
2k views

Help with AppleScript to automate Numbers Cell Formatting

I do several mundane repetitive tasks using Numbers App on a Mac, and wish I could just automate the same with the help of AppleScript. I got Numbers Spreadsheet with several tables, on the selected ...
Savin's user avatar
  • 39
3 votes
1 answer
81 views

Numbers - continuous line connecting gapped data?

This question over on SuperUser is exactly the same as mine, in the sense that I have a CSV that contains gaps in each column, but I want to plot it as a continuous line. However, I'm using Numbers, ...
Jeeter's user avatar
  • 131
2 votes
1 answer
489 views

Pages: Fit two A5 page on on a single A4 page in landscape mode

I want to print the same content twice on a page and then cut the page into two parts. Basically I want to start with an A4 page in portrait mode, and want to end up with (approximately) two A5 in ...
d-b's user avatar
  • 3,348
1 vote
2 answers
390 views

Is it possible to export a simple Numbers spreadsheet while being dynamic?

I have a few Numbers Spreadsheet that I use to keep track of my budget over the weeks/months but its only accessible in Numbers, which is fine Until I am at work where we use windows. My only ...
user avatar
0 votes
0 answers
255 views

Identify last (or first) non-blank cell in range

Is there a way to identify the last (or first) non-blank cell in a range? Consider a sheet that may have multiple rows with blank cells in a certain column. In a cell, I'd like to use the value of ...
jetset's user avatar
  • 201
0 votes
1 answer
357 views

Evaluate a formula stored in a cell

Is it possible to store an expression in a cell and then refer to it/evaluate it within other cells? I've found myself repeatedly using complex expressions in cell formulas, e.g., the sub-expression ...
jetset's user avatar
  • 201

1
2 3 4 5
7