[Issue 112918] Copy paste text to table could adapt Tabs to columns and Paragraph marks to lines

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=112918

Nicolas Daum <da...@orange.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |daum.nicolas@orange.fr

--- Comment #3 from Nicolas Daum <da...@orange.fr> ---
Tabs are the most commonly used column delimiters in microcomputers. Most
softwares export columnar data in this format by default and with some of them
with no other option.
OTOH most spreadsheet softwares I've used, either when importing tabbed text
files, when pasting or when dragging and dropping tabbed data from another
source (a word processor for example), interpret by default tabs as delimiters.
I just can't fathom the rationale behind the default option in Calc to paste
tabbed data (i.e. copied in Writer) as “text Writer data” with each complete
line in one cell. Who the heck needs that in a spreadsheet?
It's extremely time consuming. I have lots of .txt tabed data files to import
in Calc. I have to copy the data, chose Special Paste, then select Unformated
Text and so on.

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are on the CC list for the issue.