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

Numbers Daylight Savings Bug Still Active?


  • Subject: Numbers Daylight Savings Bug Still Active?
  • From: Christopher Stone <email@hidden>
  • Date: Mon, 06 Feb 2017 21:40:57 -0600

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

 _______________________________________________
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

  • Follow-Ups:
    • Re: Numbers Daylight Savings Bug Still Active?
      • From: Deivy Petrescu <email@hidden>
    • Re: Numbers Daylight Savings Bug Still Active?
      • From: Shane Stanley <email@hidden>
    • Re: Numbers Daylight Savings Bug Still Active?
      • From: Yvan KOENIG <email@hidden>
  • Prev by Date: Re: The List is Finally Back Up!
  • Next by Date: Re: The List is Finally Back Up!
  • Previous by thread: List Archives Dead in the Water
  • Next by thread: Re: Numbers Daylight Savings Bug Still Active?
  • Index(es):
    • Date
    • Thread