Error recalculating some values in an excel workbook using spreadjs

Error recalculating some values in an excel workbook using spreadjs

Posted by: michael.glen on 30 June 2023, 4:02 am EST

• 

  michael.glen

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 30 June 2023, 4:02 am EST

  I have found a couple of issues with spreadjs calculations

  One relating to the TRANSPOSE function with a SEQUENCE when the value is 1
  
  e.g. =TRANSPOSE(SUBTOTAL(9,OFFSET(range,0,SEQUENCE(single)-1,3,1)))

  A second with use of ABS in named ranges

  if you have a named range with a value of =ABS(range) and then use that in a SUM function =SUM(namedrange) this gives a different result (sometime errors) than if the formulas are used directly e.g. =SUM(ABS(range))

  I have attached a small script and workbook that shows both the issues. You will need to run npm ci before running the script with node index.jsrecalc-issues.zip

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 3 July 2023, 12:49 pm EST

  Hi Michael,

  Thanks for sharing the Excel files with us. We were able to replicate the issue at our end with the latest version of SpreadJS v16.1.3. It seems like a calculation issue with the SpreadJS and therefore, we have escalated it to the concerned dev team for further investigation. The internal tracking id is: SJS-18996. I will let you know when there is an update from the dev team on this.

  Regards,

  Ankit

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 17 August 2023, 1:07 am EST

  Hi,

  The mentioned issue with internal tracking id: SJS-18996 has been resolved in the latest version of SpreadJS V16.2.0. Kindly upgrade to the latest version of SpreadJS.

  You may download the latest version using the following link: http://cdn.grapecity.com/spreadjs/16.2.0/Files/SpreadJS.Release.16.2.0.zip

  Please let us know if you still face any issues.

  Regards,

  Ankit