Generate PDF File by Fitting All Worksheet Columns to a Single PDF Page


Well-known member
Mar 10, 2010
Programming Experience
What is new in this release?

The long awaited version of Aspose.Cells for .NET 7.7.0 . 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 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. 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. 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. This release includes few enhanced features and plenty of bug fixes as listed below

- Support EnsureAllColumnsInOnePage option when rendering to PDF
- Support double underline (rendering images & PDF)
- How to detect file format and check if file is encrypted
- How to unhide a column without giving columnwidth
- Right-click, insert does not work with multiple rows or columns
- Auto adjust columns/row only working one column/row at a time
- Move left with Shift + tab keys or up with Shift + enter keys
- Shrink to fit does work as MS Excel does
- Create Workbook from HTML
- PivotTable - Incorrect Field List state for row/col (*.xlsb)
- The colors are stripped from the worksheet tabs
- Worksheet is rendered with Gridlines and Opaque Background
- Conversion of XLS to PDF: background image comes to the front is fixed
- XLS to PDF: Font Spacing Changing is now resolved
- Problem resolved while converting XLSX with digital signatures to JPEG
- Issue resolved with footer when exporting Workbook to PDF
- Problem fixed when converting RTL aligned Excel file to PDF
- ToImage function Issue is resolved
- Excel to PNG now Respecting Header
- Issue resolved with EXACT function calculation
- Hyperlink gets changed in the output PDF is fixed
- Excel embedded object naming issue is resolved
- Workbook.Copy renders the controls in source Workbook to Images is fixed
- Smart Markers grouping data creates unexpected blank rows
- enhanced reading the "LowerRigthRow" property of the Aspose.Cells.Drawing.Picture object
- ISLOGICAL calculation error is fixed
- Dropdown gets saved as a picture when XLS file is converted to XLSX file format
- Aspose.Cells computes a formula differently than MS Excel is now fixed
- Template format problem is resolved - Controls converted into image
- Aspose.Cells can now calculate COUNTIFS formulas correctly
- Formula is altered after processing with Aspose.Cells
- Transparency in chart dissapers in the output images
- NullReferenceException at WebWorkSheets.Insert()
- Cut now remove values from original cells
- Unexpected format options from one cell imposed on other cells
- Negative values change to positive in accounting format is fixed

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 .NET documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.

- Fit all Worksheet Columns on Single PDF page
- How to Detect a File Format and Check if the File is Encrypted

Overview: Aspose.Cells for .NET

Aspose.Cells is a .NET component for spreadsheet reporting without using Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, spreadsheet formatting, drawing objects like images, OLE objects and importing or creating charts. You can also create Excel file using designer spreadsheet, smart marker or API and apply formulae and functions. It supports CSV, SpreadsheetML, PDF and all file formats from Excel 97 to Excel 2007.

More about Aspose.Cells for .NET

- Homepage of Aspose.Cells for .NET C#
- Product Overview of Aspose.Cells for .NET
- Download Aspose.Cells for .NET
- Online documentation of Aspose.Cells for .NET
- Demos of Aspose.Cells for .NET
- Post your technical questions/queries to Aspose.Cells for .NET Forum
- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for .NET blog

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Aspose - Your File Format Experts
Phone: 888.277.6734
Fax: 866.810.9465

Latest posts