[Libreoffice-bugs] [Bug 88108] Feature request - Option to lock formatting on cells and/or entire sheet, while allowing editing

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=88108

--- Comment #8 from BDF  ---
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)

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 88108] Feature request - Option to lock formatting on cells and/or entire sheet, while allowing editing

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=88108

Timur  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=57
   ||091

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 88108] Feature request - Option to lock formatting on cells and/or entire sheet, while allowing editing

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=88108

Heiko Tietze  changed:

   What|Removed |Added

 CC||c...@chrblee.net

--- Comment #7 from Heiko Tietze  ---
*** Bug 132133 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 88108] Feature request - Option to lock formatting on cells and/or entire sheet, while allowing editing

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=88108

--- Comment #6 from Gerhard Weydt  ---
(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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 88108] Feature request - Option to lock formatting on cells and/ or entire sheet, while allowing editing

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=88108

--- Comment #5 from C  ---
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

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 88108] Feature request - Option to lock formatting on cells and/ or entire sheet, while allowing editing

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=88108

Thomas Lendo  changed:

   What|Removed |Added

   Keywords||filter:odf
URL||https://wiki.oasis-open.org
   ||/office/Spreadsheet_Table_P
   ||rotection_Options
 CC||rb.hensc...@t-online.de,
   ||thomas.le...@gmail.com
 Blocks||108237

--- Comment #4 from Thomas Lendo  ---
(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=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?


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108237
[Bug 108237] [META] ODF specification issues
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 88108] Feature request - Option to lock formatting on cells and/ or entire sheet, while allowing editing

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=88108

Thomas Lendo  changed:

   What|Removed |Added

 CC||thierry.mu...@free.fr

--- Comment #3 from Thomas Lendo  ---
*** Bug 116245 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 88108] Feature request - Option to lock formatting on cells and/or entire sheet, while allowing editing

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=88108

Cor Nouws c...@nouenoff.nl changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||c...@nouenoff.nl
Version|unspecified |Inherited From OOo
Summary|Feature request - Option to |Feature request - Option to
   |lock formatting on cells|lock formatting on cells
   |and/or entire sheet |and/or entire sheet, while
   ||allowing editing
 Ever confirmed|0   |1

--- Comment #1 from Cor Nouws c...@nouenoff.nl ---
thanks lanurdave,
God idea  New

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 88108] Feature request - Option to lock formatting on cells and/or entire sheet, while allowing editing

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=88108

--- Comment #2 from Cor Nouws c...@nouenoff.nl ---
(In reply to Cor Nouws from comment #1)

 God idea  New

Good, obviously ;)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs