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]

Reply via email to