That seems easy enough, and your explanation makes more sense of why
this happened now.
Actually I was trying to copy from the source range to a new target
range starting at the current cell, as opposed to putting all the cells
into a single cell. I was under the distinct impression there is a way
to do this. Or is there a rule of sorts that a given cell in a
spreadsheet cannot cause any changes to other cells (as in, the cell
cannot actively do something to change another cell... the only way is
if the other cell refers to this cell somehow).
Please clarify and thanks.
Joe Conner wrote:
You are trying to put a range of cells in a single cell. I would give
the same error if someone tried to stuff me with that much.
Instead, use something like " =Prices.A5 " without quotes in a single
cell, for example cell A5.
Next copy cell A5 "CTRL V" and then paste cell A5 through cell
G10. Ignore if Calc complains
about copying the formula into an already occupied cell.
Arjun wrote:
Hi people,
I have an OpenOffice Calc document with 20+ sheets on it. Anyways, I
am trying to add a 21st sheet that simply contains a subset of cells
(ie: a "range") of cells from one of theother 20 sheets. So if the
sheet I want to copy cells from is called "Prices" and the sheet I
want to copy it into is the current sheet, I am doing something like
the following in the current sheet:
=Prices.A5:G10
That seems to give an error. Now, I tried this exact same thing in
Microsoft Excel and it also gave an error. I tried to do this in
isolation on a brand new Calc spreashsheet that has nothing in it and
did something like =N10:P16 in cell A1 and got the same problem.
Please advise.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
