On Monday 04 February 2008 16:18:44 John R. Sowden wrote: > Dan wrote: > > On Monday 04 February 2008 14:59:39 John R. Sowden wrote: > >> I am attempting to copy text from a spreadsheet to a text file that I > >> can access to edit via kwrite, etc. > >> > >> Having a problem, thoughts? > > > > It would be nice to know what your problems are. If we do not know > > what you have done, how do we know what to tell you? You might have > > already tried what we would suggest. > > Having said all that try this. Highlight the cells you want to copy. > > The use Control+Space+V to Paste Special them into Kwrite. Select > > unformated text as you option. > > > > Dan > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > Thanks for the reply. > > Well, ... I tried "paste special as you and another person advised. > It seemed unusual that I would paste prior to copying, but, when you > don't know, you follow instructions. I then got a message saying that I > am trying to paste on top of existing data (my ss), so I selected and > copied, then went to write, created a new doc, but the paste special > option was not on the right click menu. I also tried kwrite, same no > 'paste special'. > > Obviously, I am missing something.
Or perhaps we did explain ourselves very well. I seemed to have left off one step. 1) Highlight the cells in the spreadsheet. 2) Use Control+C to copy the text. (This places the information in the clipboard.) 3) Open a new document in Write. 4) Use the Paste command (Control+V) in Kwrite to past the information into it. These four steps worked when I just copied cells from one of my speadsheets into Gedit which is similar to Kwrite. You probably will have to move the data around some. Or, you could save the speadsheet as a text(.csv) file. File > Save As Change the File type from OpenDocument spreadsheet (.ods) to Text (.csv). It is a dropdown list. Kwrite should be able to open this file. Dan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
