From: "Edgar y Anna HERNANDEZ" <[EMAIL PROTECTED]>
Reply-To: [email protected]
To: [email protected]
Subject: RE: [users] Calc, pasting into several disjoint cells at once?
Date: Tue, 26 Dec 2006 07:15:11 -0700
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]
i think that option number 3 is the best.
_________________________________________________________________
From photos to predictions, The MSN Entertainment Guide to Golden Globes has
it all. http://tv.msn.com/tv/globes2007/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
