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.

File attachments
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,

0
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

0
by Martin Schröder
Badge for 'Contributor' achievement
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

0
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)

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks
  • SS
  • MZ
  • Profile picture for user kbiront
  • Profile picture for user Tony Iliev
  • Profile picture for user amandeep.7.singh
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock