<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - LibreOffice does not paste after v7" href="https://bugs.documentfoundation.org/show_bug.cgi?id=136762#c13">Comment # 13</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - LibreOffice does not paste after v7" href="https://bugs.documentfoundation.org/show_bug.cgi?id=136762">bug 136762</a> from <a class="email" href="mailto:BikeHelmet@gmail.com" title="BikeHelmet@gmail.com">BikeHelmet@gmail.com</a> <pre>(In reply to Colin from <a href="show_bug.cgi?id=136762#c11">comment #11</a>) > 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>