Stack Overflow
Stack Overflow

Questions tagged [apple-numbers]

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

53 questions
0
votes
1 answer

Mac Numbers : Calculate Date (by adding number of weeks to a date)

How do I add a number of weeks to a date in Mac Numbers ? Eg - How do I calculate the value for cell C1 in the below Cell A1 = Project Start Date (Date) Cell B1 = Project Length in Weeks (Number) Cell C1 = Project End Date (Date)
SteveFrancis
  • 3
  • 4
0
votes
1 answer

Populate Numbers Pop-up Menu cell using AppleScript

I have a Numbers (iWork 09) spreadsheet where I want to be able to populate a Pop-up Menu cell with values to enable easy analysis of selected data. I have the AppleScript to generate the values that I want put into the Pop-up Menu, but need a means…
Andrew Cain
  • 1,193
  • 2
  • 10
  • 8
0
votes
1 answer

How can I switch sheet focus in Numbers using JXA?

I am working on a JXA script that will be used to copy tables from an existing Numbers sheet, and then paste them into a newly created sheet (in the same document) before making some modifications to individual cell values. I have most of what I…
Michael Potts
  • 1
0
votes
1 answer

generating iWork Numbers file on iOS

Has anyone had any luck with generating a spreadsheet file in iWork Numbers format on iOS? At least is there any documentation on the file format?
Yurie
  • 899
  • 1
  • 6
  • 10
0
votes
0 answers

Mac Numbers: How to replace the original column values with original column values times two?

Mac Numbers: How to replace the original column values with original column values times two? For example, for column B2, I have B2 -- 2 4 6 8 10 How to change to B2 -- 4 8 12 16 20
Zhang Yongheng
  • 125
  • 2
  • 10
0
votes
0 answers

Auto-populate a cell with a date when another cell is populated

In Excel I can add the following formula... =IF(A1="", "", IF(B1="", NOW(), B1)) This formula says when a value in added to cell A1 populate cell B1 with the current date. To get this to work you must turn on an Excel feature named iterative…
codingguy3000
  • 2,695
  • 15
  • 46
  • 74
0
votes
2 answers

How can I concatenate a range of cells according to adjacent value?

In the following table, I'd like to concatenate the numbers of column B, according to string in column A: For example, all the numbers adjacent to XX would be copied to another cell in this format: 12, 12, 21, 23, 31, 32. I can manually concatenate…
Wiewiorowski
  • 5
  • 4
0
votes
1 answer

Excel or Numbers, How Populate adjacent Column?

So I feel like this is a pretty simple question, but I cannot for the life of my find the answer, here or elsewhere. I'm trying to autopopulate a column with custom text. I suppose it would be the row adjacent. Thought vlookup was the solution, but…
digitalbum
  • 1
  • 1
0
votes
1 answer

Convert Excel or Numbers (mac) hyperlink to html a tags

I'm trying to convert an Excel, Word, or Numbers hyperlink to HTML tag. For example, I have [linkName] and need [linkName]. Any ideas? Thank you.
Daniel P.
  • 184
  • 1
  • 3
  • 16
0
votes
1 answer

Auto match unique string and populate it with data from another CSV

I don't know what is the correct term for this, but I just want to populate a new column with data from another csv. For example I have this data with a new column, let's call it CSV 1 (3rd column is blank). Order #, SKU, cost ORDER-A,…
jehzlau
  • 627
  • 2
  • 9
  • 20
0
votes
1 answer

JXA: how to make a new sheet in a document in Numbers.app

I'm using JXA to automate a process using Numbers app. What is the syntax to create a new sheet in an existing document? var Numbers = Application('Numbers'); Numbers.documents[0].Sheet()... The AppleScript equivalent would be: tell application…
user7423370
  • 31
  • 4
0
votes
2 answers

Apple Numbers - How to make sure a cell never goes below Zero

I have created a spreadsheet in apple numbers and third cell is the difference between 1 and 2. How do I make sure the 3rd cell never goes below Zero if the 2nd amount is greater than than the first amount? £650.00 £100.00 £550.00 Many thanks for…
David Mason
  • 159
  • 3
  • 14
0
votes
3 answers

Right to left support for Apple Numbers app

How can i create a sheet in Numbers app with right to left supports (Header columns on the right , Freeze columns on the right ...) ? I tried to import Excel file with RTL sheet but it was inverted to LTR by the app. Please don't suggest to use…
Oleg Sherman
  • 2,772
  • 1
  • 21
  • 20
0
votes
1 answer

Conditional Formatting iwork Numbers

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…
Elliott
  • 3,812
  • 24
  • 69
  • 93
0
votes
1 answer

Re-Creating Polynomial From Apple's Numbers App in Python

I am currently working on finding polynomial equations to describe data sets (simple tables with one x and one y value) in Python. I need a polynomial equation to describe the data set so that given a number x I can derive it's y value. If I enter…
Wes
  • 3
  • 4
1 2
3
4