At 03:55 06/04/2015 -0400, Linda Hull wrote:
I'm trying to compare data between different access lists. I have managed to create pretty nice spreadsheets with the CSV, but now Calc says that "There is not enough space on the sheet to insert here", when I try to paste a second list.
I think this happens only when you are trying to paste something inappropriate. You may be trying to paste a complete column or columns, a complete row or rows, or even a complete sheet into a single cell (or using a single cell as a marker) - or you may be trying to paste a column into a row or (without using Transpose) a row into a column. Remember that copying a row or a column doesn't copy just the cells of that element into which you have inserted data but instead the entire element to the right edge or bottom of the sheet.
What can I do?
If you select just appropriate rows, columns, or ranges that contain your data to be copied, everything should work. If necessary, import your new data into a separate sheet and then select the significant range to copy to your required destination.
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
