[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