Bug Report Q501467
Visible to All Users

Drag/drop of the pivot grid 'Data' field does not allow dropping as expected

created 12 years ago

My users have uncovered some unusual behavior in the pivot grid component when they try to drag and drop fields and the 'Data' field. This happens in the grid itself. (I haven't tried it in the fields popup window)

I've attached an extremely basic application with a pivot grid. The only thing to note about this application is

  1. OptionsDataField.Area = dfaColumn
  2. OptionsView.RowTotalsLocation = rtlTree (this setting seems to affect the behavior)

Please run the app and try the following steps as closely as possible. I use the term 'Data' to mean the red captioned field representing the Data 1 and Data 2 fields.

Scenario A

  1. Click on the 'Data' field and drag/drop it to the left of Field 3. This works as expected.
  2. Click on the 'Data' field and drag/drop it back to the right of Field 3. This also works as expected
  3. Click on Field 3 and (try to) drag/drop it to the right of the 'Data' field. The grid doesn't allow the field to be dropped even though steps 1 & 2 clearly demonstrate the arrangements of Field 3/Data and Data/Field 3 are both allowed.

Close and restart the application

Scenario B

  1. Click on the 'Data' field and drag/drop it to the row area to the right of Field 2. This work as expected.
  2. Click on the 'Data' field and (try to) drag/drop it in the row area between Field 1 and Field 2. The grid doesn't allow the data field to be drop here; but it ought to.
  3. Click on Field 1 and drag/drop it to the filter area
  4. Click on Field 2 and drag/drop it to the filter area
  5. Click on Field 1 and drag/drop it to the right of the Data field (in the row area). Notice that the grid doesn't allow the field to be dropped to the left of the Data field.

Close and restart the application

Scenario C

The goal of this scenario is to get the fields arranged in the row area so that they are Field 1, 'Data', Field 2. It's not as simple as it sounds. There may be other solutions but the only way I've found to do it is these steps

  1. Drag 'Data' to the row area
  2. Drag Field 1 and Field 2 to the filter area
  3. Drag Field 1 and Field 2 back to the row area so they are to the right of 'Data'
  4. Drag 'Data' between Field 1 and Field 2

The point of this issue is that arranging the fields in the pivot grid should not be a puzzle for the end user. For example, if Field 1, Field 2 and 'Data' are all in the row area, the user should be able to drag/drop any of the 3 fields into any arrangement (e.g. Field 1, Data, Field 2; Field 2, Data, Field 1). It is too much to expect users to understand "tricks" about dragging fields to the filter area before moving them to where they want.

Hopefully you are able to follow the description above. If not, I will try to clarify.

Thank you for your help…
Andy

Comments (1)
DevExpress Support Team 12 years ago

    Hello,
    Thank you for your detailed report. I have reproduced all described scenarios and forwarded this ticket to our developers for the research.

    Answers approved by DevExpress Support

    created 12 years ago (modified 12 years ago)

    We have examined the issue and discovered that the current incorrect behavior is caused by two separate problems. We have created corresponding tickets on each problem. Please refer to the following tickets for further correspondence on these items:
    Compact layout - Dragging row field headers can make the data field anchor precede them
    Compact layout - A field header cannot be dragged to precede the data field anchor located in the column header area

      Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

      Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.