Hi,
I created a simple *.xlsx document and converted it to *.xls by Excel 2010.
Here is base block of code, that used in all samples:
gXl = new Workbook(fName);
foreach (Worksheet ws in gXl.Worksheets)
{
foreach (FormatConditionCollection fcc in ws.ConditionalFormattings)
{
for (int i = 0; i < fcc.Count; i++)
{
FormatCondition fc = fcc[i];
// Checking type of current object to print valid fields
// Here we call code from samples
}
}
}
1. Type - ColorScale (Excel: Format all cells based on their values - 2 - Color Scale).
Type - Number
Value:
*.xlsx - ‘=0’
*.xls - ‘0’
Such type of value has the same incompatibilities in the other rules.
Cell in the attached document (Sheet1): A2
Code:
ConditionalFormattingValue cfv;
cfv = fc.ColorScale.MinCfvo;
printLine(“Value”, cfv.Value.ToString(), SPACE4); // my inner printing method
2. Type - ColorScale (Excel: Format all cells based on their values - 2 - Color Scale).
Type - Number
Value:
*.xlsx - ‘=$A$2’
*.xls - ‘=Sheet1!$A$2’
Such type of value has the same incompatibilities in the other rules.
Cell in the attached document (Sheet1): A4
Code:
ConditionalFormattingValue cfv;
cfv = fc.ColorScale.MinCfvo;
printLine(“Value”, cfv.Value.ToString(), SPACE4); // my inner printing method
3. Type - IconSet (Excel: Format all cells based on their values).
Type:
*.xlsx - TrafficLights32
*.xls - Signs3
Range of cells (Sheet1): [G5:K5]
A vice versa problem in range (Sheet1): [G6:K6]
Code:
printLine(“Type”, Enum.GetName(typeof(IconSetType), fc.IconSet.Type), SPACE3); // my inner printing method
4. Type - CellValue (Excel: Format only cells that contain - Cell Value).
Operator:
*.xlsx - GreaterOrEqual
*.xls - GreaterThan
Cell in the attached document (Sheet2): A7
Code:
printLine(“Operator”, Enum.GetName(typeof(OperatorType), fc.Operator), SPACE3); // my inner printing method
5. Type - TimePeriod (Excel: Format only cells that contain - Dates Occurring).
TimePeriod:
*.xlsx - NextMonth
*.xls - ThisMonth
Cell in the attached document (Sheet2): E10
Code:
printLine(“TimePeriod”, Enum.GetName(typeof(TimePeriodType), fc.TimePeriod), SPACE3); // my inner printing method
6. Type - DuplicateValues (Excel: Format only unique or duplicate values).
Type:
*.xlsx - DuplicateValues
*.xls - Expression
Cell in the attached document (Sheet3): E1
Code:
printLine(“Type”, Enum.GetName(typeof(FormatConditionType), fc.Type), SPACE2); // my inner printing method
I use Aspose.Cells v7.1.2.0.
Thank you,
Alex Shloma