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
(In reply to jasonkres from comment #0) > 1. Copy text from a web page. > 2. Double click on a cell in Calc to enter Cell Edit mode. > 3. Press Ctrl+V. 3. Press ctrl+shift+v ??
(In reply to Werner Tietz from comment #1) > (In reply to jasonkres from comment #0) > > > 1. Copy text from a web page. > > 2. Double click on a cell in Calc to enter Cell Edit mode. > > 3. Press Ctrl+V. > > 3. Press ctrl+shift+v ?? Yes, that works, but here is some perspective on why I created this issue: As a technical user, I know all the different paste commands and how to customize the menus and toolbars as well. What I was really trying to encourage to be addressed is not to find a solution for "me" but to make things easier for users who are confused by this not meeting expectations, especially users coming from an Excel background or doing simple data entry who just want to "Paste" (Ctrl+V) and have the "right" thing happen. In data entry scenarios, there is a lot of need to paste without formatting. Some users just want to focus on data entry and not learn about idiosyncrasies compared to Excel. (I realize this doesn't have an easy answer, Calc seems to be doing the "right" while Excel is doing something that happens to be very convenient for a typical user who probably has little need for mixed formatting within the text of the same cell.)