Author Archives: Amjad Sahi

Advanced Conditional Formatting Types of Excel 2010 Supported, Formula Calculation Engine is Improved in Aspose.Cells for .NET 7.3.1

Posted on August 23, 2012 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for .NET 7.3.1. In this release, we have made some valuable enhancements to the advanced conditional formatting types of Microsoft Excel 2007/2010 file formats that were not supported in the product. Moreover, Microsoft Excel 2010’s advanced data validation is now supported. We have also supported data filters in Pivot Tables. We have made several enhancements regarding data series and markers for charts. The auto-shapes rendering in output HTML has also … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, Microsoft Excel, advances conditional formatting, formulas, product release

Apply Themes to Charts in Excel Files using Java

Posted on July 16, 2012 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Java 7.3.0. In this release, we have included some valuable new features, enhancements to existing features and resolution of the reported issues. One of the new features introduced in this release is the ability to open and save MHT files. We have also introduced a feature that lets you apply Microsoft Excel themes and colors to charts. Another one is a long-awaited feature: support for XML maps. The component … Continue Reading

Posted in Aspose.Cells Product Family | Tagged Excel, MHT, java, product release, themes

Read/Write MHTML Files and Apply Themes to Charts in Aspose.Cells for .NET 7.3.0

Posted on July 16, 2012 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for .NET 7.3.0. In this release, we have included some valuable new features, enhancements to existing features and resolution of the reported issues. One of the new features introduced in this release is the ability to open and save MHT files. We have also introduced a feature that lets you apply Microsoft Excel themes and colors to charts. Another one is a long awaited feature: support for XML maps.

Our … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, Excel, MHTL files, product release, themes

Use RegEx Text Search in Excel Spreadsheets using Java

Posted on June 15, 2012 by Amjad Sahi

We’re pleased to share the announcement of Aspose.Cells for Java 7.2.2. We have added a new feature to search text in the cells with Regular Expressions. We have added some other useful enhancements around conditional formatting and OLE embedded in OOXML files. The ExportObjectListener for saving HTML files has been made available in the latest version. We have also fixed a few issues regarding Pivot Tables, data validation and charts.

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

Posted in Aspose.Cells Product Family | Tagged OLE, OOXML, java, pivot tables, product release, regex

Disable Compatibility Checker in Excel and Other Useful Enhancements using Aspose.Cells for .NET 7.2.2

Posted on June 14, 2012 by Amjad Sahi

We’re pleased to share the announcement of Aspose.Cells for .NET 7.2.2. We have added a new feature, disabling Microsoft Excel’s Compatibility Checker in this release. We have also added support for adding quotes around your data when saving to CSV format, as one of our customers asked us to. We have added some other useful enhancements around the Subtotals feature. The XML Map properties will now be retained when re-saving the template file. We have also improved the Formula Calculation … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, Excel, XMP map, calculation engine, compatibility checker, pivot tables, product release

Use Regular Expression for Searching String in Excel using Java

Posted on May 17, 2012 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Java 7.2.1. This month’s release provides support for applying custom formatting and styles to pivot tables. We have provided a new RegEx feature for when you’re searching for a string of a given pattern in the cells (of a worksheet). We have also made enhancements to chart rendering in ODS format. This release also sees enhancements that makes the Aspose.Cells’ generated file compatible with POI. There are some other fixes … Continue Reading

Posted in Aspose.Cells Product Family | Tagged java, pivot tables, product release, regular expression, searching

Input Large Strings and Other Enhancements in Aspose.Cells for .NET 7.2.1

Posted on May 17, 2012 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for .NET 7.2.1. This month’s release allows you to input strings larger than 32K for text and CSV formats. We have enhanced the shapes rendering module, specifically improving Excel-to-PDF conversion. We have also improved the Smart Markers feature so that Aspose.Cells for .NET now supports nested objects in Smart Markers.

Moreover, we have made some enhancements regarding PivotTables and the internal Worksheet-to-Image modules and fixed some other issues. We have also … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, Excel, calculation engine, input strings, pivot tables, product release

Import DataView with more than 65,536 Records and useful enhancements with Aspose.Cells for .NET 7.2.0

Posted on April 13, 2012 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for .NET 7.2.0. This month’s release provides extensive support for the DataView object and now you can import more than 65,536 records; this was a restriction in the older versions. An important enhancement is also made for the ComboBox control for XLSM file format. Moreover, we have fixed a number of bugs, one of them is: “Build Error C2686” for C++ users especially. We have improved the quality of the chart-to-image, … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, Excel, conversion, fixes, import records, product release

Dates Retained when Reading CSV Files using Java

Posted on April 13, 2012 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Java 7.2.0. This month’s release provides support to retain the exact date format when reading CSV files: the dates will not be changed. We have also made some enhancements regarding shape rendering in our internal source modules. Finally, we have fixed a few issues regarding charts and other drawing objects.

Read release notes to get a full list of the new enhancements and fixes included in Aspose.Cells for Java 7.2.0.… Continue Reading

Posted in Aspose.Cells Product Family | Tagged CSV import, Excel, date formats, drawing objects, java, product release, shape rendering

Import Custom Object and Use Improved Auto-Fit Columns Feature

Posted on March 13, 2012 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Java 7.1.2. This month’s release provides support to create or manage tables in XLS format. You can now import data from custom objects for POJO. Read more about this in our Importing Data to Worksheets article. We have also made some enhancements to the sheet-to-PDF feature.

We have made enhancements to the auto-fitting columns feature and have fixed some bugs to do with charts and shapes.

Read the release … Continue Reading

Posted in Aspose.Cells Product Family |