Formatting Columns

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
richard.moore
Posts: 1
Joined: Tue Jan 07, 2014 4:48 am

Formatting Columns

Post by richard.moore »

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?
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Formatting Columns

Post by larsa »

Hello

I can't reproduce this. Tested with update 5.20.11
It the error persists, please provide a complete sample that reproduces the error.
Lars Arvidsson, Axolot Data
Post Reply