Conditional formatting. IconSetType. Missed values

Aspose.Cells Product Family
1

Hi,


Excel 2010 has new IconSets (http://msdn.microsoft.com/en-us/library/ff194938.aspx).
xl3Stars
xl3Triangles
xl5Boxes
xlCustomSet

Formatting rules with these types don’t load.
I use Aspose.Cells v7.1.2.0.

Thanks,
Alex Shloma
2

Hi,

Thanks for your posting and using Aspose.Cells.

We have logged your issue in our database.

Development team will look into this issue and once we get some update or fix, we will let you know asap.

This issue has been logged as CELLSNET-40520.

3

Hi,

Thanks for using Aspose.Cells for .NET.

We have looked into your issue and found these are advanced features since Ms-Excel 2010.

We cannot support them soon and will try to support them in near future.

Once, these features are supported, we will let you know asap.

4

Hi,

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

v7.3.0.1

Xl3Stars,xl3Triangles,xl5Boxes:

You can load these Formatting Rules with the following 3 types

  1. IconSetType.Stars3
  2. IconSetType.Triangles3
  3. IconSetType.Boxes5

xlCustomSet:

This formatting rule has not yet been completed.

5

Hi,


Works as expected! But what about
xlCustomSet type? Should we create new ticket? Or this type will be implemented soon?

Thanks,
Alex Shloma
6

Hi,


As we declared in our previous reply, “IconSetType.xlCustomSet” is not yet supported. Once we support it, we will let you know. Moreover, you don’t need to start a new thread for it. Once it is supported, your issue would be declared as “Resolved”.

Thank you.
7
Hi,

Kindly give us an Excel file (manually created in MS Excel) to demonstrate the xlCustomSet conditional formatting's IconSet enumeration member with details as we need it for analysis. Hopefully, we can support this soon after obtaining the required Excel file from you to investigate it thoroughly.

Thank you.

8

Hi,


Please select one of the standard IconSet types and change one or more of it icons (see attached image). Sample Excel file is also attached.

Thanks,
Alex Shloma
9

Hi,

Thanks for your sample file and screenshot explaining the xlCustomSet conditional formatting’s IconSet enumeration member.

It will be helpful in implementing this feature. We have logged it in our database.

Once, there is some update for you, we will let you know asap.

10

Hi,

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

xlCustomSet:

This formatting rule has completed. See the following code for an example.

C#


Workbook _book = new Workbook();

Worksheet _sheet = _book.Worksheets[0];


int index = _sheet.ConditionalFormattings.Add();


FormatConditionCollection formatConditions = _sheet.ConditionalFormattings[index];


CellArea area = GetCellAreaByName(“H23:J25”);

formatConditions.AddArea(area);


int idx = formatConditions.AddCondition(FormatConditionType.IconSet);

FormatCondition cond = formatConditions[idx];

cond.IconSet.Type = IconSetType.ArrowsGray3;


ConditionalFormattingIcon cfIcon = cond.IconSet.CfIcons[0];

cfIcon.Type = IconSetType.Arrows3;

cfIcon.Index = 0;


ConditionalFormattingIcon cfIcon1 = cond.IconSet.CfIcons[1];

cfIcon1.Type = IconSetType.ArrowsGray3;

cfIcon1.Index = 1;


ConditionalFormattingIcon cfIcon2 = cond.IconSet.CfIcons[2];

cfIcon2.Type = IconSetType.Boxes5;

cfIcon2.Index = 2;

11

Hi,


All works fine!

Thanks,
Alex Shloma
12

Hi,

Thanks for your feedback.

It’s good to know that this feature is implemented now and working fine.

Let us know if you encounter any other problem, we will be glad to assist you.

13

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

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

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

Download it if you need the functionality in Java version.