Cell borders in default format do not work

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
jleg
Posts: 11
Joined: Thu Apr 04, 2013 12:04 pm
Location: France

Cell borders in default format do not work

Post by jleg »

Hello,

If you take your FormatCells sample and add the following lines in the btnDefaultFormatClick event, the borders never appear (i use XLS.Version := xvExcel97).

Code: Select all

  // Create second default format.
  XLS.CmdFormat.BeginEdit(Nil);
  XLS.CmdFormat.Fill.BackgroundColor.RGB := $FF1010;
  XLS.CmdFormat.Font.Name := 'Arial';
  XLS.CmdFormat.Font.Color.IndexColor := xcWhite;
  XLS.CmdFormat.Border.Color.IndexColor := xcBlack;  <= line added for testing borders
  XLS.CmdFormat.Border.Style := cbsThick;     <= line added for testing borders
  XLS.CmdFormat.Border.Preset(cbspOutline);   <= line added for testing borders
  XLS.CmdFormat.AddAsDefault('F2');
If i comment the "Preset" line, i get the same result (no border).
So what is the way to set borders in default formats ?

Thanks for your help.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Cell borders in default format do not work

Post by larsa »

Hello

This is fixed in update 5.10.17
Lars Arvidsson, Axolot Data
jleg
Posts: 11
Joined: Thu Apr 04, 2013 12:04 pm
Location: France

Re: Cell borders in default format do not work

Post by jleg »

Great, it's ok now.
Thank you very much.
Post Reply