From: "Kirill S. Palagin" <[EMAIL PROTECTED]>
Reply-To: [email protected]
To: <[email protected]>
Subject: [users] Calc, pasting into several disjoint cells at once?
Date: Tue, 26 Dec 2006 15:09:48 +0300
Hello everybody.
Is there a way to paste something into several selected cells (disjoint
selection)?
Thanks a lot.
WBR,
K. Palagin.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
hello Kirill,
I've been working with openoffice just recently and I tried to do the same
but it looks that is not possibly to do this. Every time you try to copy one
cell must be in to another cell if you copy an array of cells you must copy
this into an array that must be exactly the same size, but, if you try to
copy one cell into 2 o more cells (doesn't matter if they are adjacent or
nonadjacent) the application understands that you want to copy an array of
one cell into an array of one or more cells and then logically, this doesn't
make sense in consequence impossible.
Solution, what i do is, type the data for instance lunch, press enter go to
another cell press L and the aplication complete the data with lunch (using
autocomplete). 2 try selection list . when you want to copy same data into
another cell rightclick and from the menu click Selection List and will
apear a list with several data you can coose. 3 using Ctrl+enter. select the
cells where you want to copy. for instance, highlight cell D1 and select or
highlight the desired range of cells. and the last selected cell type lunch
and press enter. the next selected cell becomes active then type L and watch
what happens press enter and the next selected cell becomes available.
i hope this will help you.
Edgar.
_________________________________________________________________
Fixing up the home? Live Search can help
http://imagine-windowslive.com/search/kits/default.aspx?kit=improve&locale=en-US&source=hmemailtaglinenov06&FORM=WLMTAG
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
