Apply MS Excel Advanced Filter to Display Records & Tile Picture as Texture in Shape

What is new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android via Java 17.9.0 . This release includes a number of new features, enhancements and several bug fixes that further improve the overall stability and usability of the API. Aspose.Cells supports image tiling feature which allows users to display images that are too large to be displayed entirely as a single unit on a typical computer. The feature allows users to display by segmenting it into smaller, more manageable image tiles. Sometimes, developers need to embed formula in Smart Markers. Aspose.Cells allows to make use of Formula parameter in Smart marker field. Microsoft Excel allows users to apply Advanced Filter on worksheet data to display records that meet complex criteria. Users can apply Advanced Filter with Microsoft Excel via its Data > Advanced command. Aspose.Cells also allows to apply the Advanced Filter using the Worksheet.advancedFilter() method. Aspose.Cells can import data to worksheet from ResultSet object which can be created from any database. However, the following article specifically creates ResultSet object from Microsoft Access Database. If users are using Microsoft Excel in Russian Locale or Language or any other Locale or Language, it will display Errors and Boolean values according to that Locale or Language. Users can achieve the similar behavior of Microsoft Excel using Aspose.Cells with the GlobalizationSettings class. Numbers is a spreadsheet application developed by Apple Inc. Aspose.Cells can read Numbers spreadsheet but it does not support writing to it. It can read Numbers spreadsheet’s Data, Style and Formulas. When saving to PDF or image, Aspose.Cells will first try to use Workbook’s default font. This behavior can be changed using DefaultFont attribute in PdfSaveOptions/ImageOrPrintOptions. Most of the time, paper size of the worksheet is automatic. When it is automatic, it is often set as Letter. Sometime user sets the paper size of the worksheet as per their requirements. In this case, the paper size is not automatic. Users can find if the worksheet paper size is automatic or not using a method. If the sheet is empty, then Aspose.Cells will not print anything when users export worksheet to image. When users save your Excel file to HTML, then Aspose.Cells reveal Downlevel Conditional Comments. These conditional comments are mostly relevant to old versions of Internet Explorer and are irrelevant to modern Web Browsers. Aspose.Cells provides a new method that users can use to add digital signature to an already signed Excel file. Aspose.Cells allows users to copy VBA project from one Excel file into another Excel file. VBA project consists of various types of modules i.e. Document, Procedural, Designer etc. All modules can be copied with simple code but for Designer module, there is some extra data called Designer Storage needs to be accessed or copied. When there are multiple shapes present in the same location then how will they be visible is decided by their z-order positions. Aspose.Cells provides Shape.toFrontOrBack() method which changes the z-order position of the shape. If users want to send shape to back users will use negative number like -1, -2, -3 etc. and if users want to send shape to front, users will use positive number like 1, 2, 3 etc. Users can sort data in the column using custom list. This can be done using a new method. However, this method works only if the items in custom list do not have commas inside them. If they have commas like “USA,US”, “China,CN” etc., then users must use DataSorter.addKey(int key, SortOrder order, String[] customList) method. Named Destinations are special kinds of bookmarks or links in PDF that do not depend on PDF pages. It means, if pages are added or deleted from PDF, bookmarks may become invalid but named destinations will remain intact. An Excel file may contain external resources e.g. linked images or objects. When users convert an Excel file to Pdf, Aspose.Cells retrieves these external resources and renders them to Pdf. But sometimes, users do not want to load these external resources and more than that, users want to manipulate them. This release includes plenty of improved features and bug fixes as listed below

