Hello Community,
I want to create an excel table with the createExcelWorkbook() function.
I would like to set the cell width with the function setColumnWidth(). For the small cell width, it works perfectly. However, for other large scale cell width, no matter what number I gave to the function, all the cell width was set to be 49.31. I have to change the cell width manually in excel.
Is there a maximal cell width limit while using the function setColumnWidth()?
BR
Hi there.
I tested it with the patched version of ARIS 10.0.7 and the method works as expected, without a 49.31 column size limit.
My tiny test script (report context doesn't matter; output to xlsx):
var workbook = Context.createExcelWorkbook(Context.getSelectedFile()); var sheet = workbook.createSheet("Sheet1"); sheet.setColumnWidth(0, 60*256); workbook.write()
This gives me a workbook, with one sheet where the first column is 59.29 wide.
Granted, when I swap the 60 with 256, ARIS reminds me that the max width of a column is 255 characters. But even with 255 I get a column width of 254.29 - far wider that your 49.31.
Could you test whether or not my tiny test script gives you different results, provide a code sample of your code with the important parts for us to see, and/or maybe tell us more about your environment (ARIS version in use,...).