Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Problem copying between spreadsheets

Running LibreOffice 4.3.2 on Windows 7 Professional 64 bit. Core i7, 8GB RAM, 672 SSD.

Here is the scenario. My first spreadsheet contains 9 sheets. My second spreadsheet is new (blank). I need to consolidate the 9 worksheets from the first spreadsheet to one sheet on the second spreadsheet. I highlight the area I need on the first sheet on spreadsheet #1. I copy the area then paste it to the sheet on spreadsheet #2. Success!

Now I go to the second sheet in spreadsheet #1, highlight the area and copy it. I go to a blank cell in spreadsheet #2 and paste. It seems that the clipboard retains the contents from the first copy operation, because that is what is pasted. All other attempts to copy from spreadsheet #1 to a blank area on spreadsheet #2 have the same result - the first copy operation is the one that is pasted.

However if I limit my copy/paste operations to the same spreadsheet (copying from every sheet onto a blank worksheet all within spreadsheet #1), then all the copy/paste operations work as expected.

What is going on?

Jon

Problem copying between spreadsheets

Running LibreOffice 4.3.2 on Windows 7 Professional 64 bit. Core i7, 8GB RAM, 672 SSD.

Here is the scenario. My first spreadsheet contains 9 sheets. My second spreadsheet is new (blank). I need to consolidate the 9 worksheets from the first spreadsheet to one sheet on the second spreadsheet. I highlight the area I need on the first sheet on spreadsheet #1. I copy the area then paste it to the sheet on spreadsheet #2. Success!

Now I go to the second sheet in spreadsheet #1, highlight the area and copy it. I go to a blank cell in spreadsheet #2 and paste. It seems that the clipboard retains the contents from the first copy operation, because that is what is pasted. All other attempts to copy from spreadsheet #1 to a blank area on spreadsheet #2 have the same result - the first copy operation is the one that is pasted.

However if I limit my copy/paste operations to the same spreadsheet (copying from every sheet onto a blank worksheet all within spreadsheet #1), then all the copy/paste operations work as expected.

What is going on?

Jon