[Libreoffice-bugs] [Bug 136762] LibreOffice does not paste after v7

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #11 from Colin <that.man.colin at gmail.com> ---
Version: 6.4.6.2 (x64)
Build ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: default; VCL: win; 
Locale: sv-SE (en_GB); UI-Language: en-GB
Calc: threaded

I have ascertained the following:-

Whereas Shft+Ctrl+V should normally permit some control over the paste
criterea, utilising Shft +ALT +Ctrl +V whilst copying from a web-site - from
which the pasting fails - facilitates the paste special but automatically
forces "unformatted text", thereby producing a single column unformatted copy.

Some sites permit sorting of their data. If that data for copying is a single
dimension array then the +ALT paste ignores any data sorting in the page and
produces the original layout as a single column NOT row - even if the site data
is presented as a row.

My own lack of technical expertise dictates that I must assume the site
utilises characters between the data elements which are interpreted as Carriage
Returns by CALC - or it is an inherent CALC characteristic.

Having a number of files which are updated numerous times throughout the day I
have been able to concoct a nominal workaround; For those trying to paste a two
dimensional array of data it is necessary to utilise the +ALT Paste V variation
into a #scratch sheet. This produces a single column which is then re-mapped
into the desired layout within that same sheet. The genuine worksheet can
simply reference the re-mapped cells.

Visit the desired site > marquee select the desired data > Copy > Select the
#scratch workshheet at the fixed starting cell > +ALT Paste Special

Initially creating the re-mapped array is an overhead but once it's done, the
workflow is as simple as cut&paste.

An unforeseen advantage of this approach is that the calling cells never get
their formatting "amended" by a "careless" paste special.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201107/34d7d5ec/attachment.htm>