I’m a newbie with LibreOffice. My client asked me for a very secure solution.
He wants his final solution appeared in such a way that the user can only be able to perform the following six operations
- Copy: Copy Data from Sheets using CTRL+C or Right Click option if available.
- Paste: Paste copied data from sheets to other sheets or external files using CTRL+V or Right Click Option
- Add and Minus: Summation and Subtraction of Cell A1 and Cell B1 i.e. =A1+B1 or A1-B1 but he couldn’t be allowed to perform other operations like dividing using “/” or multiplication using “*” etc. etc. Only allowed is Adding and Subtraction.
- Print and Save: Print the Sheet and Save As the file as another file with the same security settings.
Frankly speaking, I’m very good at the Excel-VBA framework. I can easily manage to build a kind of secured interface in Microsoft Excel but as the client is using LibreOffice, I’m bound to perform.
I really do not know where to start? is it possible without using coding in LibreOffice? If yes then please guide. I don’t have even 2 hrs of experience in LibreOffice Calc.
Many Thanks in Advance.