- Add a property to indicate whether to output an empty page or not when there is nothing to print
- Support Advanced Filter (MS Excel) feature to display records that meet a complex criteria
- Cell width shown in the resulted PDF is not the same as in the Excel file when using the "Show formula" feature
- Implementing Named Destination when rendering to PDF output (Bookmark query)
- ResultSet imports zero instead of null value in XLSX file
- CellsHelper.setSignificantDigits() should not be (global) static function
- InterruptMonitor takes more time to interrupt the Workbook saving process for a large file having PivotTable
- Formula is not displayed in the resulted PDF
- WEEKDAY formula returns wrong value on workbook formula calculation
- Have to enumerate all shapes to set the Z-Order of the shape properly
- Set name of ActiveX Control (ListBox)
- PivotTable issues(missing rows, pivot field headers printed twice, Date converted to numeric values, etc.) for HTML rendering
- Extra characters present in HTML output of Excel file
- Image does not get displayed in the output HTML when - HtmlSaveOptions.setExportHiddenWorksheet is set to false
- HTML could not be converted to Excel file properly
- Issue with HTML table to Excel rendering
- Issue with calculating Print Area when specifying formulas
- Chart does not get updated if it exists in separate sheet
- Cell value is appended at the start when we click on an existing cell (having some value)
- When XLSX is saved as PDF, the words are mirrored
- Extra characters present in output PDF/image of Excel file
- Bars are missing in Bar chart's PDF output
- Chart image is wrong in the output HTML
- Image of the chart is incorrect in the output HTML
- Content is missing when Excel Chart is converted to PDF
- Chart's PDF has wrong date format of x-axis labels
- Incorrect Y-axis scaling in the output PDF
- Style/formatting is wrong when save to HTML
- Option to compress images is not preserved on opening and saving the Excel file
- Background color of cells in File2 gets changed on opening and saving Workbook
- Background color of cells in File1 gets changed on opening and saving Workbook
- Excel formula cell becomes non-formula cell when setting text for the shape
- Workbook.getFonts() shows additional font after reloading the same spreadsheet
- Some shapes are distorted and changed in Excel to PDF rendering
Mdashes and ndashes inserted into TextBoxes in charts are not rendered properly in chart's PDF
- Wrong results when using SUMIFS formulas
- Aspose.Cells is unable to calculate the value of cell B4 of Calculations worksheet
- Weird result when converting from Excel to PDF or PDF/A using threads
- Changes to comment author field are not preserved
- Wrong IconSet returned
- Chart's background is missing after setting a picture's data
- Aspose.Cells is not able to convert the HTML file correctly while MS-Excel is able to convert it properly
- For Number 39 MS Excel formats negative value with '-' instead of '()' for Italy
- Label text is displaced for the Pie chart
- Various styles of the Waterfall chart don't render properly.
- The Waterfall chart always shows connection lines
- Shape is not updated with correct value
- Excel to PDF conversion hanged for an XLSX file
- Unable to import XLSB file (by Aspose.Cells APIs) into MS-Access database
- HTML output of Excel document contains hash values instead of actual values
- Saving "2.2 CompleteEmail.html" to Xlsx format generates corrupt file
- Loading "2.1 CompleteEmail.html" in Workbook object throws NullPointerException
- Workbook Calculation is wrong for Lookup Excel formula
- Array formula in the sheet is calculated differently via Aspose.Cells
- Incorrect Hyperlinks and PDF content
- Rendering - Chart image is not correct
- Category axis labels are missing when converting Excel to Pdf
- Color of Negative Bars is not correct when Excel is converted to Pdf
- Bar color changed while converting Excel to PDF when using setCrossAt()
- Value of major units of axis in the chart is returned wrong
- Datalabels from cell range are not coming when exported to Pdf
- Missing Datalabels for a Series which is having Bar Values as 100
- Chart is Blank in the output PNG
- Chart is Blank in the output PDF
- Character references parsed incorrectly by Aspose Cells
- Copying workbook and then saving corrupts the output Excel file

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.

- Tile Picture as a Texture inside the Shape
- Output Blank Page when there is Nothing to Print

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 via Java
- Download Aspose.Cells for Android via Java
- Online documentation of Aspose.Cells for Android via Java

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
Aspose - The .NET and Java component publisher
[email protected]
Phone: 888.277.6734
Fax: 866.810.9465