Formatting Columns
Posted: Mon Jan 13, 2014 6:35 am
I have just "upgraded" from v4 to v5 and some of the formatting is now not happening.
We format a number of columns at the start of our process.
Loop through the data and assign values to cells.
While looping we track certain values as a trigger for creating subtotal rows which we format on a cell basis.
The formatting of the subtotal rows works fine but the formatting of all other column values does not work.
This is how we are formatting the columns
XLS.CmdFormat.BeginEdit(XLS[SheetNo]);
XLS.CmdFormat.Number.Format := Format;
XLS.CmdFormat.ApplyCols(ColumnNo, ColumnNo);
Any ideas?
We format a number of columns at the start of our process.
Loop through the data and assign values to cells.
While looping we track certain values as a trigger for creating subtotal rows which we format on a cell basis.
The formatting of the subtotal rows works fine but the formatting of all other column values does not work.
This is how we are formatting the columns
XLS.CmdFormat.BeginEdit(XLS[SheetNo]);
XLS.CmdFormat.Number.Format := Format;
XLS.CmdFormat.ApplyCols(ColumnNo, ColumnNo);
Any ideas?