• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
  • Mikalai Zaikin

Filter Data Type While Loading Spreadsheets & ActiveX Controls Support in Android Apps

Ranch Hand
Posts: 714
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What is new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android 8.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 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 provide 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 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 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. This release includes plenty of improved features and bug fixes as listed below

- Exporting DataBars based on Conditional Formatting to HTML
- Support ColorScale, DataBar, IconSet while exporting XLSX to HTML
- Worksheet has no method calcualteFormula(String formula, CalculationOptions options)
- Performance bottleneck on Workbook.calculateFormula
- Setting ShowAllItems for PivotField does not seem to take effect
- Text is getting congested and overlapping in the EMF image
- Text labels are overlapping in the EMF image
- Exception is thrown on copying workbook
- Spreadsheet to HTML: Alignment of Text in a Shape is wrong after copying theme from source spreadsheet
- Graph is not rendered in the output PDF
- X-axis labels missing in Chart's PDF
- Incorrect number-format of X-axis labels in Chart's PDF
- Long hyphens don't display appropriately in the output PDF/Image for the chart
- Horizontal Grid-Lines of chart are not appearing properly in PDF
- Few chart bars are missing while rendering worksheet to image
- A named range is created when Cells.copyRow() method is used within a named range
- When applying autoSizeColumns on the sheet, the column is not widened properly
- CellsException while saving spreadsheet to PDF
- Certain data labels are missing while rendering chart to image
- CellsException: Cell has been removed: D9 with
- Exception: "Shape to image Error !" when rendering a worksheet to image
- How to set Legend Entry Properties for Text Options
- Create TextBox in which each line is having different Horizontal Alignment
- Conversion to HTML renders redundant empty rows
- Text alignment is changed after re-saving a template XLS file
- Excel file with DataBars not converted to HTML properly
- Pivot Chart created with Aspose.Cells does not display in Excel 2016 for MAC
- Aspose.Cells appends null at the end of the path for resources HTML
- LightCells APIs only generates events for the first column of the row
- Cell borders appear after resaving XLS
- Logo image is lost while converting XLS to PDF
- Character position is different in the rendered PDF from an XLS file
- Text overlapping when worksheet is converted to EMF on Linux
- Text density and line breaks are different as compared to Excel generated PDF
- Text is getting trimmed and overlapped while rendering spreadsheet to PDF
- Problems rendering chart to PDF
- Opening and saving the Excel file changes the trend lines
- Workbook save twice, the content saved second time will be different from the first time
- Issue with PageBreaks which are not sorted before saving to Excel file
- File corrupt if opened, saved, re-opened and saved by Aspose.Cells APIs
- Chart axis values changed after re-saving an XLS file
- Not getting accurate information about WordArt shape formatting from Aspose.Cells APIs
- Issue with embedded icon - not printing
- Specifying Custom Number Decimal and Group Separators for Workbook doesn't work
- Formula calculation result differs from Excel native calculation
- Checkboxes are not rendering correctly when using SheetRender.toImage() method
- Character orientation is different while rendering to PDF
- Some characters are missing or not pasted right in Excel to PDF conversion
- Some of the DataBar images are blank
- Bars of the graph not aligned properly with cells in PDF
- Misaligned bars after rendering spreadsheet to EMF
- Character spaces problem while rendering spreadsheet to PDF
- Background image is distorted or blurry in the output PDF
- Background image is stretched in output PDF
- Broken external formula references while using Cells.copyColumns
- Corrupted XLSX file after text replace
- Loss of text block in frenchCommonWords.xlsx
- Text Overflow check

Other most recent bug fixes are also included in this release.

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for Android documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.

- Add ActiveX Controls using Aspose.Cells
- Export Excel to HTML with GridLines

Overview: Aspose.Cells for Android

Aspose.Cells for Android is a MS Excel spreadsheet component that allows programmer to develop android applications for reading, writing & manipulate Excel spreadsheets (XLS, XLSX, XLSM, SpreadsheetML, CSV, tab delimited) and HTML file formats without needing to rely on Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, custom charts, spreadsheet formatting, drawing objects like images, OLE objects & importing or creating charts.

More about Aspose.Cells for Android

- Homepage of Aspose.Cells for Android
- Download Aspose.Cells for Android
- Online documentation of Aspose.Cells for Android

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Aspose - The .NET and Java component publisher
Phone: 888.277.6734
Fax: 866.810.9465
Consider Paul's rocket mass heater.
    Bookmark Topic Watch Topic
  • New Topic