Bug 74247

Summary:	EDITING: Request ability to configure text export used when pasting plain text
Product:	LibreOffice	Reporter:	Andy Goth <andrew.m.goth>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WONTFIX
Severity:	enhancement	CC:	andrew.m.goth, jbfaure, libreoffice-ux-advise
Priority:	medium	Keywords:	needsUXEval
Version:	4.1.4.2 release
Hardware:	Other
OS:	Windows (All)
Whiteboard:	BSA
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108597

Description Andy Goth 2014-01-30 21:51:35 UTC

Problem description: When saving to CSV, I have the option to specify the character set, the field delimiter, and the text delimiter, plus a few other things.  I don't have any of these options when copying cells and pasting to plain text (e.g. to PuTTY); it always uses tabs to separate cells.  For my application, tabs are forbidden, and I must use spaces.  My workaround is to paste to Vim, convert tabs to spaces, then copy and paste again to where I need it.

Steps to reproduce:
1. Copy cells
2. Paste to an application expecting plain text, e.g. PuTTY
3. Cells are separated by tabs, no matter what you may have wanted

Current behavior:
Pasting to plain text always separates cells with tabs

Expected behavior:
Configuration dialog accessible somewhere in menus to change the delimiters in the same manner as when saving to CSV.
Operating System: Windows 7
Version: 4.1.4.2 release

Comment 1 Jean-Baptiste Faure 2014-02-02 07:53:45 UTC

As it exposed, it is not a bug description but an enhancement request.

Please, could you check if you can't do what you want with current new version 4.2 ?

Best regards. JBF

Comment 2 Andy Goth 2014-02-03 00:15:26 UTC

Will download 4.2 momentarily.  First let me thank you for changing this to a feature request.  I tried to report it as such by using "Help > Send Feedback... > File An Enhancement Request", but it still came up as a bug.  Guess we need a meta bug report on that. :^P

Comment 3 Andy Goth 2014-02-03 00:37:38 UTC

Okay, installed.  Nope, I can't find any such option.  I'm not sure where it would be, but I looked throughout Edit and Tools > Options.

Comment 4 Tomaz Vajngerl 2014-02-13 20:44:07 UTC

Valid enhancement request I think.

Comment 5 Buovjaga 2021-05-07 15:07:27 UTC

Design team could think about the exact dialog implementation

Comment 6 Heiko Tietze 2021-05-13 10:22:06 UTC

We discussed this topic in the design meeting. UI/UX-wise it seems to be easy to introduce a "copy special" option, something that evokes a dialog where the user can change the delimiter. But the trouble start with inserting and worst case is that those copied content always require a text import dialog to paste back. The recommendation is therefore to realize the special copy function per macro (and ideally share this as extension).