[Libreoffice-bugs] [Bug 45958] New: CALC: Only Copy Visible Cells doesn't work when only some columns are selected
bugzilla-daemon at freedesktop.org
bugzilla-daemon at freedesktop.org
Sun Feb 12 11:38:40 PST 2012
https://bugs.freedesktop.org/show_bug.cgi?id=45958
Bug #: 45958
Summary: CALC: Only Copy Visible Cells doesn't work when only
some columns are selected
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.4.5 release
Platform: x86 (IA32)
OS/Version: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Libreoffice
AssignedTo: libreoffice-bugs at lists.freedesktop.org
ReportedBy: pirrimanson2000 at gmail.com
Created attachment 56922
--> https://bugs.freedesktop.org/attachment.cgi?id=56922
CALC example
In the LibO online manual (http://help.libreoffice.org/Calc/Only_Copy_Visible_Cells) says :
Cells were filtered by AutoFilters, standard filters or advanced filters. --> Only the visible cells of the selection are copied, deleted, moved, or formatted.
This is not completly true, at least when you want to COPY data.
Try this:
1. Open the attachment.
2. Filter the data (for example, by Country).
3. Edit-->Select all, then copy, then go to sheet 2 and paste the data. Only the visible cells are copied (as expected ).
Now, try this:
1. With the data still filtered, select column "Name" and then hold CTRL and select column "Salary"
2. Edit -> Copy, and then paste the date in the sheet 2.
As you can see, ALL cells are copied, not only the visible ones. The expected behavior should be copy the visible cells only (I think).
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
More information about the Libreoffice-bugs
mailing list