[Bug 162417] PIVOTTABLE: Warning does not show range when overwriting destination range contents

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Aug 24 16:18:49 UTC 2024


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

--- Comment #14 from Robert Lacroix <muxlab at hotmail.com> ---
The instructions for Step1 are incorrect. The clipboard contents must be pasted
as unformatted text.

As written, the procedure worked fine while I was typing into the Bugzilla
comment box, but from the comment as shown, the pressing Ctrl-V wants to do an
automatic text import in LO-Calc. So the modified instructions for Step 1 are:

Step 1: create a LO-Calc spreadsheet with the above table of information

1a) highlight the above 7 rows in this Bugzilla comment
1b) press Ctrl-C to copy the example to the clipboard
1c) start LO-Calc; a blank spreadsheet appears with active cell Sheet1.A1
1d) right-click in cell A1; the cell context menu pops up
1e) select Paste Special > Unformatted Text
1f) press Enter (or click OK); the example appears in LO-Calc at Sheet1.A1:B7

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


More information about the Libreoffice-ux-advise mailing list