Error in report creatin cell formula on output excel

Posted by Jesús Carrillo

Posted on Sat, 07/24/2021 - 00:39 in Reports & Macros

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.

ARIS

ARIS Report Scripting

ARIS script

File attachments

ARISError.png

ARIS.png

242

by Harm Verschuren

Posted on Mon, 07/26/2021 - 09:06

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,

by M. Zschuckelt

Posted on Mon, 07/26/2021 - 09:14

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

by Martin Schröder

Posted on Mon, 07/26/2021 - 14:24

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 works
correctly again. (Pivotal 5444289)

Regards, Martin

by Milan Slivka

Posted on Tue, 07/27/2021 - 01:04

Fixed in SR15... had the same problen

Exporting formulas to Microsoft Excel output files using ARIS report scripts now works correctly again. (Pivotal 5444289)

Error in report creatin cell formula on output excel

Featured achievement

Leaderboard

Follow us

View posts by tag