[ANN] Excel Library 1.4.0 - New Conditional Highlighting commands and more

zryip theSlug zryip.theslug at gmail.com
Wed Aug 17 17:56:28 EDT 2016


Dear LiveCode and Excel Users,


The Excel Library 1.4 Commercial Version is released!


In this version we have:


1. 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.


2. Some changes:

- The Excel VB or AS codes is no longer compressed in the custom
properties for avoiding a cross platform 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. (Macintosh)


3. 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)



For more informations about this Library you can visit our website:
http://www.aslugontheroad.com/ourproducts/14-excel-library-for-livecode


The Excel Lib Commercial Version is also available in the LiveCode Store:
https://livecode.com/products/thirdparty/aslugontheroad/excel-library-1-3-3/


Best Regards,
-- 
Zryip TheSlug
http://www.aslugontheroad.com




More information about the use-livecode mailing list