The Excel Library 1.4.0 Commecial version is now released.
This version includes 4 new commands and 2 functions.
- XCEL_FormatCondition_Count: Counts the number of format conditions attached to a range.
- XCEL_FormatCondition_New: Creates a new format condition linked to a range.
- XCEL_FormatCondition_Delete: Deletes a format condition.
- XCEL_FormatCondition_Property_Set: Sets one of the format condition properties.
- XCEL_Application_Path_Set (Macintosh only) Allows the possibility to define the full path of the MS Excel application to control. Useful if several versions of MS Excel are installed on the computer.
- XCEL_Range_HyperLink_Address_Get: Returns the address of the first hyperlink attached to the specified cell.
Some changes:
- The Excel VB or AS codes is no longer compressed in the custom properties for avoiding a crossplatform problem.
- A description for the XCEL_Range_Rect_Get function has been added in the documentation.
- In the documentation we have now a new "Parameters" button. This button allows to set the path of the MS Excel application to use with the documentation. The selected path is stored in a preferences file, outside of the documentation.
And fixes:
- Quotes in formulas could cause the XCEL_Range_Formula_Set command was not working properly on windows, with no error returned in 'the result'.
- Quotes could cause errors with the XCEL_Range_Values_Get function (Macintosh)
Library registred's Users can download the new version in the Commercial section of the website.