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.
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