Wed, 2023-03-29 16:00
JC
I have a report that creates an excel sheet with formulas. This report was working fine but the administrator upgraded ARIS from 10.13 to 10.14 and this report not working now!
The error line number is 184Â on the attached image.
The error is:Â Error durante la ejecuciĂłn de la secuencia de comandos:
Secuencia de comandos: M, lĂnea 184
Calling Cell.setCellType(CellType.FORMULA) is illegal. Use setCellFormula(String) directly.
Â
Thank you.
Hi JesĂșs,
It might be excel is the source of the error as functions in excel expect a semi-colon ";" instead of a comma ",". Can you try replacing the comma with semi-colon and check the report? Like,
oCell.setCellFormula("IF(E" + (ind + 1) + "=\"X\";\"X\";\"Colocar S Ăł N\")");Does it help? Best regards,
Hi JesĂșs,
if you say the same code has been working perfectly in SR13, please open a support ticket. You might also check the Release notes of SR14, if there were any incompatible API changes.
Best regards,
M. Zschuckelt
Hello JĂ©sus,
this seems to be fixed in SR15 c.f release notes from ARIS Download Center :
Exporting formulas to Microsoft Excel output files using ARIS report scripts now workscorrectly again. (Pivotal 5444289)
Regards, Martin
Fixed in SR15... had the same problen
Exporting formulas to Microsoft Excel output files using ARIS report scripts now works correctly again. (Pivotal 5444289)