Author Archives: Amjad Sahi

Auto-fit Rows or Columns in Excel Worksheets in C# using Aspose.Cells for .NET 7.4.3

Posted on April 25, 2013 by Amjad Sahi

Aspose.Cells for .NET 7.4.3 has been released. This month’s release includes an enhancement for copying a cell over a range of cells. We have added a new overload: AutoFitColumns(int firstRow, int firstColumn, int lastRow, int lastColumn, AutoFitterOptions options), so you can use auto-fitting options even in a range. Similarly, you may now copy tables when copying ranges. We have also made enhancement regarding the Smart Markers’s Group Data feature. We have fixed a few exceptions when reading and writing Excel … Continue Reading

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

Improved Support for Numbers Formatting and HTML Rendering with Aspose.Cells for Java 7.4.2

Posted on March 26, 2013 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Java 7.4.2. This hotfix is a maintenance release that contains fixes for issues reported in earlier versions. In this release, we have provided support to get locale based date format for built-in numbers. Now macros and VBA codes are copied in the XSLM file when you use Workbook.copy() method. We have also improved the HTML rendering module. Several other important issues have been addressed. For example, issues around rendering Microsoft … Continue Reading

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

Improvments to Copying Ranges Between Workbooks and Parsing HTML Strings in Aspose.Cells for .NET 7.4.2

Posted on March 26, 2013 by Amjad Sahi

Aspose.Cells for .NET 7.4.2 has been released. This month’s release includes enhancements for copying ranges and numbers formatting. We have also made an enhancement to the List objects and Tables that are now copied when copying ranges between workbooks. Similarly, macros and VBA codes are copied in the XSLM file when you use the Workbook.Copy() method. We have fixed a few exceptions when manipulating PivotTables in the template file; we have also sorted out some issues regarding named ranges.

In … Continue Reading

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

Set Chart Side Wall Borders and Assign and Validate Digital Signatures with Aspose.Cells for Java 7.4.1

Posted on February 28, 2013 by Amjad Sahi

Aspose.Cells for Java 7.4.1 has been released. This month’s release includes support for setting borders for a 3D chart’s side and back walls. We have also provided support to assign and validate digital signatures. We have included a few enhancements regarding text alignments and error checking options in cells. This release is also a maintenance release where several important issues have been fixed. Many issues around reading and writing spreadsheets, rendering drawing objects and shapes, page setup options and … Continue Reading

Posted in Aspose.Cells Product Family | Tagged 3D chart, Microsoft Excel, digital signature, java, product release

Set Print Job Name while Printing Files and Improved RTL Language Support in Aspose.Cells for .NET 7.4.1

Posted on February 28, 2013 by Amjad Sahi

Aspose.Cells for .NET 7.4.1 has been released. This month’s release includes support for setting Print job while printing Excel files. We have enhanced the RTL (Right to Left) language support when rendering to PDF, TIFF, HTML, etc. A number of bug fixes are also included in this release. This release is also a maintenance release where several important issues have been fixed. Many issues around reading and writing spreadsheets or other files (XLS, XLSX, HTML, etc.), rendering shapes, copying conditional … Continue Reading

Posted in Aspose.Cells Product Family |

Set Custom Encoding in Excel to HTML using Java

Posted on January 25, 2013 by Amjad Sahi

Aspose.Cells for Java 7.4.0 has been released. This month’s release supports specifying a custom encoding type when saving to HTML. Since our Java version is auto-ported from .NET, almost every feature and enhancement that is included in the new .NET version are duplicated in the corresponding Java version. In this release, some issues pertaining to charts and formula calculation engine have also been addressed and corrected.

To see a complete list of enhancements and fixes and to download Aspose.Cells for … Continue Reading

Posted in Aspose.Cells Product Family | Tagged Microsoft Excel, customer encoding, enhancements, java, product release, saving to HTML

Enhancements to rendering advanced conditional formatting and Page Layout view in Aspose.Cells for .NET 7.4.0

Posted on January 25, 2013 by Amjad Sahi

Aspose.Cells for .NET 7.4.0 has been released. This month’s release includes an enhancement for advanced conditional formatting when converting worksheet to image files. We have also made an enhancement to the Microsoft Excel ruler which is not displayed when setting Page Layout view. We have improved the performance of Excel to PDF rendering, sometimes the process hanged a bit for certain Excel files.

In this release, several important issues have been addressed. For example, issues around rendering spreadsheets (XLS, XLSX … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, Microsoft Excel, Page Layout, performance, product release, rendering

Search in Documents and Get the Aspose.Cells for SharePoint Toolbar with Aspose.Cells for SharePoint 3.0.1

Posted on January 22, 2013 by Amjad Sahi

We are happy to announce the next version of Aspose.Cells for SharePoint 3.0.1. In this release, we have provided support for searching in a document. We have also included Aspose.Cells for SharePoint toolbar with some valuable options for SharePoint 2010. There is also an improvement regarding previewing documents in SharePoint: you can now preview multiple documents.

To see a complete list of fixes and to download Aspose.Cells for SharePoint 3.0.1, please visit the download page.… Continue Reading

Posted in Aspose.Cells Product Family | Tagged Microsoft Excel, SharePoint, document preview, preview, product release, search, search in documents, toolbar

Sparklines and Display Right-to-Left (RTL) Languages in Excel to PDF using Java

Posted on December 26, 2012 by Amjad Sahi

Aspose.Cells for Java 7.3.5 has been released. This month’s release supports rendering sparklines and displaying RTL (right-to-left) languages in generated PDF files (Excel to PDF conversion).

We have added more methods (for example Validation.getValue1() and Validation.getValue2()) to obtain DateTime values for custom needs. Moreover, we have enhanced the performance of PDF rendering by providing the valuable PdfSaveOptions.CheckFontCompatibility option; the conditional formatting feature is also improved.

This release is also a maintenance release where several important issues have been fixed. Many … Continue Reading

Posted in Aspose.Cells Product Family | Tagged Microsoft Excel, PDF, RTL, XLS, XLSX, java, product release, right-to-left language, sparklines

PowerPivot Feature, Read PivotTables in XLSB Files and Formula Calculation Engine Improved in Aspose.Cells for .NET 7.3.5

Posted on December 26, 2012 by Amjad Sahi

Aspose.Cells for .NET 7.3.5 has been released. This month’s release includes support for Microsoft Excel 2010’s PowerPivot feature: you can now read PivotTables in XLSB files. We have enhanced the Aspose.Cells’ formula calculation engine, so you can skip formulas whose external links do not exist in the template file. A number of bug fixes are also included in this release along with improved calculation of chart objects in template files.

This release is also a maintenance release where several important … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, Microsoft Excel, formulas, pivot tables, product release