Ask Your Question

How to protect from copying

asked 2017-05-07 23:08:01 +0200

ZioRiP gravatar image

Hello, I would like to add a protection to a spreadsheet that I have created as I intend to sell it. Problem is that if I simply password protect it people can simply share the password, and I was wondering if there is a way to put some more robust protection.

Thanks in advance :)

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-05-08 06:13:18 +0200

There is no such feature in LibreOffice.

edit flag offensive delete link more

answered 2017-05-08 11:42:37 +0200

peterwt gravatar image

Protecting a file is much more difficult compared to protecting a program executable file. You can set a password for a spreadsheet but if you are selling it then the purchaser will have the password and can give or sell your spreadsheet to someone else.

Excel has a feature to protect VBA code from being viewed. If the ideas you want to protect are done through VBA then the way you carry out the operations can be hidden but the spreadsheet can be used by anyone who has the file. There are third party programs that give a high level of protection to Excel spreadsheets. One, XLS Padlock, ( compiles the Excel spreadsheet into an executable file. This is a commercial program and has to be bought. When run it requires authorisation to run and then opens the spreadsheet in Excel, which must be installed on the computer. I am not aware of any program that can be used to secure a LO Calc file.

edit flag offensive delete link more


Concerning "protected" VBA code there were complaints in forums that LibreOffice "did not regard the protection". A protection that simply can be disregarded surely is a kind of hiding and avoiding inadvertent changes like sheet "protection" which easily can be removed without knowing a password. Please tell me if it's different.

Lupp gravatar imageLupp ( 2017-05-08 12:15:42 +0200 )edit

Thanks, in fact I was looking for some sort of online verification on launch, which I understand it is not possible.

ZioRiP gravatar imageZioRiP ( 2017-05-09 09:20:49 +0200 )edit

@Lupp Yes you are right. I have tested it and LO does display the protected code.

peterwt gravatar imagepeterwt ( 2017-05-10 13:03:07 +0200 )edit
Login/Signup to Answer

Question Tools


Asked: 2017-05-07 23:08:01 +0200

Seen: 70 times

Last updated: May 08 '17