Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index

At 20:40 19/09/2018 +1200, Steve Edmonds wrote:
Is it possible to protect the format of calc cells, but still allow information to be entered. I.e. allow people to enter from the keyboard but not change the number format, background colour, conditional format or overwrite any formatting by pasting into a cell.

Probably not, but there may be a workaround. You could set up two areas: your real, appropriately formatted and locked area, and another, unprotected area for users to enter values. The real area would contain formulae that simply copy the entered values from the other area. The unprotected area for data entry could be elsewhere on the same sheet or on another sheet if preferred. You could use print ranges to make your real area print but not the entry area.

I trust this helps.

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.