Bug Report Q501977
Visible to All Users

Formulas containing double quote characters not handled correctly after editing

created 12 years ago

The spreadsheet control doesn't appear to handle editing formulas contain a double quote character correctly. I have done my testing of this issue using the DevExpress Spread Sheet FeaturesDemo project.
Steps to Reproduce

  1. If you open the attached file XLS file in Microsoft Excel.

  2. Notice that the result displayed in cell A1 is
      'GFA' and "FECA"

  3. Click on A1 and you will see that its formula is:
      ="'GFA' and ""FECA"""

  4. Open the XLS file with the FeaturesDemo.

  5. Notice that A1 is displaying the correct result
      'GFA' and "FECA"

  6. Click on A1 to display the formula in the "Cell text =" box, and notice that it displays the incorrect formula:
      ="'GFA' and """"FECA"""

  7. Press F2 to edit the cell. Now press Escape to cancel the edit. Notice that the result displayed in A1 is now
      'GFA' and "FECA"

  8. Click on A2 and then back on A1 to display the formula in the "Cell text =" box. Notice that the formula displayed is now:
      ="'GFA' and """"""""FECA"""

Expected Behaviour
 - In step 6, the formula displayed should match the formula displayed by Excel in step 3.
 - In step 7, pressing Escape after F2 should not result in any change to the formula or the result.

Comments (2)

    Please note that the IDE is actually Embarcadero Delphi XE2 and not C++ Builder XE2 as originally entered.

    DevExpress Support Team 12 years ago

      Hello,
      I have reproduced the described behavior and forwarded this ticket to our developers for further research.

      Answers approved by DevExpress Support

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

        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.