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.

IF: string can''t be empty

Thread ID:

Created:

Updated:

Platform:

Replies:

36932 Nov 12,2005 10:55 AM Nov 15,2005 04:06 AM Windows Forms 3
loading
Tags: XlsIO
Administrator [Syncfusion]
Asked On November 12, 2005 10:55 AM

I''m trying to use the IF statement such as sheet.Range[row, 7].Formula = "IF(AND(D16+E16>0, F16>0),1 - ((D16+E16) / F16),0)"; but keep getting a "formula string can''t be empty" error. Any idea why? i''ve tried it with 3.2.1 and 3.3. thanks

Administrator [Syncfusion]
Replied On November 12, 2005 01:12 PM

Also I''m getting an error with just sheet.Range[row, 7].Formula = "1 - ((D16+E16) / F16)" ???

Administrator [Syncfusion]
Replied On November 13, 2005 11:19 PM

Hi Colin, I was able to see the problem and have filed a bug report with the development team. You can track the status of this issue here. http://www.syncfusion.com/support/issues/xlsio/Default.aspx?ToDo=view&questId=1037 Please let me know if you have any questions. Thanks for your interest with Syncfusion products. Best Regards, Seetha >Also I''m getting an error with just >sheet.Range[row, 7].Formula = "1 - ((D16+E16) / F16)" ???

Administrator [Syncfusion]
Replied On November 15, 2005 04:06 AM

Hi Colin, We don''t support spaces inside formulas. After removing unnecessary spaces all formulas were parsed without any problems. Try removing spaces inside the formulas. It works fine. Please let me know if you have any questions. Thanks for your interest with Syncfusion products. Best Regards, Seetha >Hi Colin, > >I was able to see the problem and have filed a bug report with the development team. You can track the status of this issue here. > >http://www.syncfusion.com/support/issues/xlsio/Default.aspx?ToDo=view&questId=1037 > >Please let me know if you have any questions. > >Thanks for your interest with Syncfusion products. > >Best Regards, >Seetha > > >>Also I''m getting an error with just >>sheet.Range[row, 7].Formula = "1 - ((D16+E16) / F16)" ???

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.

;