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