iwork

Mac iWork/Pages Automation

There is a rich scripting model for Microsoft Office, but not so with Apple iWork, and specifically the word processor Pages. While there are some AppleScript hooks, it looks like the best approach is to manipulate the underlying XML data. This turns out to be pretty ugly because (for example) page breaks are stored in XML. So for examp...

Accessing cell properties in iWork Numbers

I'm trying a access the complete reference for a cell in Applescript. So far I've managed to get the cell reference and the table reference using a script like: tell application "Numbers" tell document 1 repeat with i from 1 to count of sheets tell sheet i repeat with j from 1 to count of tables tell table j try set currentCell to the f...

Creating a new table in iWork numbers on a specific sheet using applescript

I am having trouble creating a new table on a specific sheet using Applescript unless the sheet I want insert the new table in is either new or current selected. The general form of the code I am using is: tell application "Numbers" tell document 1 tell sheet "This is the sheet I want to use" make new table with proper...

iWork Numbers 09 increment a cell value

I am working with Numbers 09 and Applescript. I want to add a value in one cell to an existing value in another cell, replacing the existing value with the sum as a value. This would be similar to the copy/paste-add command in Excel. Thanks for your help. -Rob ...

Apple iWork Mime Types

I was wondering what the mime type for iWork's Pages is? And also what the mime type is for the rest of the software in the iWork suite? I looked around online and I didn't see it anywhere. Thanks! ...

Getting the Current Table in Numbers (Python/Appscript)

How do I access the current table in Numbers using py-appscript? For posterity, the program I created using this information clears all the cells of the current table and returns the selection to cell A1. I turned it into a Service using a python Run Shell Script in Automator and attached it to Numbers. from appscript import * N...

Set Selection in Numbers (Python/Appscript)

How do you set the selection for a table in Numbers using py-appscript? This seems like it should be really simple to do but the solution is frustratingly evasive. I can get the current selection: current_table.selection_range and I can get its cells: current_table.selection_range.cells() but trying to set() either of them gets...

How to set value of current Numbers cell using Py-Appscript

This seems like a straightforward operation but I am stumped. How do you set value of current Numbers cell using Py-Appscript? ...

iWork Comment Ability, Is this possible to implement using JQUERY

iWork has the ability to highlight text and then tag a comment to that text. The comment then is linked with a line to the highlighted text. I'm curious if something like this could be implemented in JQUERY. What has me puzzled is: A. How to draw a line and have it update when a user changes the text B. How to highlight text and have ...

Exporting data to iWork Numbers

Has anyone tried exporting data to Numbers in iWork? I want to generate a spreadsheet programmatically but I'm not having much success. I've tried unzipping a .numbers document and analysing the XML to see if I could interpret it but it's far too complicated. Also, I couldn't find the DTDs used by Apple. Judging by what's out there thi...

Is it possible to do some interop with iWork?

I know it is possible with the .NET framework of Microsoft to do some interoperability with Microsoft Office. Is there something that exist that resembles to it for iWork and the Cocoa framework? Edit: Here are more details. I would like to create an application that has a GUI and that can generate Pages/Keynote/Numbers documents. ...

Can I access a Mac Numbers (.num) document from within R?

I know I can use the RODBC library for accessing excel (.xls) docs from within Windows, but is there something similar for the Numbers program that come with iWorks? If not, what other solutions are there for easily editing a spreadsheet (like a lookup table) and accessing it within R? I know there the is an internal R editor, but I d...

Is there any Apis to displayed the iWork files in iPhone?

I want to display some iWork file in iphone? Is there any apis to help to display it? ...

How to extend iWork's Number'09 formulas?

I have specific formulas that I'd like to write (in Objective-C perhaps) and integrate with Numbers'09 of Apple's iWork suite in iPad and wonder if there is such a way to do so? ...

Is it possible to embed dynamic text into Keynote'09?

I wonder if it is possible to embed dynamic text into Keynote'09? I want to create a new presentation and run this presentation with different text messages (depending on the time of the day and day of the month). ...

How to program macros on iWork 09?

Hi We have a simple macro that connects Access and Excel (Office 2007 on Windows) with some forms and we are trying to create the iWork version, but I cant find how to create a macro or something, does anyone knows some manual or links to do this? Im using iWork 09 on Snow Leopard. Thanks! ...

Converting MS Word 2002 Templates from PC to Mac

I've been asked to convert several hundred MS Word 2002 Templates (on the PC) to work on the Macintosh. I have to evaluate whether the Word Templates can be run in iWork Pages and Microsoft Word for the Mac. The biggest issues that I've found thus far are that I'm unable to convert the following - Macros WordBasic code Visual Basic H...

UIDocumentInteractionController - our own app shows up in list

Our app can deal with say Pages files as an example and needs to both hand off files to other applications as well as receive files from other applications. So we edit the plist CFBundleDocumentTypes to say that we can deal with Pages files. ('Default') mode. When the user wants to send a .pages file onto another application (Likely t...

Conditional Formatting iwork Numbers

Hi, I am trying to create a spreadsheet in iwork 09 Numbers. I have values in cells along with dates, however until this date is passed I don't want the corresponding value to be included in the final "total" formula which adds all the values together. Below is the formula for one of the cells, this works fine but it shows the cell va...

How can I import HTML into an iWork Pages document?

I'm working on an ebook that I'm writing as plain text/Markdown. I converted that into HTML and would like to import the generated HTML document into a Pages document to do the final formatting. I created a Pages template and defined styles for headings, lists, etc. However, when I copy/paste the HTML file from Safari into Pages, the pa...