Axolot Data

Hi,

when I first define the borders inside a cell-range, and then fill the range afterwards, the vertical and horizontal borders inside are lost.
(I'm evaluating the Trial-Version at the moment.)

Code:

FRange.BorderTopStyle := _XlsBorderStyle[AValue];
FRange.BorderLeftStyle := _XlsBorderStyle[AValue];
FRange.BorderBottomStyle := _XlsBorderStyle[AValue];
FRange.BorderRightStyle := _XlsBorderStyle[AValue];
FRange.BorderInsideHorizStyle := _XlsBorderStyle[AValue];
FRange.BorderInsideVertStyle := _XlsBorderStyle[AValue];

and then

FRange.FillPatternForeColor := SHADING_COLORS[AVAlue];

or

FRange.FillPatternBackColor := SHADING_COLORS[AVAlue];

This is not the same behaviour like Excel, right?
Is this a bug, or am I doing it wrong?

Thanks a lot.

With kind regards,
Ricardo Angeli

Hello

Yes, the borders inside will be lost. Use BorderInsideXXX properties in order to set them.


Lars Arvidsson