BuyLog In
Bug Report T133732
Visible to All Users

References to sheets containing no pairs of parentheses or brackets in their captions cannot be resolved

created 11 years ago

If you have a formula that references a cell in another sheet and the name of that sheet contains brackets it just outputs #VALUE!

Comments (3)
DevExpress Support Team 11 years ago

    Stephen,

    AFAIK, in MS Excel it is necessary to use syntax like this to refer to a sheet whose name contains brackets:

    =SUM('(Sheet1)'!A1:A2)

    The same syntax seems to work OK in our formulas. Please check it on your side and let me know your results. In case I misunderstood the problem you are referring to, please clarify your scenario in greater detail. A small sample project to demonstrate the problem would be much appreciated. I am looking forward to your feedback.

    SM SM
    Stephen Millington 11 years ago

      That's the syntax I tried. Please see sample file in attachment. If you open in Excel and look in cell J1 you will see the calculation is =SUM('Sheet2 (PR…'!A1) and it correctly displays the value from cell A1 on Sheet 2. If you open in your spreadsheet it shows #VALUE!

      DevExpress Support Team 11 years ago

        Thank you for this demo. I have reproduced the described behavior and forwarded this ticket to our developers for research.

        Sign in to comment on this post

        Answers approved by DevExpress Support

        created 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.

          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.