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
-
If you open the attached file XLS file in Microsoft Excel.
-
Notice that the result displayed in cell A1 is
'GFA' and "FECA" -
Click on A1 and you will see that its formula is:
="'GFA' and ""FECA""" -
Open the XLS file with the FeaturesDemo.
-
Notice that A1 is displaying the correct result
'GFA' and "FECA" -
Click on A1 to display the formula in the "Cell text =" box, and notice that it displays the incorrect formula:
="'GFA' and """"FECA""" -
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" -
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.
Please note that the IDE is actually Embarcadero Delphi XE2 and not C++ Builder XE2 as originally entered.
Hello,
I have reproduced the described behavior and forwarded this ticket to our developers for further research.