[Bug 158724] Option to suppress overwriting of cell formatting on paste

[bugzilla-daemon at bugs.documentfoundation.org]

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

Heiko Tietze <heiko.tietze at documentfoundation.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
                 OS|Windows (All)               |All
            Summary|Conditional Formatting gets |Option to suppress
                   |overwritten                 |overwriting of cell
                   |                            |formatting on paste
           Hardware|x86-64 (AMD64)              |All
           Keywords|needsUXEval                 |
             Blocks|                            |108019, 108479, 87351
             Status|UNCONFIRMED                 |NEW
                 CC|libreoffice-ux-advise at lists |heiko.tietze at documentfounda
                   |.freedesktop.org            |tion.org

--- Comment #18 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
We discussed the topic in the design meeting.

Additional to the idea of 

a) a special command to block (any) formatting in the spreadsheet (likely per
table) or 
b) an addition to the protection mechanism to provide, we had the idea 
c) to remember the paste special settings (probably per document in this case).

This could be done in the paste special dialog with a checkbox "[ ] Remember
for paste" and the tooltip "Check this option to keep these settings for
ordinary paste". The exact wording and implementation is open for discussion
since the option "Run immediately" kind of blocks the "Remember" function.
Of course, it would be possible to revert this by checking "All" and then
"Remember" again (we should consider a preset for All).

Option b) and c) sound quite flexible and by that appropriate to LibreOffice.
But a) could be a solution for the issue too.

I'm going to change the summary for all formatting since a cell might be
directly formatted as result (for example large size and bold) but users cannot
spot this formatting and overwrite it on paste.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=87351
[Bug 87351] [META] Conditional formatting bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108019
[Bug 108019] [META] Calc UX bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108479
[Bug 108479] [META] Paste special bugs and enhancements
-- 
You are receiving this mail because:
You are on the CC list for the bug.