[Solved] Protecting my spreadsheet

Discuss the spreadsheet application

[Solved] Protecting my spreadsheet

Postby grahamxy » Fri Nov 10, 2017 12:14 pm

I have done everything (about 10 times!!) to protect a spreadsheet I have created, when I test it works fine and as it should. I save it to a memory stick and then download it from the stick back on to my desktop only to find everything is open and can be altered therefore ruining the whole thing.
Does anyone have any clues hows to help?
Last edited by grahamxy on Sun Nov 12, 2017 1:57 am, edited 2 times in total.
OS X Yosemite Version 10.10.1 OpenOffice Version 4.1.1
grahamxy
 
Posts: 38
Joined: Sat Dec 20, 2014 6:03 am

Re: Protecting my spreadsheet

Postby jrkrideau » Fri Nov 10, 2017 1:08 pm

How are you protecting the spreadsheet?

Are you saving in .ods and re-opening the file with Calc?
LibreOffice 5.1.4.2 Ubuntu 17.04 "Zesty Zapus"
jrkrideau
Volunteer
 
Posts: 3359
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Protecting my spreadsheet

Postby grahamxy » Fri Nov 10, 2017 1:09 pm

Yes
OS X Yosemite Version 10.10.1 OpenOffice Version 4.1.1
grahamxy
 
Posts: 38
Joined: Sat Dec 20, 2014 6:03 am

Re: Protecting my spreadsheet

Postby grahamxy » Fri Nov 10, 2017 1:33 pm

Save as per instructions, only select the cells I want to save, it works fine until I reopen it and find nothing has been saved.
OS X Yosemite Version 10.10.1 OpenOffice Version 4.1.1
grahamxy
 
Posts: 38
Joined: Sat Dec 20, 2014 6:03 am

Re: Protecting my spreadsheet

Postby Villeroy » Fri Nov 10, 2017 2:21 pm

We don't have the faintest idea what you are doing. There is no feature which allows you to save selected cells only.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24584
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Protecting my spreadsheet

Postby grahamxy » Fri Nov 10, 2017 3:42 pm

I am sorry but it is you who is misinformed. Format-Cells-Cell Protection- Deselect all cells and press OK. Then reopen the same way and then select the cells you want to protect. Go to Tools -protect document and select protect and you're done. Not forgetting to check the box that says allow users to access unprotected cells.
OS X Yosemite Version 10.10.1 OpenOffice Version 4.1.1
grahamxy
 
Posts: 38
Joined: Sat Dec 20, 2014 6:03 am

Re: Protecting my spreadsheet

Postby grahamxy » Sat Nov 11, 2017 2:17 am

Thank you for your reply Villeroy, I am a newcomer at this and am trying to learn as much as I can as I go, it seems I phrased the question wrong. What I want to do is HIDE the formulae not save as this is being done perfectly. Any help on this would be sincerely appreciated.
OS X Yosemite Version 10.10.1 OpenOffice Version 4.1.1
grahamxy
 
Posts: 38
Joined: Sat Dec 20, 2014 6:03 am

Re: Protecting my spreadsheet

Postby Villeroy » Sun Nov 12, 2017 1:26 am

=FORMULA(SheetX.A1) displays the formula of SheetX.A1 no matter what. A most simple macro can read and copy any content from any hidden or protected sheet.

The child protection which hides formulas is availlable on the cell protection tab of the cell formatting dialog and when I protect the sheet this option becomes active and it sticks when I save and reload. I can not reproduce your problem.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24584
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Protecting my spreadsheet

Postby grahamxy » Sun Nov 12, 2017 1:55 am

Ok thanks for your help, I now realise it is child protection only. What I wanted to do was stop other people copying my work and/or destroying the formulas and nullifying the whole sheet. It seems no matter what I do the formula is still shown when the cell is selected, I will persevere and sort it out,
OS X Yosemite Version 10.10.1 OpenOffice Version 4.1.1
grahamxy
 
Posts: 38
Joined: Sat Dec 20, 2014 6:03 am


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 29 guests