Conditional formatting. FormatConditionValueType. Missed values

Aspose.Cells Product Family
1

Hi,


I noticed that Excel has 9 types (http://msdn.microsoft.com/en-us/library/ff837624.aspx), but Aspose.Cells has only 6 types.
FormatConditionValueType.Min is used instead of:
xlConditionValueAutomaticMin - The shortest data bar is proportional to the minimum value in the range.
xlConditionValueLowestValue - Lowest value from the list of values.
FormatConditionValueType.Max is used instead of:
xlConditionValueAutomaticMax - The longest data bar is proportional to the maximum value in the range.
xlConditionValueHighestValue - Highest value from the list of values.
One type is missed:
xlConditionValueNone - No conditional value.
I created a simple document with these condition types and got a screenshot. I use Aspose.Cells v7.1.2.0.

Many thanks,
Alex Shloma
2

Hi,

Thanks for your posting and using Aspose.Cells.

Your screenshot and template file will be helpful in sorting out this issue.

We have logged your issue in our database.

We will investigate about these missing values and implement them to match according to Ms-Excel

If there is some workaround available, we will provide it to you.

This issue has been logged as CELLSNET-40521.

3

Hi,


After initial investigation, we found 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


AutomaticMin,AutomaticMax:

Please load these formatting rules with the following types.

  1. FormatConditionValueType.AutomaticMin
  2. FormatConditionValueType.AutomaticMax


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-40521) 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-40521) have also been fixed in this latest release (Aspose.Cells for Java).

Download it if you need the functionality in Java version.