Bug Report T293219
Visible to All Users

The SpreadsheetNameBoxControl.ReadOnly property value is incorrectly reset when an end-user starts editing a cell

created 9 years ago

Hi I'm currently using DevExpress SpreadsheetControl in my WinForms project.

I'm using the SpreadsheetControl and the SpreadsheetNameBoxControl in my form. I have bound these two controls to each other via SpreadsheetNameBoxControl.SpreadsheetControl property. I would like to set the SpreadsheetNameBoxControl as readonly so that the end-user cannot edit the value inside the SpreadsheetNameBoxControl but still would reflect the cell selected in SpreadsheetControl.

I have tried by setting SpreadsheetNameBoxControl.ReadOnly to true both in designer and also in runtime. When the application first loads, the SpreadsheetNameBoxControl looks disabled and does not get into edit mode. But when a cell gets selected in the SpreadsheetControl via mouse click, the SpreadsheetNameBoxControl becomes enabled and is allowed to be edited.

Please advise how can I change this behaviour so that the SpreadsheetNameBoxControl stays in readonly mode.

Attached is a sample project which demonstrate how I am trying to set the SpreadsheetNameBoxControl as readonly.

Thank you.

Comments (1)
DevExpress Support Team 9 years ago

    Hello,
    I have successfully reproduced the behavior you described and passed this ticket to our developers' team for further research.
    Please bear with us. We will notify you as soon as we make any progress.

    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.

    Additional information:

    We have overridden the ReadOnly property in the DevExpress.XtraSpreadsheet.SpreadsheetNameBoxControl class.
    You can use the following code to change the accessibility of SpreadsheetNameBoxControl:

    C#
    spreadsheetNameBoxControl1.ReadOnly = DevExpress.Utils.DefaultBoolean.True;
      Comments (2)

        Hi DevExpress Support Team,
        Thank you for helping to resolve this issue. Can I please ask if this fix is to be included in the release version 15.1.8? If so, can I please know the estimated release date for version 15.1.8?
        Thank you.

        DevExpress Support Team 9 years ago

          Hello,
          Yes, the fix we provided in the scope of this thread will be included into the next minor version 15.1.8 of our components. I can't provide you with the exact date of introducing this version, however, usually we introduce each minor version monthly.
          Version 15.1.7 was introduced on September 23, thus I believe that version 15.1.8 will be introduced at the end of October. If this a matter of urgency, you can request an intermediate build which contains a hotfix for this issue by clicking the "Request hotfix" hyperlink on this ticket's page.
          Once this build is prepared for downloading, you need to install it and upgrade your application.
          Alternatively, if this issue is not quite critical for you, you can wait until the official version 15.1.8 is released.

          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.