Den 2011-02-18 21:56:45 skrev . <pe...@aleksandrsolzhenitsyn.net>:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 My spreadsheet has a tiny monthly calendar on it that has 1 cell for each day. So, it has 7 columns across and 8 rows down. When you select the cells it has a range like this- A1:G8 I want to put the contents of cells A1 to G8 into 1 cell on different sheet in the same file. It can be done by; - - Selecting and Copying A1:G8 - - Pasting it into Writer (at this point it appears like a graphic that you can rescale) - - Copying it from Writer and pasting it into the single cell using Paste Special-----> GDI metafile That works well but there's got to be an easier way. Any ideas?
I am just curios; why would you want to do something like that? I would guess (and yes, it's only a guess, nothing more) that nobody ever wanted to do that before, so there is no special feature for it. Again, only a guess…
One possible solution would be to write a macro for it. -- Kind regards Johnny Rosenberg --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org