MD

Hi there,

i have a cell in Excel which contains for example the value „true, false“ and only the „true“-part of the cell is formatted with an underline (that’s how you format default output entries in DMN decision tables, see uploaded screenshot). How can my report detect this special part-formatting of an Excel cell?

I only found this to get the format oft the whole cell, but i need it character based:

 

var oCell = oSheet.getCell(nRow, nColumn);

var nFont = oCell.getCellStyle().getFontIndex();

Dialogs.MsgBox(nFont);

 

nFont is 12 if the whole cell ist formatted underline, else 7. I although want to create this character based formatting with ARIS in one Excel cell.

Any help would be appreciated.

File attachments
by Torsten Haase
Posted on Thu, 06/22/2017 - 16:05

Hi Mirco,

this is not possible yet. The report output API has been mainly designed to write output files with less attention to its reading capabilities. The functionality you need would be possible to be realized for xlsx file format. Please add a feature request for this issue.

Thanks & BR,

Torsten

0
by Mirco Dohmann Author
Posted on Mon, 06/26/2017 - 09:37

In reply to by thaase

Hi Torsten,

okay, I'll create a feature request. Thanks for your reply!

Mirco

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
  • Profile picture for user frankweise
  • Profile picture for user Henrik Buckler
  • Profile picture for user UffeK
  • SS
  • MZ
  • 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