Yoav is the CEO of Cogniview, a company that creates PDF to XLS conversion software. SummaryĪs you can see, OpenOffice has made it pretty easy to protect your work from all but the most determined spreadsheet vandal or clumsy co-worker! About the author You can now enter a password for messing with the document’s sheets. To do this, open the ‘Tools’ menu and select ‘Protect Document’ and then select ‘Document…’. You can go even further and prevent those pesky users from rearranging or renaming the sheets.
If on the other hand, you want the cell’s contents to appear, but you want to hide the formula that generates it, then you can tick the option ‘Hide Formula’ and then the result will appear in the cell (protected from editing, of course), but the formula bar will appear empty instead. If you do that, then once you protect the sheet, the cells will appear empty and will not be editable. If you don’t want some contents to even show at all, you can tick the ‘Hide All’ box in the ‘Format Cells’ dialog for those cells. If you do choose and enter a password, then only those users who know the password can un-protect the sheet and wreck your nice formulas. If you leave this blank and press OK, the sheet is protected from any casual user trying to alter the content, but it is not secure as anyone could remove this protection the sheet using the same procedure.
0 kommentar(er)
