Bug Report T359299
Visible to All Users

Spreadsheet - It's impossible to change cell selection on a custom callback

created 9 years ago

Using the MVC spreadsheet control, I am trying to change the active cell selection during a custom callback action, but not having any luck.

I've tried doing it this way:
https://www.devexpress.com/Support/Center/Question/Details/T126769

But that doesn't have to seem any effect when I return to my view.

I've also tried this way, on the client side:
https://www.devexpress.com/Support/Center/Question/Details/T333741

It works, but it is extremely, unfeasibly slow to do it on the client side -- at least doing it this way.

I haven't come across any other ideas. Is this possible? If so, how? Thanks!

Answers approved by DevExpress Support

created 9 years ago

We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.

Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.

    created 9 years ago

    Hello Nate,

    If you need to manage a document in the Controller, I recommend you use the approach described at Spreadsheet - How to access an active sheet in the Controller to get the document. Once you get it, use the solution from the ASPxSpreadsheet - How to change selection ticket to set a new selection range.

    I'm not sure about the client-side approach. Usually, client-side solution performance is higher as compared to the server-side one. Would you please demonstrate how you implemented that solution in your project?

      Comments (3)
      NF NF
      Nate Farnsworth 9 years ago

        Unfortunately that is not working -- your suggestion was the same exact link that I told you didn't work.

        I attached a sample project which has a custom button on a custom tab that calls back into the controller and (tries to) change the selection. If you could please give me a working solution, I would appreciate it very much. Thanks!

        Artem (DevExpress Support) 9 years ago

          Hi Nate,

          Thanks for the clarification. The described behavior looks incorrect and I have forwarded it to our R&D team for further research.
          Please bear with us.

          NF NF
          Nate Farnsworth 9 years ago

            Thanks Artem. I'll be looking forward to further information.

            It's actually a big deal. I've implemented functionality to move one or more columns to the left or right within the spreadsheet, but because I can't change the selection, the result is that the data gets moved, but the selection remains the same. This causes confusion for the user, and prevents the user from additional column move actions without re-selecting columns . What I need is to be able to move the selection along with the data.

            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.