[Solved] Protect Cell Formatting

Discuss the spreadsheet application

[Solved] Protect Cell Formatting

Postby JamesSmith32 » Sun Feb 02, 2020 4:50 am

Is it possible to protect a cell in such a way that the formatting, for example background colour and border are protected. But the data, in my case simply a number is not protected, allowing it to be modified. I think this probably isnt possible but thought I would ask anyway just to be sure.
Last edited by Hagar Delest on Sun Feb 02, 2020 3:23 pm, edited 1 time in total.
Reason: tagged solved
Open Office 4.1.7 Windows 10
JamesSmith32
 
Posts: 10
Joined: Wed Jan 22, 2020 12:55 pm

Re: Protect Cell Formatting

Postby Zizi64 » Sun Feb 02, 2020 9:49 am

When a cell is "protected",(and the Sheet-protection is switched on) then you can not modify either the formatting properties nor the cell content in the protected cells by using the User Interface (using the keys and the mouse...).

Use the "Paste special - Unformatted text" to paste the content, and use the Cell Styles instead of the manual formatting method. then the format properties will not be overwrite by the format properties of the pasted data.

If you use Styles for the formatting of the cells, then you will able to restore all of the (accidentally modified) properties by a double click on the name of the Style).
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9531
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Protect Cell Formatting

Postby JamesSmith32 » Sun Feb 02, 2020 11:11 am

Good answer, thanks, this helps heaps.
Open Office 4.1.7 Windows 10
JamesSmith32
 
Posts: 10
Joined: Wed Jan 22, 2020 12:55 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 10 guests