Try the fastest and simplest way to install ONLYOFFICE

How to copy shown cells in spreadsheet with filter

Suggestions on Document Server Installation/Functionality

How to copy shown cells in spreadsheet with filter

Postby nagios.msff.rsp » Tue Apr 18, 2017 8:03 am

Hi,

I am using

4.3.1.4

I see you guys have implement new paste features, thank you for that.

I still have an issue when I make spreadsheet and use filters, then I want to copy the results for exampe:

I have excel with column that contain either 1 or 0 with total of 10 records for both
And when I filter the 1 column, I get 3 records
When I drag and copy those 3 columns and paste them I get 7 records pasted, why cause the copy also takes the hidden data like records with 0 in between the copy

MS Excel handles this automatically or you need to press Find & Select --> Go To Special --> Visible Cells only

Can you please look into this ?

Many Thanks.
nagios.msff.rsp
 
Posts: 1
Joined: Tue Apr 18, 2017 7:52 am

Re: How to copy shown cells in spreadsheet with filter

Postby Maxim » Tue Apr 18, 2017 12:38 pm

Hello nagios.msff.rsp!
We have detected the bug! Thank you for error notification!
Maxim
 
Posts: 777
Joined: Tue Oct 11, 2016 2:34 pm


Return to Document Server

Who is online

Users browsing this forum: No registered users and 0 guests