Bug 88108 - Feature request - Option to lock formatting on cells and/or entire sheet, while allowing editing
Summary: Feature request - Option to lock formatting on cells and/or entire sheet, whi...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL: https://wiki.oasis-open.org/office/Sp...
Whiteboard: calc formatting
Keywords: filter:odf
: 116245 (view as bug list)
Depends on:
Blocks: Cell-Protection ODF-spec Sheet
  Show dependency treegraph
 
Reported: 2015-01-06 12:43 UTC by lemurdave
Modified: 2018-08-03 21:50 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description lemurdave 2015-01-06 12:43:48 UTC
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.
Comment 1 Cor Nouws 2015-01-06 14:05:09 UTC
thanks lanurdave,
God idea > New
Comment 2 Cor Nouws 2015-01-06 14:05:46 UTC
(In reply to Cor Nouws from comment #1)

> God idea > New

Good, obviously ;)
Comment 3 Thomas Lendo 2018-03-12 19:33:03 UTC
*** Bug 116245 has been marked as a duplicate of this bug. ***
Comment 4 Thomas Lendo 2018-03-12 19:39:24 UTC
(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?
Comment 5 C 2018-04-10 00:22:23 UTC
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
Comment 6 Gerhard Weydt 2018-08-03 21:50:31 UTC
(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.