A spreadsheet application developed by Apple Inc. part of the iWork productivity suite.
Questions tagged [apple-numbers]
53 questions
0
votes
0 answers
Scrapy crawls returning numbers in parentheses. Displaying as negative in spreadsheet. Fix?
Doing a crawl on a site for prices that is returning an item that looks like this in scrapy shell:
[u'\n($200.00)\n']
When I save to CSV and open in Apple Numbers the number shows as -200.00. There is another price on the same page that I scrape…
Jay Littles
- 5
- 3
0
votes
1 answer
Removing the text, Applescript
So I've made a script that will allow me to copy the sender of the email and paste it into the Numbers document, the copied addresses list two different emails and I need to remove one of them.
tell application "Mail"
set theSenderList to…
LearningTheRopes
- 3
- 3
0
votes
1 answer
Use Applescript to duplicate row n times in Apple Numbers
After several attempts with VBA and Excel for Mac returning a syntax error, I've resorted to Applescript and Numbers. I need to print barcodes for every item in our inventory; however, the barcode printing software only recognizes printing rows and…
Judson Hanna
- 51
- 1
- 1
- 3
0
votes
1 answer
How to SUM cells value skip blank cells in iWork Numbers?
When the range of cells contain blank cell, the sum function always give a 0,
column
2
3
blank
blank
4
=sum(A2:A6)
I expected the SUM give 9, but it is zero. The formula =SUMIF(A2:A6,"<>") not work, may be it work for excel, but not in Numbers
Yu Jiaao
- 4,444
- 5
- 44
- 57
0
votes
1 answer
Excel sumseries and Apple Numbers compatibility
I need to calculate the total tuition to estimate the needed savings. That is, the tuition -now- is 10.000€, the estimated inflation is 2%. How much tuition is going to be paid in 10 years during four years?
Using the trick described here, I can…
GUI Junkie
- 539
- 1
- 17
- 31
0
votes
1 answer
Hot get rich text of cells in Numbers
I want to convert rich text cell content of my numbers table to other formats like Markdown or HTML. But how do I get more then just plain text?
Maybe there's a solution how to set the selection range and copy it as rtf to the clipboard.
tell…
Nebula
- 157
- 5
0
votes
0 answers
Using Linq to XML to output an Apple 'Numbers' compatible spreadsheet?
I'm working with a (VB.NET) site that was handed to me after 5+ years of being created and maintained by another programmer. The site uses Linq to XML to generate a file as an Excel (2003) .xls file.
#Region "Download Excel"
…
Xeper Caz
- 48
- 7
-1
votes
2 answers
Excel/ Numbers search for multiple occurrences
I have a CSV sheet with phone numbers and a bunch of unneeded text.
How do I go through the sheet and show each phone number along with the number of times it occurs in the list?
For…
brian
- 156
- 1
- 1
- 11