Page 1 of 1

XlsReadWriteII5 cell FontName

Posted: Sun Dec 06, 2015 8:50 am
by cakmakb
Hi

i use single cell code, Font not changed, font size ok.

Code: Select all

  XLS[0].AsFloat[2, 3] := 125.5;
  XLS[0].Cell[2, 3].FillPatternForeColorRGB := $AFAFAF;
  XLS[0].Cell[2, 3].NumberFormat := '0.000';
  XLS[0].Cell[2, 3].BorderLeftStyle := cbsThick;
  XLS[0].Cell[2, 3].BorderLeftColor := xcRed;
  XLS[0].Cell[2, 3].BorderRightStyle := cbsThick;
  XLS[0].Cell[2, 3].BorderRightColor := xcRed;
  XLS[0].Cell[2, 3].BorderTopStyle := cbsThick;
  XLS[0].Cell[2, 3].BorderTopColor := xcRed;

  XLS[0].Cell[2, 3].BorderBottomStyle := cbsThick;
  XLS[0].Cell[2, 3].BorderBottomColor := xcRed;

  XLS[0].Cell[2, 3].FontName := 'Verdana'; //Font not change verdana, 
  XLS[0].Cell[2, 3].FontSize := 50;  //size ok.

  XLS[0].Cell[2, 3].WrapText := true;

  XLS[0].AsString[0, 0] := 'Kфvаgт Kаlmаn';
  XLS[0].Cell[0, 0].FontName := 'Verdana'; //Font not change verdana, 
  XLS[0].Cell[0, 0].FontSize := 50;  //size ok.


Re: XlsReadWriteII5 cell FontName

Posted: Tue Dec 08, 2015 11:53 am
by Noemie
Dear cakmakb,

I got the exact same problem as you. Did you find any solution to change the font of only one cell?

Thanks a lot.

Noémie

Re: XlsReadWriteII5 cell FontName

Posted: Wed Dec 09, 2015 12:48 pm
by larsa
Hello

This is fixed in update 5.20.66