Value of an empty cell in Numbers
Value of an empty cell in Numbers
- Subject: Value of an empty cell in Numbers
- From: Deivy Marck Petrescu <email@hidden>
- Date: Tue, 3 Feb 2009 21:23:50 -0500
| Since there are problems with handling dates in Numbers, we should mention problems with empty cells in numbers.
Say in your table you set the cell "B2" to 0 and leave the cell "C2" empty. Then you run the following script: ----
tell application "Numbers" tell document 1 to tell sheet 1 to tell table 1 set Range1 to value of cell "B2" set Range2 to value of cell "C2" return {class of Range1, class of Range2, Range1 = Range2, Range1, Range2} end tell end tell --->{real, real, true, 0.0, 0.0}
That is, an empty cell has value 0 as real , and it says that its value is the same as the cell whose values *is* 0.
---
|
_______________________________________________
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