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]
