Re: Value of an empty cell in Numbers
Re: Value of an empty cell in Numbers
- Subject: Re: Value of an empty cell in Numbers
- From: KOENIG Yvan <email@hidden>
- Date: Wed, 4 Feb 2009 11:03:14 +0100
Here is an enhanced version of the handler doYourDuty()
--=====
on doYourDuty(r, c, t, s)
local tName, newTable, errMsg, errNum, sheetName, flag
tell application "Numbers09" to tell document 1
if value of cell r of column c of table t of sheet s is not 0.0 then
set flag to false
else
tell sheet 1
set tName to "temporary_yraropmet"
set newTable to make new table with properties {name:tName}
try
newTable as text
on error errMsg number errNum
set sheetName to item 4 of my decoupe(errMsg, quote)
end try
end tell -- sheet 1
tell sheet sheetName
tell table tName (*
assuming that r,c points cell H12, inserts the localized formula
=ISBLANK(H12) *)
set value of cell 1 of row 1 to "=" & ISBLANK_loc & "(" & s &
" :: " & t & " :: " & my refEnLettres(r, c) & ")"
(* grabs the returned value *)
set flag to value of cell 1 of row 1
end tell -- tName
delete table tName (* removes the temporary table *)
end tell -- sheet sheetName
end if
end tell -- document 1 of application
return flag
end doYourDuty
--=====
No need to create the auxiliary table if the grabbed cell value is
not 0.0.
Yvan KOENIG (from FRANCE mercredi 4 février 2009 11:02:12) _______________________________________________
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