• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Numbers '08
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Numbers '08


  • Subject: Re: Numbers '08
  • From: KOENIG Yvan <email@hidden>
  • Date: Mon, 12 Jan 2009 10:07:24 +0100


Le 12 janv. 2009 à 04:59, Scott Lindsey a écrit :

However, Yvan's question still stands, as there is no selection property for the document. If you only have a single sheet and table, then yes, it's trivial. Multiple sheets, and even better, multiple tables per sheet, complicate things. Take a look at the Net Worth template.

I haven't been able to determine a "proper" way to do this, though I'm happy to be corrected.
I went on a wild goose chase with GUI scripting, but it was extremely slow. This isn't pretty, but it's less complicated, and faster than GUI scripting.


tell application "Numbers"
	tell document 1
		repeat with s in every sheet
			tell s
				repeat with t in every table
					tell t
						if selection range exists then
							return selection range
							-- or do something useful
						end if
					end tell
				end repeat
			end tell
		end repeat
	end tell
end tell

— Scott Lindsey

Thanks Scott, (and of course thanks to Michelle which tried to help)

It's the track I used but I hoped that there is a clever one.

A document may contain 255 (or 256) sheets
and every sheet may contain 255 (or 256) tables
so it appears that it's not a very efficient way to get the selection.
But it seems that we have to live with it, at least until a new version.

I encountered an other 'problem'.
We may create a new table but it seems that there is no way to define its format.
The default one has an header row and a header column.
It would be fine to be able to define which of the predefined format must be used.


Yvan KOENIG (from FRANCE lundi 12 janvier 2009 10:06:46) _______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden
  • Follow-Ups:
    • Re: Numbers '08
      • From: KOENIG Yvan <email@hidden>
References: 
 >Re: Numbers '08 (From: Scott Lindsey <email@hidden>)

  • Prev by Date: Re: Numbers '08
  • Next by Date: Re: Numbers '08
  • Previous by thread: Re: Numbers '08
  • Next by thread: Re: Numbers '08
  • Index(es):
    • Date
    • Thread