Fit All Worksheet Columns onto One PDF Page and Detect File Format with Encryption Options with Aspose.Cells for .NET 7.7.0

Share on FacebookTweet about this on TwitterShare on LinkedIn

Aspose.Cells for .NET logoAspose.Cells for .NET 7.7.0 has been released. This new release supports fitting all worksheet columns on single PDF page. This is a useful feature when you want to generate a PDF file that fits all columns on a worksheet onto a single page. We provide the PdfSaveOptions.AllColumnsInOnePagePerSheet property which performs complex calculations, such as the height and width of the resultant PDF page to fit all the columns in.

We also provide a feature for detecting file format type and checking if the file is encrypted. Sometimes you need to detect a file’s format before opening it because the file extension does not guarantee that the file content is appropriate. The file might be encrypted (a password protected file), so it can’t be read directly or isn’t available to us. Aspose.Cells provides the FileFormatUtil.DetectFileFormat static method and some relevant APIs which you can use to process documents. The following sample code illustrates on how to detect a file format (using the file path: you may also use streams) and check its extension.

//Detect a file's format type
FileFormatInfo info = FileFormatUtil.DetectFileFormat("e:\\test2\\Book1.xlsx");

//Gets the detected load format
Console.WriteLine("The spreadsheet format is: " + FileFormatUtil.LoadFormatToExtension(info.LoadFormat));

//Check if the file is encrypted or not.
Console.WriteLine("The file is encrypted: " + info.IsEncrypted);

Several Enhancements and Fixes

While making a hidden column visible you can now restore it to the previously assigned width or its original width. All you need to do is unhide the column with a negative width.

//Unhide the column "F" with its previously assigned width
worksheet.Cells.UnhideColumn(5, -1);

In the new version, we  also support double underline while rendering images from sheets and converting Microsoft Excel files to PDF format.

In this release, several important issues have been addressed. For example, issues around rendering Microsoft Excel file formats (XLS, XLSX, ODS, CSV, XLSB etc.), rendering and manipulating pivot tables, rendering images from Excel worksheets, reading and writing HTML files, rendering shapes and controls, Smart Markers, manipulating embedded OLE objects, rendering and manipulating charts, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. A few improvements are also made pertaining to the formula calculation engine of Aspose.Cells for .NET.

We have made a few enhancements regarding auto-adjusting columns and rows and inserting rows in the web based grid control provided by Aspose.Cells for .NET. Now, you can move left with SHIFT + TAB, or up with SHIFT + ENTER just as in Microsoft Excel. We have also fixed a few issues regarding numbers formatting in GridWeb.

To see a complete list of enhancements and fixes, and to download Aspose.Cells for .NET 7.7.0, please visit the download page.