It would be useful to have the option to lock the formatting on sheets. Currently filling fills both the cell contents and formatting. Similarly dragging and dropping cells also affects both contents and formatting. While this behaviour is sometimes desirable, at other times - particularly on sheets with significant formatting - it would be useful to have the option to lock formatting, while still being able to edit cell contents.
thanks lanurdave, God idea > New
(In reply to Cor Nouws from comment #1) > God idea > New Good, obviously ;)
*** Bug 116245 has been marked as a duplicate of this bug. ***
(In reply to Thierry Munoz from Bug 116245 comment #0) > It would be interesting (in educational purpose for instance) to lock the > format in a cell (currency, date, background color, ...) but not the content. (In reply to Thierry Munoz from Bug 116245 comment #1) > In the french forum > (https://forum.openoffice.org/fr/forum/viewtopic.php?f=4&t=57220 ), I've > obtained more informations. > This fonctionnality depends of the ODF standard specifications that can't > record informations about spreadsheet table protection options. > See here : > https://wiki.oasis-open.org/office/Spreadsheet_Table_Protection_Options > For information, it seems that Excel does it... I copied Thierry's to this bug. Regina: Is this request in scope of the ODF spec improvement?
I often need this, because I tend to make lists and then sort items into already formatted columns. Newly moved items overwrite the cell's format in the column and then i have to reapply copy format downwards. I suggest this to be implemented as a modifier of moving. It is as when one presses: Ctrl+(mouse_move) to copy a cell In a similar case, this could be done by Shift+(mouse_move) to move cell without format
(In reply to C from comment #5) ... > I suggest this to be implemented as a modifier of moving. It is as when one > presses: > Ctrl+(mouse_move) to copy a cell > > In a similar case, this could be done by > Shift+(mouse_move) to move cell without format This means narrowing down the initial proposal. Locking formatting is a general device which applies to copying, moving _and_ data entry via typing (which is, as far as I see, not concerned) or the clipboard, where the format is for example supplied and used when the clipboard content was copied from Writer. Oc course you can avoid this by inserting text only, but the idea of the proposal is to block a format change by a cell property and not by an explicit effort of the user.
*** Bug 132133 has been marked as a duplicate of this bug. ***
It would be very helpful if you could lock conditional formatting as well. My issue is the following: I work in a field where operation/mission information is stored in an table file (it's actually an Excel file, but 1) the same is true for LibreOffice; 2) we switched to LibreOffice in August so in the upcoming future this is where it's at). The (Excel) file has a good amount of conditional formatting to ensure people put in the correct values. Because the file is stored in a shared 'HLC Notes' room and because that system is buggy AF people save the file locally, enter the values there and then just copy the information to the shared file. And here starts the problem: People don't only copy the values, but also the conditional formatting which turns into several versions of the format with just different fields where they apply. (I know they *could* copy only the values, but the group includes people who don't know or just don't care) My suggestion and what would really help is if you could just lock conditional formatting while every cell can be manipulated freely. (Not sure if this is a good fit here or if it should go into their own report)