All About Symbian - Nokia (S60) and Sony Ericsson (UIQ) smartphones unwrapped

  #1  
Old 05-12-2001, 06:24 PM
Kevin Kevin is offline
Registered User
 
Join Date: Dec 2001
Posts: 1
Kevin is on a distinguished road
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>

  #2  
Old 05-12-2001, 08:01 PM
Manowar Manowar is offline
Registered User
 
Join Date: Oct 2001
Posts: 365
Manowar is on a distinguished road
Hi,

I have the same firmware and app version.
What you say works fine on my comm.
For example, insert these values
A1=1;B1=2;C1=3

A2=A1+B1+C1=6

Then I use the simple copy and the simple paste (Ctrl-C and Ctrl-V). Copy A2 and Paste it in B2.

YouŽll see that B2=B1+C1+D1=5

But if you write

A2=$A1+$B1+$C1=6

when you paste it in B2 youŽll see

B2=$A1+$B1+$C1=6

Anyway IŽm not sure about you are talking, my English is not very good! [img]/phpBB/images/smiles/icon_smile.gif[/img]
I hope this can help.

Regards
__________________
www.clansymbian.com
Ads
 

Bookmarks

Tags
paste, sheet, special

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Cut & Paste alf Sony Ericsson P800, P900 and P910 3 14-02-2004 05:53 AM
I Agree that it is stupid not have spread sheet editor gkassem Sony Ericsson P800, P900 and P910 0 30-08-2003 06:20 PM
Word and Sheet application question mrs Nokia 9210 and 9290 4 11-12-2002 07:50 AM
Sheet Print Preview Nokia 9210 and 9290 4 17-10-2002 10:20 AM
Adding Hours in Sheet Nokia 9210 and 9290 0 05-12-2001 02:21 PM



All times are GMT. The time now is 11:15 AM.


vBulletin skins developed by: eXtremepixels
Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright Notes || Contact Us || Privacy Policy