https://bugs.freedesktop.org/show_bug.cgi?id=71519
Priority: medium
Bug ID: 71519
Assignee: [email protected]
Summary: EDITING: Pasting to a filtered table/to only visible
part of a table
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.2.3 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
Steps to reproduce:
1. take 2 tables with prices for fruits for june and july
2. filter only oranges of different varieties in both tables
3. assume that we have 50 oranges of different varieties in both tables(i mean
the lists match each other)
4. we need to replace prices for july with the prices for june
5. it seems that this is only a matter of selecting the column in the filtered
table with the prices for june and pasting it into the filtered table for july
Current behavior:
LibreOffice says this is impossible
Microsoft Excel would paste it as if the july table had no filter
Expected behavior:
I see 2 tables, no matter they have hidden rows or columns, I should have an
apportunity to work with them like with a normal tables.
Comments:
The solution for this situation is ether to copy 50 times each price
separately(this is about 150 keypresses) or to write a complexed formula(this
is a lot of keypresses too), but it looks intuitively like a copy/paste
operation. Please implement this feature, I know you care about users, not
about marketing like Microsoft, so please take care of me))
Operating System: Windows XP
Version: 4.1.2.3 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs