We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

invalid char in front of +

Thread ID:

Created:

Updated:

Platform:

Replies:

39097 Dec 27,2005 05:40 AM Mar 27,2006 06:56 AM Windows Forms 10
loading
Tags: Calculate
Brian J. Burnett
Asked On December 27, 2005 05:40 AM

What does this error message mean? it occurs anytime I use a named range in a formula. Even something as simple as =NamedRangeOne+NamedRangeTwo causes the error.

Administrator [Syncfusion]
Replied On December 29, 2005 01:24 AM

Hi Brian, I was not able to reproduce the error in this sample.Calculate_Excel.zip. Could you please reproduce the error in this sample.Please provide your Version details also. Thanks for choosing and using Syncfusion Products. Best Regards, Jeba.

Brian J. Burnett
Replied On December 29, 2005 03:29 AM

I can''t talk c# so I can''t talk to the code parts of your sample. However, looking at the spreadsheet it does not used NAMED ranges. Only cell references. >Hi Brian, >I was not able to reproduce the error in this sample.Calculate_Excel.zip. Could you please reproduce the error in this sample.Please provide your Version details also. > >Thanks for choosing and using Syncfusion Products. > >Best Regards, >Jeba.

Brian J. Burnett
Replied On December 29, 2005 04:33 AM

I did some work to produce a simple example which illustrates this and the quotation marks issue. The attached sample shows both problems. In fact I''ve figured out what causes the "invalid char in front of +" message. It''s when the named range includes the underscore ("_") character. This is different behaviour from Excel so I''d call it a bug. The quotation marks problem occurs when the cell contains a formula which returns a string result. >I can''t talk c# so I can''t talk to the code parts of your sample. > >However, looking at the spreadsheet it does not used NAMED ranges. Only cell references. > > > >>Hi Brian, >>I was not able to reproduce the error in this sample.Calculate_Excel.zip. Could you please reproduce the error in this sample.Please provide your Version details also. >> >>Thanks for choosing and using Syncfusion Products. >> >>Best Regards, >>Jeba.

ProblemsWithNamedRanges.zip

Brian J. Burnett
Replied On December 29, 2005 04:37 AM

From the Excel help.. "What characters are allowed? The first character of a name must be a letter, an underscore character (_), or a backslash (\). Remaining characters in the name can be letters, numbers, periods, and underscore characters." >I did some work to produce a simple example which illustrates this and the quotation marks issue. > >The attached sample shows both problems. > >In fact I''ve figured out what causes the "invalid char in front of +" message. It''s when the named range includes the underscore ("_") character. > >This is different behaviour from Excel so I''d call it a bug. > >The quotation marks problem occurs when the cell contains a formula which returns a string result. > > >>I can''t talk c# so I can''t talk to the code parts of your sample. >> >>However, looking at the spreadsheet it does not used NAMED ranges. Only cell references. >> >> >> >>>Hi Brian, >>>I was not able to reproduce the error in this sample.Calculate_Excel.zip. Could you please reproduce the error in this sample.Please provide your Version details also. >>> >>>Thanks for choosing and using Syncfusion Products. >>> >>>Best Regards, >>>Jeba.

ProblemsWithNamedRanges.zip

Brian J. Burnett
Replied On December 29, 2005 04:42 AM

Version is 4.101.0.9 >From the Excel help.. > >"What characters are allowed? The first character of a name must be a letter, an underscore character (_), or a backslash (\). Remaining characters in the name can be letters, numbers, periods, and underscore characters." > > >>I did some work to produce a simple example which illustrates this and the quotation marks issue. >> >>The attached sample shows both problems. >> >>In fact I''ve figured out what causes the "invalid char in front of +" message. It''s when the named range includes the underscore ("_") character. >> >>This is different behaviour from Excel so I''d call it a bug. >> >>The quotation marks problem occurs when the cell contains a formula which returns a string result. >> >> >>>I can''t talk c# so I can''t talk to the code parts of your sample. >>> >>>However, looking at the spreadsheet it does not used NAMED ranges. Only cell references. >>> >>> >>> >>>>Hi Brian, >>>>I was not able to reproduce the error in this sample.Calculate_Excel.zip. Could you please reproduce the error in this sample.Please provide your Version details also. >>>> >>>>Thanks for choosing and using Syncfusion Products. >>>> >>>>Best Regards, >>>>Jeba.

ProblemsWithNamedRanges.zip

Administrator [Syncfusion]
Replied On December 29, 2005 05:32 AM

Hi Brian, Please refer this VB sample: Quotation.zip Let us know if this is not what you needed. Best Regards, Jeba.

Brian J. Burnett
Replied On December 29, 2005 06:52 AM

There is some interesting stuff in that example but not the point I am raising. What I''m saying, and the example I provided demonstrates, is that if a template.xls contains named ranges with underscores or periods in the name then Calculate produces results that is not compliant with Excel. >Hi Brian, >Please refer this VB sample: >Quotation.zip > >Let us know if this is not what you needed. > >Best Regards, >Jeba. >

Administrator [Syncfusion]
Replied On December 29, 2005 07:18 AM

Hi Brian, Thanks for bringing this issue to our attention. I have entered this as a defect. We will try our very best to address this issue at the earliest. You can track this online here: http://www.syncfusion.com/support/issues/calculate/Default.aspx?ToDo=view&questId=1325 Best Regards, Jeba.

Brian J. Burnett
Replied On March 27, 2006 02:27 AM

What is the latest on this issue? Has it been fixed or is there any plan to release a fix? >Hi Brian, > >Thanks for bringing this issue to our attention. >I have entered this as a defect. We will try our very best to address this issue at the earliest. You can track this online here: >http://www.syncfusion.com/support/issues/calculate/Default.aspx?ToDo=view&questId=1325 > >Best Regards, >Jeba.

Administrator [Syncfusion]
Replied On March 27, 2006 06:56 AM

Hi Brian, Please check the issue in Essential studio 4.1.0.50. It was fixed in 4.1.0.50 Only underscores are supported in namedranges. Periods are not supported. Please refer this link: NamedRanges with special characters produces bad outputs. --->Fixed in 4.1.0.50 Let us know if you still face any issue related to this. Best Regards, Jeba

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;