Author Topic: Excel Formula with JSFormula combining returns a wrong result  (Read 127 times)

vsa

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 7
    • View Profile
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

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 5114
    • View Profile
Re: Excel Formula with JSFormula combining returns a wrong result
« Reply #1 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.


vsa

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: Excel Formula with JSFormula combining returns a wrong result
« Reply #2 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