Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index

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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.