Bug 49205 - EDITING: Pasting to autofiltered fields
Summary: EDITING: Pasting to autofiltered fields
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.5.2 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-04-26 23:03 UTC by mahfiaz
Modified: 2012-09-06 21:01 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments

Description mahfiaz 2012-04-26 23:03:30 UTC
Problem description: 
Cannot paste into autofiltered range, because selection is not uniform.

Steps to reproduce:
1. Make a list of repeating numbers in one column such as 1, 2, 3, 4, 1, 2, 3, 4. 
2. Now use autofilter to filter out everything but ones.
3. Let's say you want to copy there your two lines of data from somewhere else. But you cannot, Libreoffice says you cannot paste into multiple selections.

Expected behavior:
Being able to paste into autofiltered sheet to visible fields.

Platform (if different from the browser): 
              
Browser: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:11.0) Gecko/20100101 Firefox/11.0
Comment 1 bfoman 2012-07-17 12:59:21 UTC
Checked with:
LO 3.5.5.3 
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit

In your example I could paste into filtered fields using Ctrl+V. I just received "cells contain data" warning. However paste commands in right-menu or toolbar buttons are disabled.
Comment 2 mahfiaz 2012-09-06 21:01:00 UTC
LibO 3.6.1, still the same. If you test it just make sure the range you are pasting into contains at least a row, which is filtered out.
Easiest is to copy everything and then paste it into the same place.


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.