Google docs can “lock” a page so that it’s impossible to copy from its text. This seems wrong to me; shouldn't a computer’s ability to copy and paste be intrinsic? I can’t understand how a webpage can “overstep” its authority and prevent my computer from doing something totally natural. It seems that if I can be served and display text that I should be able to copy it.
How does this webpage prevent my machine from copying?
No. You will NOT be able to download the sheet BUT you can copy paste the entire content from the sheet to a new sheet.
Select one or more files you want to limit. Click Share or Share. In the bottom right, click Advanced. Check the box next to "Disable options to download, print, and copy for commenters and viewers."
Here is how to copy (or print) the protected google sheet values.
NOTE: With this technique you can copy the cells from each sheet; it's not possible to duplicate the spreadsheet file itself. Formatting is preserved but formulas are not.
Change the URL to:
https://docs.google.com/spreadsheets/u/1/d/***[document id]***/preview
The document ID is the random string found in the google sheet URL that is normally 40 to 45 characters long.
For each sheet, type Ctrl+A, Ctrl+C
Paste the cells into another spreadsheet. Formatting
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With