• 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 Daylight Savings Bug Still Active?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Numbers Daylight Savings Bug Still Active?


  • Subject: Re: Numbers Daylight Savings Bug Still Active?
  • From: Yvan KOENIG <email@hidden>
  • Date: Tue, 07 Feb 2017 10:35:15 +0100


Le 7 févr. 2017 à 04:40, Christopher Stone <email@hidden> a écrit :

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


Curious.

Here I get the same time value in both cases but it's not surprising, we are in winter time here.

I'm not sure that it's related to what I reported in 2015 because I never used "formatted value" before receiving your message.

Yvan KOENIG running Sierra 10.12.3 in French (VALLAURIS, France) mardi 7 février 2017 10:35:10




 _______________________________________________
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

References: 
 >Numbers Daylight Savings Bug Still Active? (From: Christopher Stone <email@hidden>)

  • Prev by Date: Re: The List is Finally Back Up!
  • Next by Date: Re: Scripting Additions – Broken Bundles?
  • Previous by thread: Numbers Daylight Savings Bug Still Active?
  • Next by thread: Re: Numbers Daylight Savings Bug Still Active?
  • Index(es):
    • Date
    • Thread