Stack Overflow
Stack Overflow

Questions tagged [apple-numbers]

A spreadsheet application developed by Apple Inc. part of the iWork productivity suite.

53 questions
5
votes
3 answers

How do I reference the last filled in cell in of a column in Apple's Numbers app (OS X)

I need the footer of a table in Numbers to calculate the difference between the first value in a column and the last value in a column. The last value may be greater, or smaller than the first. How do I reference the last filled in value of a…
Dave Sag
  • 13,266
  • 14
  • 86
  • 134
4
votes
1 answer

Assigning a value to merged cells in Apple Numbers using AppleScript

As part of a longer AppleScript, I'm copying strings from a list variable into ranges of merged cells in a Numbers 10.0 table. E.g., if the list is called form_filler and the first range of merged cells is B6:Y7, I first tried: set value of cell…
Buffalo Chip
  • 43
  • 5
3
votes
1 answer

Applescript has no permissions to save file

I'm trying to write a script that will convert .numbers documents to .csv documents. It needs to be executable from the command line so I can use it in a pre-commit git hook. I've written an AppleScript to take a path to a numbers file and export it…
MattL
  • 1,132
  • 10
  • 23
3
votes
1 answer

How to make a range in Numbers (iWork) using JXA

I'm using JXA for automating a process using Numbers app. What I need is to select a range of cells to apply width, but JXA doesn't allow me to get them. According to apple documentation I only need to use make or push the created object inside of…
Manuel Antonio Mora Sandoval
  • 90
  • 1
  • 1
  • 8
3
votes
2 answers

How do I create a Numbers spreadsheet using objective-c?

I'm writing a Cocoa application and I'd like to generate a Numbers spreadsheet from my application using Scripting Bridge. I've generated the Numbers.h file and linked the ScriptingBridge.framework per the directions in Apple's Documentation. Below…
Austin
  • 4,638
  • 7
  • 41
  • 60
3
votes
2 answers

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…
ruipacheco
  • 15,025
  • 19
  • 82
  • 138
2
votes
1 answer

Dynamically adding data from multiple tables into a single one in Apple Numbers

I have multiple tables in a single spreadsheet in Apple Numbers. I want to have a single, master table in another spreadsheet that contains all the data from these tables and that grows automatically as I keep adding more rows to them. For…
karahbit
  • 93
  • 10
2
votes
0 answers

Decoding an .iwa file

I am looking to view the contents of an .iwa file in my Apple Numbers project. It seems like the format is a protobuf wrapped in snappy. I was wondering if there was a relatively simple/crude way to view the text contents of the data. I tried with a…
David542
  • 104,438
  • 178
  • 489
  • 842
2
votes
2 answers

How REST function in Numbers works in Swift

In Apple Numbers the MOD function differs from Swift (in the German version it is REST. In Numbers: 4,37937=MOD(−1,90373;6,2831) versus In swift 3: let rem1: Double = -1.90373 let rem = rem1.truncatingRemainder(dividingBy:…
SteffenH
  • 29
  • 6
2
votes
1 answer

Formula to get the dates of all Sundays in the year

I am trying to create a spreadsheet with all the dates of Sunday in one column. How can I go about doing this? I have tried by using DAYVALUE(1), but cant get that to return a date.
Michelle Ashwini
  • 910
  • 2
  • 13
  • 28
2
votes
1 answer

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…
John
  • 5,139
  • 19
  • 57
  • 62
1
vote
1 answer

How do I export a column of data in my Numbers sheet to a python list?

There is a column of data in my Numbers sheet: Is there a way to export it so that it becomes a list like this, which can be used in Python? I want to use this list for a loop: ['Antrostomus noctitherus','Tringa guttifer','xxx..','xxx..'] If there…
gggjackie
  • 63
  • 7
1
vote
0 answers

Referencing last cell value in column

I need a formula for a cell in table A to reference the last cell value in a table B column C. The table B column currently has lots of blank cells that will have data added to it periodically, and the cell in table A will need to keep updating…
rwtg
  • 11
  • 2
1
vote
1 answer

Pulling multiple values of one column into a count structure with multiple counts

I am looking to pull multiple counts into a mini-chart from a column with multiple values. I am trying to do it with one formula. It would end up looking something like this: ZIP codes Count 11238 4 46260 2 30201 1 Is there any way…
Matt B.
  • 331
  • 3
  • 12
1
vote
1 answer

JXA 'Can't convert types'

JavaScript for Apple Numbers - I'm trying to use the row.address of a selected range to step through a for{} loop, but the values returned aren't compatible integers (if that makes sense). A spreadsheet is open, and several rows are selected when…
jbatl
  • 11
  • 1
1
2 3 4