Conditional Formating

[cherniak]

Hello I'm trying to use Conditional Formating
I'm using Borland C++ Builder and XLSReadWriteII 3.0

My sorse code is following:
//**********************************************************************************************************************************//
XLS->Sheet[0]->FillRandom("A1:I10",300); //Add somw random numbers

XLS->Sheet[0]->ConditionalFormats->Add();
XLS->Sheet[0]->ConditionalFormats->Add()->Areas->Add(0,0,9,9);
XLS->Sheet[0]->ConditionalFormats->Add()->Condition1->Formula1="100";
XLS->Sheet[0]->ConditionalFormats->Add()->Condition1->Formula2="200";
XLS->Sheet[0]->ConditionalFormats->Add()->Condition1->CompOperator=coBetween;
XLS->Sheet[0]->ConditionalFormats->Add()->Condition1->FmtPattern->ForeColor=xcRed;
//**********************************************************************************************************************************//

In output XLS sheet it fills A1:I10 with random values from 0 to 300, but it does not do any frmating (does not color in red cells with values between 100 and 200)
What i'm doing wrong ??

[larsa]

Hello

For every call to Add(), you adds a new conditional format, so at the end you have added six.
Here is a working delphi sample:

var
CondFmt: TConditionalFormat;
begin
XLSBook.XLS.Sheet[0].FillRandom('A1:I10',300); //Add somw random numbers

CondFmt := XLSBook.XLS.Sheet[0].ConditionalFormats.Add();
CondFmt.Areas.Add(0,0,9,9);
CondFmt.Condition1.Formula1 := '100';
CondFmt.Condition1.Formula2 := '200';
CondFmt.Condition1.CompOperator := coBetween;
CondFmt.Condition1.FmtPattern.ForeColor := xcRed;
end;

[cherniak]

OK,
But how to apally it for C++?
Can you give me code example ?

[larsa]

Hello

Sorry, I don't have C++ installed, but assigning a value to a variable, and then use the variable, is just basic C++ programming.

[cherniak]

sorry but it does not work.
If you find some kind of example in C++
it would be grate help

many thx .

[cherniak]

!