Re: odd Numbers's behaviour
Re: odd Numbers's behaviour
- Subject: Re: odd Numbers's behaviour
- From: Deivy Petrescu <email@hidden>
- Date: Thu, 18 Dec 2014 11:17:18 -0500
> On Dec 18, 2014, at 10:14 , Yvan KOENIG <email@hidden> wrote:
>
>
> Oops, I must apologize, I posted this message to Christopher's mailbox.
>
> Yvan KOENIG (VALLAURIS, France) jeudi 18 décembre 2014 16:14:02
>
>
>> Le 18/12/2014 à 10:37, Christopher Stone <email@hidden> a écrit :
>>
>> On Dec 18, 2014, at 03:15, Yvan KOENIG <email@hidden> wrote:
>>> Here, with the System and the app running in French, the cell is not filled with the string but with the duration 12h 3m 25s.
>> ______________________________________________________________________
>>
>> Hey Yvan,
>>
>> Still on 10.9.5 with Numbers 3.2.2.
>>
>> I get the same thing.
>>
>> I was able to work around it by:
>>
>> tell application "Numbers"
>> tell document 1 to tell active sheet to tell table 1
>> set value of cell "B2" to ("'TEMP!'")
>> set value of cell "B2" to ("12Chicago3:25")
>> end tell
>> end tell
>>
>> --
>> Take Care,
>> Chris
>
>
> Thanks to you and Thomas Fischer
>
> I knew that we may get the correct value if the cell format is set to text, as you did or using the set format instruction.
> It's just annoying because to use that, we must know what we are trying to insert.
> I asked with a script pasting a value but I discovered the problem when I opened a TAB separated values text file and in this case, the tip doesn't apply.
> Now that I know that the problem is not restricted to the French version, I will file a bug report.
> Just after posting my question I discovered that Numbers behave the same when I entered such entry by hand.
>
> Yvan KOENIG (VALLAURIS, France) jeudi 18 décembre 2014 12:08:03
Interestingly if you use “TEMP”, before inserting “12Chicago3:25” it gets it right on that particular cell.
However, if you copy and paste the same value to other cell, it becomes time.
By the way, the same script in JSA:
numbers=Application("Numbers")
cell=numbers.documents[0].activeSheet().tables[0].cells.byName("B4")
cell.value= "12Chicago:3:24”
And, I found out that cells are counted linearly, that is it is an array instead of a double array, so cells[24] depends on the size of the table.
I’d have preferred a cell as a double array so cells[1][3] would be cell “B4”
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