Dear LiveCode and MS Excel Users,
The Excel Library 1.1 is now available for our Registred Users. What we have for you in this version? 1. Pivot Table commands As announced in a previous RevUp article, we have added our first commands for supporting the MS Excel's Pivot Table object. In this version we have 7 commands and 1 function for controlling the Pivot Table object: - XCEL_PivotTable_New: creates a new Pivot Table - XCEL_PivotTable_Exists: returns true if the Pivot Table exists - XCEL_PivotTable_Delete: deletes a Pivot Table - XCEL_PivotTable_Refresh: refreshes a Pivot Table - XCEL_PivotTable_Style_Set: defines the style of the Pivot Table report - XCEL_PivotTable_Fld_Define: defines a Pivot Table field category among the following categories: filter, row, column or value - XCEL_PivotTable_Fld_Position_Set: defines the order of a Pivot Table field among a category - XCEL_PivotTable_Item_Visible_Set: shows or hides a Pivot Table item in a category All these commands are described in the Library documentation. Plus, a dedicated section allows to experiment the main new commands. http://www.aslugontheroad.com/images/Preview/Excel_Lib_Preview/pivottable_doc_preview.png 2 Two new functions are also available: - XCEL_Worbook_Exists - XCEL_Sheet_Exists 3. And two bugs have been fixed: - A bug with commands using 2 similar kinds of object (2 ranges, 2 sheets, etc). The second object was using the same definition than the first object. Example with 2 ranges: if the first range was defined to be in sheet 1 and a second range was defined to be in sheet 2, the second range was declared to be in sheet 1 (the sheet defined for the first range). - XCEL_Sheet_New (Macintosh) is now returning the new sheet name without quotes. The Commercial version of the Library contains now more than 190 commands compatible with Windows and Macintosh. All the vocabulary is fully detailed in the Library Documentation. If you want to support the development and have interest in the Library, please consider to purchase the Commercial version in the LiveCode Store: http://livecode.com/store/marketplace/excel-library Depending of the number of copies sold, we will decide to explore the possibility of a MS Word and MS Powerpoint library. As we have nothing to hide, the Open Source version 1.0 of our Library is still available in our webiste under GPL license, by following this link: http://www.aslugontheroad.com/download/category/5-open-sources You can freely evaluate our work and / or use the library in your non-commercial projects. Best Regards, -- Zryip TheSlug http://www.aslugontheroad.com _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
