copy and paste to filtered excel list in mds only pastes the first row value - by bendlam

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 795743 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 8/1/2013 11:18:50 AM
Access Restriction Public


Hi, if I have an entity opened in the excel mds add-in and say filter out some rows and copy and paste some row values in the columns, it seems to only paste the first row of data.  i.e. if I had an entity that had a list of scorecard metrics and targets for different geographies and I wanted to filter only the target values for Canada, mds will filter the rows to only show metrics and targets for canada.  these rows may not be contiguous the way the data was setup.  now if I had the data in another spreadsheet and wanted to cut and paste it into excel, i.e. the targets for canada, it seems to only paste the first row.  I'm thinking this is because the rows are not contiguous and mds is not able to figure out how to paste the subsequent rows to the corresponding row.
Sign in to post a comment.
Posted by Microsoft on 8/2/2013 at 10:00 AM
Hello bendlam. Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you.

-Walter A Jokiel, Program Manager, SQL Server (