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.

CEILING error

Thread ID:

Created:

Updated:

Platform:

Replies:

79717 Feb 23,2009 09:11 AM Mar 9,2009 06:04 AM Windows Forms 3
loading
Tags: Calculate
Administrator [Syncfusion]
Asked On February 23, 2009 09:11 AM

I believe there is an error in the error trapping logic in the built in CEILING function.

The lines..
if (d1 * d2 <= 0)
return FormulaErrorStrings invalid_arguments];

Incorrectly pulls an error if d1 is 0. I think the test should read.
if (d1 * d2 < 0)
i.e. if the signs are non zero and opposite.




Jisha Joy [Syncfusion]
Replied On February 24, 2009 06:52 AM

Hi Brian,

Thank you for your interest in Syncfusion Products.

Could you please reproduce the issue in the following sample?. So that we could sort out the cause of the issue and provide you a solution soon.

http://files.syncfusion.com/support/Calculate.Windows/FormulaCeiling.zip

Regards,
Jisha


Administrator [Syncfusion]
Replied On March 6, 2009 05:56 AM

Oh come on guys! I've been very explicit as to what conditions cause the error and even shown you the correction to your source code.

Is it really necessary that provide a worked example?



Jisha Joy [Syncfusion]
Replied On March 9, 2009 06:04 AM

Hi Brian,

COuld you please reproduce the issue in the sample given in the previous update?. So that we could analyze the issue here.


Regards,
Jisha


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.

;