Re: [libreoffice-users] LO calc, how to copy partial sheet onto a new sheet

At 13:38 02/03/2018 -0800, Girvin Herr wrote:
> On 03/02/2018 01:26 PM, Brian Barker wrote:
> > o Copy and paste using Paste Special, as you suggest, but tick 
> > the > Link option in the Paste Special dialogue. [...]
> > o Make a complete copy of the original sheet: right-click the 
> > sheet > tab and select Move/Copy Sheet... .
>
> Optionally for bullet #2, I find it easy to click on the upper left 
> block where the row and column IDs converge (left of "A" and above 
> "1"). This selects the entire sheet. I then use Ctrl+c to copy 
> everything, then go to the blank sheet, click on the upper left 
> block on that sheet to select it and use Ctrl-v to insert the data 
> and formatting.

But that can produce different results for cross-sheet references 
from case 2. That's why I suggested that case 2 might be what is required.

Brian Barker  


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted