Conditional formatting. DataBar. Missed fields

Aspose.Cells Product Family
1

Hi,


I can’t find these properties in Aspose.Cells. Could you fix it or show me them, if such properties already exist?
1. Fill
2. Border
3. Border color
4. Bar Direction
5. Negative Value and Axis… - all values from this dialog

I also created screenshots with these fields.
I use Aspose.Cells v7.1.2.0.

Thank you,
Alex Shloma
2

Hi,



Thanks for your posting and using Aspose.Cells.

It will be helpful that you provided us the screenshots with red circles to illustrate this issue.



We have logged your issue in our database. We will look into these features.

If these features exist already, we will provide you a sample code.

In case, these are new features, we will implement them and update you asap…

This issue has been logged as CELLSNET-40519.

3

Hi,


It is to inform you that these are advanced features since Ms-Excel 2010.



We will support them later.

4

Hi,

Please download and try this fix: Aspose.Cells for .NET

v7.3.0.1

These fields have been completed.

  1. Fill
  2. Border
  3. Border color
  4. Bar Direction
  5. Negative Value and Axis.

Please see the sample code below

C#

Workbook _book = new Workbook();

Worksheet _sheet = _book.Worksheets[0];

FormatConditionCollection conds = GetFormatCondition(“E3:G4”, Color.LightGreen,_sheet);

int idx = conds.AddCondition(FormatConditionType.DataBar);

FormatCondition cond = conds[idx];

cond.DataBar.BarFillType = DataBarFillType.DataBarFillSolid;

cond.DataBar.BarBorder.Type = DataBarBorderType.DataBarBorderSolid;

cond.DataBar.BarBorder.Color = Color.Plum;

cond.DataBar.NegativeBarFormat.ColorType = DataBarNegativeColorType.DataBarColor;

cond.DataBar.NegativeBarFormat.Color = Color.White;

cond.DataBar.NegativeBarFormat.BorderColorType = DataBarNegativeColorType.DataBarColor;

cond.DataBar.NegativeBarFormat.BorderColor = Color.Yellow;

cond.DataBar.AxisColor = Color.Red;

cond.DataBar.AxisPosition = DataBarAxisPosition.DataBarAxisMidpoint;


5
Works fine.

Thank you,
Alex Shloma
6

Hi,



Thanks for your feedback.



It’s good to know your issue is resolved with latest fix.



If you face any other issue, please feel free to post, we will help you asap.

7

The issues you have found earlier (filed as CELLSNET-40519) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.
8

The issues you have found earlier (filed as CELLSNET-40519) have also been fixed in this latest release (Aspose.Cells for Java).

Download it if you need the functionality in Java version.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.