On Feb 6, 2017, at 22:40 , Christopher Stone <email@hidden> wrote:
Hey Folks,
Starting with this data in a date-formatted cell:
10/28/16 22:03
And running this script:
------------------------------------------------------------------------------
tell application "Numbers"
if document 1 exists then
tell document 1
tell active sheet
set activeTable to (the first table whose class of selection range is range)
tell activeTable
set cellRef to first cell of selection range
tell cellRef
set cellValue to value
set cellFormattedValue to formatted value
end tell
end tell
end tell
end tell
end if
end tell
{cellValue, cellFormattedValue}
------------------------------------------------------------------------------
--> {date "Friday, October 28, 2016 at 23:03:00", "10/28/16 22:03"}
------------------------------------------------------------------------------
Value vs Formatted Value.
Is this the bug Yvan reported a year or so ago?
Or is there a rational reason for this?
TIA.
--
Best Regards,
Chris
No, it is not a bug.
It is expected.
Value is the value of the cell, the date "Friday, October 28, 2016 at 23:03:00”
Formatted value is the value you want the cell to display, in our case "10/28/16 22:03”.
The setting for formatted value is in your rhs, when you select cell.
You can change the formatted value, but not the value.
By the way, Excel, is certainly more powerful than Numbers, but there are certain features of Numbers that makes it more convenient than Excel if your needs do not require all the power of Excel.
First the tables can be finite, versus the infinite cells in Excel (;-])
And you can have more than one table (independents) in the same sheet.
Scripting, they are very similar, however, nothing can compare to scripting Excel,the dictionary itself requires a dictionary…
Deivy Petrescu