Axolot Data

Posted: **Mon Dec 01, 2014 3:45 pm**

Hi

Changed all old code to cmdFormat code except:

      R := FSheet.Range.Items[FFirstColumn + i, FCurrentRow, FFirstColumn + i, FCurrentRow];
      R.WrapText := True;
      R.VertAlignment := cvaTop;

      R := FSheet.Range.Items[FFirstColumn + i, FCurrentRow, FFirstColumn + i, FCurrentRow];
      R.BorderTopStyle := cbsThin;
      R.BorderTopColor := clBlack;

How can i do this using cmdFormat. Could not find it in example

Eric

Posted: **Fri Dec 05, 2014 9:05 am**

Hello

Example

Code: Select all

  XLS.CmdFormat.Alignment.WrapText := True;
  XLS.CmdFormat.Alignment.Vertical := cvaTop;

FormatCells sample explains how to format borders.

Axolot Data

Wraptext and BorderTopStyle

Wraptext and BorderTopStyle

Re: Wraptext and BorderTopStyle