Home Dashboard Directory Help
Search

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


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 795743
Opened: 8/1/2013 11:18:50 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description


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.
Details
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 (wajokiel@microsoft.com)
Sign in to post a workaround.