How to calculate the column width and row height of a BIRT table, how to calculate the row height exported to xlsx, and how to calculate the row height and column width ratio of Excel and BIRT

[858882847]

How to calculate column width ratio columns and row height ratio columns in Excel and BIRT

[hvbtup]

If you want to set the widths/height dynamically based on your data, you are on your own.
You can use your own best-effort algorithm and specify the widths/heights in the table/grid item's onPrepare event like this:

// Assuming colWidths is an array of the calculated column widths.
for (var i = 0; i < colWidths.length; ++i) {
    if (colWidths[i] !== null) {
        this.getColumn(i).width = String(colWidths[i]) + " mm";
    }
}

Be warned: This usually makes no sense except for trivial cases.

[858882847]

What I mean is how to convert BIRT's column width output to Excel when exporting to Excel. What is the conversion ratio between them

[858882847]

"If BIRT is exported as xlsx, the column width must be expressed in inches, otherwise the format context may be problematic, while Excel column width represents characters."