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.
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 :
> 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
> 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.