BuyLog In
Bug Report T128845
Visible to All Users

The spreadsheet doesn't provide the equivalent event to the OnActiveCellChanging event available in the deprecated version

created 11 years ago

During the conversion to the new Spreadsheet, I had an older cxSpreadsheet that used the OnActiveCellChanging event.  What did this become in the new dxSpreadsheet and how do I implement it?

A lot of the specifics on dxSpreadsheet are missing from the help file.

Comments (2)
DevExpress Support Team 11 years ago

    Hello John,

    It looks like there is no any corresponding event in the new TdxSpreadSheet control. I have forwarded this ticket to our developers for fixing.

    JF JF
    John Friel 11 years ago

      Thank you.

      Sign in to comment on this post

      Answers approved by DevExpress Support

      created 11 years ago (modified 11 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.

      Additional information:

      We added the protected OnActiveCellChanging event to the TdxCustomSpreadSheet class and published this event in the TdxSpreadSheet class:

      type
      TdxSpreadSheetTableViewActiveCellChangingEvent = procedure(Sender: TdxSpreadSheetTableView; const ANewActiveCell: TPoint; var ACanSelect: Boolean) of object;

      TdxCustomSpreadSheet = class
      protected
        // …
        property OnActiveCellChanging: TdxSpreadSheetTableViewActiveCellChangingEvent;
        // …
      end;

      TdxSpreadSheet = class
      published
        // …
        property OnActiveCellChanging: TdxSpreadSheetTableViewActiveCellChangingEvent;
        // …
      end;

      Note that Y and X sub-properties of the ANewActiveCell event parameter (ANewActiveCell.Y and ANewActiveCell.X) now specify the row and column of the cell to be focused.

        Sign in to comment on this post

        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.