Re: "pasting" only values in Sheet To Go

...... Original Message .......
On Fri, 13 Mar 2009 21:49:38 -0400 John Markley <[email protected]> wrote:



Thank you for your  answer.


>2)  I'm glad it works for you in version 6.002, because it is a  
>complete no-go in v9 and v10. 
> [...]

I was fearing something like that. That is why I specified my version.



Though the pScript is short and simple it takes into account a number of 
difficulties. Any of them might be the origin of the misbehaving in other 
divices or app versions.

The main issue is that Sheet To Go "copy-paste" function remembers (I don't 
know how) the kind of date your are dealing with. In this case simple 
numbers or formulas. 

For example, say that you have in A column the following data

Cell		Formula 		value

A1		No formula	1
A2		=A1+1		2
A3 		=A2+1		3




If you select and copy this three cells (A1, A2, A3) which values are 1, 2 
and 3, into three new cells (say B1, B2, and B3), you will get, obviously, 
the values 1, 2, 3 in them.

If you look at the content of those cells you will see:

Cell		Formula 		value

B1		no formula	1 
B2		=B1+1		2
B3		=B2+1		3


Surprisingly, if you go to C1 and you focus *not* in the cell *but* in the 
text field of that cell which you can see below, and paste the content of 
the clipboard, then what you actually paste in *that* cell (C1) is:
1
2
3
 
And more, if you leave Documents To Go and open, say, Memo and paste, you 
will obtain as well:
1
2
3

There are not hidden symbols whatsoever. 

And more, if you copy from Memo and paste back in Sheet To Go, you get 
again what I have already described above (that is: different things 
depending on what you are focusing: cell or text field)

It seemed to me that when you are focusing the cell you are not really 
using the palm clipboard but an internal feature of Documents To Go; and 
you are *really* using the palm clipboard (the data from the "Documents To 
Go clipboard" is transfered to it) when you are focusing a text field. (I 
don't know if all of this makes any sense but it is the asumption I had to 
do if I wanted the pScript to work).


That guess is somehow underlined when operating with pScripts that handle 
the clipboard. 
For example if you copy from a cell with
/&menu@ [1122]
or
/&menu@ [xxxx]

That information is *not* in the clipboard and so 
"/KC /K2cA"  doesn't work.
That is: there is nothing to take to text capturing (/KC) and therefore 
nothing to take into $A (/K2cA)

That is why in the pScript you can see the following process:

Copying from the cell
/&menu@ [xxxx]

Moving into that cell text field
/p13
NOTE THAT this step might be different for different app versions.
(You might other possibilities
/p10 or others). My guess is that the problem of the pScript behavior in 
newer versions is here.

As I have said, if you don't move into the text field of the cell,
/KC and /K2cA  have no meaning and might create problems (They didn't to 
me). The guess is that you are still operating with "Documents To Go 
clipboard" and the palm clipboard is empty or has old data.

Once in the text field 
-*it seems to me*-, the data in Documents To Go clipoboard  is transfered 
to the palm clipboard *but only* the values and not the formulas. 
Then, 
/KC and /K2cA copy that value of the cell (now in the palm clipoboard), in 
$A.

/p9 and /p28 take you out of the text field and back to the cell.

/&menu@ [1124]
(or /&menu@ [xxxx]) clears the cell


/&varPrint@ [$A]
prints $A in the cell and takes you to the the field text.

As you probably don't want to be in the text field,
/p10 takes you to the cell below.



I hope this explanation helps to understand the process and gives some 
light to the problem.



It works in my old T3. If you want to risk (which is not needed) and play 
with it let me now.


Jose


------------------------------------

Latest pedit/pToolSet/LapTopHack at http://www.osuweb.net/~pc/pca/pc_all.zip
pedit/pToolSet/LapTopHack scripting info/resources at http://www.peditors.com
Peditors Forum http://groups.yahoo.com/group/peditors
Unsubscribe by writing to peditors-unsubscribe-hHKSG33Tihh4sT85+ipIM4ckdKdSAMto@public.gmane.org! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/peditors/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/peditors/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[email protected] 
    mailto:[email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/