ParamQuery grid support forum

General Category => Bug Report => Topic started by: vsa on June 16, 2021, 11:54:38 am

Title: Excel Formula with JSFormula combining returns a wrong result
Post by: vsa on June 16, 2021, 11:54:38 am

Hello,

Here is an example: https://jsfiddle.net/obpLsg81/8/

Last version is used for this example, however problem is present in previous versions, also.

Column 4 is calculated with JS Formula has to take a calculated value from column 3, but does not see it
Column 5 is same, but is calculated with Excel Formula and works fine.

That seems to be a problem of the fixed order/priority of calculation.

We are not confusing but combining both types of formulas, so this is an important bug in calculation.

Thank you in advance

Title: Re: Excel Formula with JSFormula combining returns a wrong result
Post by: paramvir on June 16, 2021, 12:11:37 pm

Result of referencing excel formulas from js formulas and vice versa is undefined, so it should be avoided.

Title: Re: Excel Formula with JSFormula combining returns a wrong result
Post by: vsa on June 16, 2021, 12:45:08 pm

Thank you. However, if such a combination is not possible, this should be clearly stated in the documentation. Otherwise it's a bug