Setting the height of a row in an excel report

SmokesMom

I am trying to set the height of a row in an excel report. In the initialize event of the report script I evaluate the number of parameters that have been passed in and set the height accordingly. I am currently using version 3.7.2 and originally had this working in version 2.3.2.

Now howevever, this code no longer works. I get an error saying that it cannot find the function getRows.

TypeError: Cannot find function getRows in object org.eclipse.birt.report.model.api.TableHandle@c9dde8. (/report/method[@name="initialize"]#23) (Element ID:1)

This is the code I am using. What happened to getRows()?

var gridDesignElementHandle = reportContext.getDesignHandle().getElementByID(3939);
var rowDesignElementHandle = gridDesignElementHandle.getRows().get(2);
rowDesignElementHandle.setProperty( "height", lHeight);


Thank you,
Kris Chappell

kclark

I think it's because you're trying to use this script on a table. I was able to use the same code you provided in a grid and it worked fine. If you need to use a table and you want to set the height you could do something like this in the onPrepare<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
var cellHeight = 20;
this.height = cellHeight + "pt";
</pre>