Author Archives: Amjad Sahi

Add Conditional Formatting Icons with Cell Text using Aspose.Cells for Java 7.5.2

Posted on August 15, 2013 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Java 7.5.2. We include some useful enhancements in the new release. For example, you may add conditional icons set (images) with your data to make it more meaningful. You may also auto-resize the textbox control based on the text or contents. The component now allows you to create a CellArea by using “$” included in the cell address.

This release is also a maintenance release that contains enhancements and fixes … Continue Reading

Posted in Aspose.Cells Product Family | Tagged Microsoft Excel, conditional data, java, maintenance release, product release

Custom Data Sorting Supported and Other Enhancements in Aspose.Cells for .NET 7.5.2

Posted on August 13, 2013 by Amjad Sahi

Aspose.Cells for .NET 7.5.2 has been released. The new release supports adding custom data sorting. We have added some significant enhancements for copying ranges with conditional formatting and clearing the Textbox collection. We have fixed a few exceptions when reading and writing Excel files, and writing legend entries in charts.

In this release, several important issues have been addressed. For example, issues around rendering Microsoft Excel file formats, rendering and manipulating PivotTables, converting Excel files to HTML format, adding background … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, Microsoft Excel, maintenance release, product release

Excel API for Android – Create, Edit or Convert Excel Files in Android

Posted on August 6, 2013 by Amjad Sahi

Aspose.Cells for Android is a Microsoft Excel spreadsheet component that allows you to develop android applications for reading, writing and manipulating Microsoft Excel spreadsheets (XLS, XLSX, XLSM, SpreadsheetML, CSV, tab-delimited) and HTML file formats without needing to rely on Microsoft Excel.

Aspose.Cells for Android is a scalable and feature-rich component that offers many functions that are way beyond the simple data exporting capabilities of other vendors. With Aspose.Cells for Android, developers can export data, format spreadsheets to the most granular … Continue Reading

Posted in Aspose.Cells Product Family | Tagged Android Excel API, Convert Excel file in Android, Create Excel file in Android, Edit Excel file in Android, Microsoft Excel

Insert a Picture Based on Cell Reference in Excel using Java

Posted on July 15, 2013 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Java 7.5.1. In this release, we supported inserting pictures based on cell references in a worksheet. The data in the picture is reflected accordingly when you update the source cells range. You can now also detect a category number’s formatting type via the Cell.getNumberCategoryType() method. We have fixed an issue regarding JDK1.7 versions for chart to image, sheet to image, and Excel to PDF rendering.

Several … Continue Reading

Posted in Aspose.Cells Product Family | Tagged Microsoft Excel, category type, data range, java, picture, product release

Retrieve Conditional Formatting Objects in Excel using C#

Posted on July 15, 2013 by Amjad Sahi

Aspose.Cells for .NET 7.5.1 has been released. The new release includes a useful feature to get icon sets, data bars or color scales objects used when adding conditional formatting to a cell or a range of cells. We have also added support for rendering a worksheet’s background in an output HTML file. The component also supports parsing custom views and scenarios while converting from one Microsoft Excel file format to another.

Moreover, we have improved the Excel to PDF … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, HTML, Microsoft Excel, PDF, conditional formatting, product release, rendering

Aspose.Cells for SharePoint 3.0.2 Enhances Searching in Excel Documents

Posted on July 2, 2013 by Amjad Sahi

We are happy to announce Aspose.Cells for SharePoint 3.0.2. In this release, we have provided enhanced support for the searching in a document feature. We have also included some other enhancements and fixes: we have fixed an issue regarding setting license using Aspose.Total.SharePoint.License.wsp, and we have fixed an issue regarding an interface in SharePoint. We’ve also fixed an issue that occurred when using the search feature in the Action… Continue Reading

Posted in Aspose.Cells Product Family | Tagged Microsoft Excel, SharePoint, product release, searching

Aspose.Cells for JasperReports 1.1.3 supports JasperReports Server 5.1

Posted on June 25, 2013 by Amjad Sahi

We have published Aspose.Cells for JasperReports 1.1.3. In this version, we provide support for JasperReports 5.1. We have also fixed some internal bugs and added other fixes.

Download URL: http://www.aspose.com/community/files/67/jasperreports-exporters/aspose.cells-for-jasperreports/entry475864.aspx… Continue Reading

Posted in Aspose.Cells Product Family | Tagged JasperReports Server 5.1, Microsoft Excel, jasperreports, product release

Improved Support for Fonts in Image Rendering and Enhanced Performance Reading Large Excel Files in Aspose.Cells for Java 7.5.0

Posted on June 7, 2013 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Java 7.5.0. This maintenance release contains enhancements and fixes for the issues reported in earlier versions. In this release, we have provided support to fonts in rendering image files when the required font is not found. We also resolved an issue caused by JBOSS for mixed cases Java classes for the users. Several other important issues have been addressed. For example, issues around rendering Microsoft Excel files, rendering … Continue Reading

Posted in Aspose.Cells Product Family | Tagged Microsoft Excel, java, maintenance release, performance, product release, rendering

Insert a Picture Based on Cell Reference in Excel using C#

Posted on June 7, 2013 by Amjad Sahi

Aspose.Cells for .NET 7.5.0 has been released. The new release includes a useful feature to add a picture based on your desired range of cells as its data source. We have added some significant enhancements for shading a style’s fill effect for cells, opening CSV files with values longer than 32K in the cells and copying table and list object formulas accordingly when inserting new rows. We have fixed a few exceptions when refreshing PivotTable, saving to HTML and … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, CSV, Microsoft Excel, insert, picture, product release

Important fixes to cell formatting, rendering PivotTables and charts in Aspose.Cells for Java 7.4.3

Posted on April 25, 2013 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Java 7.4.3. This hotfix is a maintenance release that contains fixes regarding issues reported in earlier versions. In the new release, several important issues have been addressed. For example, issues around formatting cells, rendering PivotTables and charts, rendering Microsoft Excel files and rendering image files from charts/worksheets have been resolved. Issues pertaining to the formula calculation engine have also been fixed.

To see a complete list of enhancements and fixes … Continue Reading

Posted in Aspose.Cells Product Family | Tagged Microsoft Excel, hotfix, java, maintenance release, product release, rendering