https://bugs.documentfoundation.org/show_bug.cgi?id=167485
Bug ID: 167485
Summary: Configuration for Paste of formatting in Cell Edit
Mode to match the leading commercial spreadsheet
program
Product: LibreOffice
Version: 24.2.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
This is a suggestion for an option to match Excel behavior when Paste (Ctrl+V)
of text that contains formatting is performed into a cell while in Cell Edit
Mode.
A potential regression in Calc default behavior was resolved as NOTABUG in bug
162621. This suggestion differs from what was claimed as a regression in bug
162621 because it is not limited to the case where the source is HTML. Bug
162621 also does not propose making the behavior configurable.
There is also a WONTFIX bug 164504. A major difference is this suggestion is
about Cell Edit mode whereas bug 164504 does not seem to mention Cell Edit mode
at all. Also, bug 164504 does not mention any appeal to Microsoft Excel
behavior, but this suggestion does.
Steps to Reproduce:
1. Copy text from a web page.
2. Double click on a cell in Calc to enter Cell Edit mode.
3. Press Ctrl+V.
Actual Results:
Value with formatting such as font and color is pasted.
Expected Results:
Excel behavior: When performing Paste (Ctrl+V) in Cell Edit mode, as far as I
can tell, formatting is never copied. It does not matter if the source was
Excel itself, Word, HTML, etc.
This appears to be a specific feature of Cell Edit mode, as outside of Cell
Edit mode, the formatting would be pasted, such as to paste an HTML table of
data.
Reproducible: Always
User Profile Reset: No
Additional Info:
There are data entry applications that primarily involve a lot of pasting from
web pages (and other formatted sources). A great solution would be some new
kind of protected sheet and/or protected cell where only the value and not the
formatting can be pasted. I have not at this time conducted a proper search for
bug numbers that may be related to that kind of suggestion. That would be an
innovation that Excel does not have. Anything that makes this easier and less
error-prone (i.e., regarding accidentally replacing formatting), such as an
option to match Excel in this regard, may be appreciated by such users whose do
a lot of this copy and paste work into Calc.
Version: 25.2.4.3 (X86_64) / LibreOffice Community
Build ID: 33e196637044ead23f5c3226cde09b47731f7e27
CPU threads: 12; OS: Windows 10 X86_64 (10.0 build 19045); UI render:
Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
