Excel buffer - cell width AND multiline

awarn

Hi,

I have added two fields to the Excel Buffer table, Multiline and Cell Width. But it seems I cannot use both of these at the same time. In the excel buffer table I have this code:


IF "Cell Width" <> 0 THEN
XlWrkSht.Range(xlColID + xlRowID).Columns.ColumnWidth := "Cell Width";
XlWrkSht.Range(xlColID + xlRowID).WrapText := Multiline;

The problem is that when the Multiline is true, a caption 'Customer Name' prints in Excel as:

Custome
r Name

And if I set the column width to 68 (in the code, by setting the Cell Value field), then the cell width is ignored - and Excel prints the entire 'Customer Name' caption on one line, and the width is the width of the entire text (106 pixels).

Am I doing something wrong? It seems like the Column Width field is not working. The goal is to see in excel

Customer
Name

and to have the column slightly wider than the 'Customer' text.

-a