I use Sheet on the 9210 a fair bit, and did so on Psion 3a and 5. I also use Excel a fair bit under Windows. I need to use what they all term Paste Special, where you can copy a cell that contains a formula and just paste the value generated into another cell, e.g. original cell is "=a1+a2" with a computed value of 100 but using Paste Special to paste just the value inserts 100 rather than the above formula.
I can get around it (sort of) by copying the cell, pasting it in to the Calculator, going back up to the history window (not the result window), copying from there and pasting back into Sheet but then it pastes in a 2x2 grid with the value in the bottom right cell. Not very convenient and only works in scientific mode.
I can't seem to find Paste Special anywhere on Sheet (firmware 3.54, Sheet v2.00). Is it hidden somewhere odd, or with a hidden key combination? Or is it another useful Psion 5 feature that Nokia/Symbian have left off the 9210 for seemingly unknown reasons?
<font size=-1>[ This Message was edited by kevin on 2001-12-05 1927 ]</font>
