Posted by Mirco Dohmann
Posted on 2017-06-06 in Reports & Macros

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.

Tags: ARIS ARIS Report excel macro Report 
9144
2
0