[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 #13 from BikeHelmet at gmail.com ---
(In reply to Colin from comment #11)
> 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.

Thanks, Colin. That's a good and practical work-around for an odd bug. I'll use
that if I jump back to v7 again and the regular paste still isn't fixed.

-- 
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/20201110/1362033d/attachment.htm>