Filter Data Type While Loading Spreadsheets & ActiveX Controls Support in Android Apps
It has provided the ability to add & manipulate the ActiveX Controls in spreadsheets. It Updates References while Deleting Blank Rows & Columns and provide the ability to export spreadsheet contents in HTML format as per the standards opted by Excel apps. Moreover, it allows refreshing OleObject’s image if the contents/data of underlying object has been changed, allowing get/set comments for an instance of ListObject, specifying default font name for rendering spreadsheets in image formats.
Lane Cove, Australia, August 14, 2016 --(PR.com)-- What’s new in this release?
Aspose development team is pleased to announce the new release of Aspose.Cells for Android v8.9.0. Aspose.Cells APIs have provided the ability to add & manipulate the ActiveX Controls in spreadsheets. Aspose.Cells for Android API has exposed a number of useful classes, enumerations and methods to fully support the ActiveX Controls. The most worth mentioning addition to the public API is the ShapeCollection.addActiveXControl method which allows adding an ActiveX Control to the collection of shapes by accepting 7 parameters to specify the control type, location to place the control and size of the control. As per default behavior, the APIs load everything from the template file into its own object model, providing access to every aspect of the spreadsheet. There could be scenarios where the user does not want to load everything but specific objects, such as charts or shapes. The APIs have added the enumeration which can be used to make the selection of data type to be loaded from the template file. Filtering data at the time of loading can improve the performance tremendously, especially when used with LightCells APIs. As per default behaviour, Aspose.Cells APIs delete the blank rows & columns without updating the cell references that may have been effected from the delete process. This could lead to undesired results in certain cases, especially when the spreadsheet contains formulas or charts. Aspose.Cells APIs have tried to overcome the aforementioned situation by exposing the overloaded versions of the Cells.deleteBlankRows & Cells.deleteBlankColumns methods with the release of Aspose.Cells for Android. It has now provided the ability to export spreadsheet contents in HTML format as per the standards opted by Excel application. If a spreadsheet is converted to HTML using the Excel application, it does not render the grid lines. Aspose.Cells APIs behave in the same way using its default settings, however, with this release of the API, the developers can now choose to render the grid lines as well. It has exposed the OleObject.AutoLoad property which allows refreshing the OleObject’s image if the contents/data of the underlying object has been changed. Aspose.Cells APIs now allow to get and set the comments for an instance of ListObject. It has provided the ability to specify the default font name for rendering the spreadsheets in image formats. The DefaultFont property is of type System.string with default value as null. The said property can be used when Unicode characters in the spreadsheet have not been formatted with the appropriate font in the cell’s style, consequently such characters may appear as blocks in the resultant images. It is advised to set the DefaultFont property to MingLiu or MS Gothic to properly show the Unicode characters in the resultant images. If the DefaultFont property is not set, Aspose.Cells for Android API will use the system’s default font to show the Unicode characters. This release has exposed the DefaultFontName property for the HtmlSaveOptions class that allows specifying the default font name while rendering spreadsheets to HTML format. The default font will be used only when a particular font used to style some contents in the spreadsheet does not exist on the machine where conversion process has to take place. The default value of HtmlSaveOptions.DefaultFontName property is null that means, Aspose.Cells for Android API will use the universal font which has the same family with the original font. spose.Cells for Android API has exposed the Boolean type IsExcel2003Compatible property for the PivotTable class which allows to impose or remove the Excel 2003 restrictions for refreshing Pivot Tables. The default value of IsExcel2003Compatible property is true, that means a string must be less than or equal to 255 characters. If the string is greater than 255 characters, it will be truncated. If false, the aforementioned restriction will not be imposed. Aspose.Cells APIs have already provided the facility to render charts to PDF. With this release, the API has exposed another overloaded version of the said method that could accept an instance of OutputStream, allowing the users to save the chart’s PDF in an instance of ByteArrayOutputStream. It also adds the ability to set the shadow as text effects for any shape such as TextBox.
More about Aspose.Cells for Android
- Homepage of Aspose.Cells for Android: http://www.aspose.com/products/cells/android
- Download Aspose.Cells for Android: http://www.aspose.com/downloads/cells/android
- Online documentation of Aspose.Cells for Android: www.aspose.com/docs/display/cellsandroid/Home
Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
http://www.aspose.com/
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465
Aspose development team is pleased to announce the new release of Aspose.Cells for Android v8.9.0. Aspose.Cells APIs have provided the ability to add & manipulate the ActiveX Controls in spreadsheets. Aspose.Cells for Android API has exposed a number of useful classes, enumerations and methods to fully support the ActiveX Controls. The most worth mentioning addition to the public API is the ShapeCollection.addActiveXControl method which allows adding an ActiveX Control to the collection of shapes by accepting 7 parameters to specify the control type, location to place the control and size of the control. As per default behavior, the APIs load everything from the template file into its own object model, providing access to every aspect of the spreadsheet. There could be scenarios where the user does not want to load everything but specific objects, such as charts or shapes. The APIs have added the enumeration which can be used to make the selection of data type to be loaded from the template file. Filtering data at the time of loading can improve the performance tremendously, especially when used with LightCells APIs. As per default behaviour, Aspose.Cells APIs delete the blank rows & columns without updating the cell references that may have been effected from the delete process. This could lead to undesired results in certain cases, especially when the spreadsheet contains formulas or charts. Aspose.Cells APIs have tried to overcome the aforementioned situation by exposing the overloaded versions of the Cells.deleteBlankRows & Cells.deleteBlankColumns methods with the release of Aspose.Cells for Android. It has now provided the ability to export spreadsheet contents in HTML format as per the standards opted by Excel application. If a spreadsheet is converted to HTML using the Excel application, it does not render the grid lines. Aspose.Cells APIs behave in the same way using its default settings, however, with this release of the API, the developers can now choose to render the grid lines as well. It has exposed the OleObject.AutoLoad property which allows refreshing the OleObject’s image if the contents/data of the underlying object has been changed. Aspose.Cells APIs now allow to get and set the comments for an instance of ListObject. It has provided the ability to specify the default font name for rendering the spreadsheets in image formats. The DefaultFont property is of type System.string with default value as null. The said property can be used when Unicode characters in the spreadsheet have not been formatted with the appropriate font in the cell’s style, consequently such characters may appear as blocks in the resultant images. It is advised to set the DefaultFont property to MingLiu or MS Gothic to properly show the Unicode characters in the resultant images. If the DefaultFont property is not set, Aspose.Cells for Android API will use the system’s default font to show the Unicode characters. This release has exposed the DefaultFontName property for the HtmlSaveOptions class that allows specifying the default font name while rendering spreadsheets to HTML format. The default font will be used only when a particular font used to style some contents in the spreadsheet does not exist on the machine where conversion process has to take place. The default value of HtmlSaveOptions.DefaultFontName property is null that means, Aspose.Cells for Android API will use the universal font which has the same family with the original font. spose.Cells for Android API has exposed the Boolean type IsExcel2003Compatible property for the PivotTable class which allows to impose or remove the Excel 2003 restrictions for refreshing Pivot Tables. The default value of IsExcel2003Compatible property is true, that means a string must be less than or equal to 255 characters. If the string is greater than 255 characters, it will be truncated. If false, the aforementioned restriction will not be imposed. Aspose.Cells APIs have already provided the facility to render charts to PDF. With this release, the API has exposed another overloaded version of the said method that could accept an instance of OutputStream, allowing the users to save the chart’s PDF in an instance of ByteArrayOutputStream. It also adds the ability to set the shadow as text effects for any shape such as TextBox.
More about Aspose.Cells for Android
- Homepage of Aspose.Cells for Android: http://www.aspose.com/products/cells/android
- Download Aspose.Cells for Android: http://www.aspose.com/downloads/cells/android
- Online documentation of Aspose.Cells for Android: www.aspose.com/docs/display/cellsandroid/Home
Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
http://www.aspose.com/
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465
Contact
Aspose
Sher Azam
888.277.6734
http://www.aspose.com/
Sher Azam
888.277.6734
http://www.aspose.com/
Contact
Categories