Re: Numbers Daylight Savings Bug Still Active?
Re: Numbers Daylight Savings Bug Still Active?
- Subject: Re: Numbers Daylight Savings Bug Still Active?
- From: Deivy Petrescu <email@hidden>
- Date: Tue, 07 Feb 2017 09:30:38 -0500
> 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
email@hidden
_______________________________________________
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