Generate PDF File by Exporting All Worksheet Columns to Single PDF Page Using .NET

Aspose's picture
Printer-friendly versionPrinter-friendly versionPDF versionPDF version

Aspose.Cells for .NET enables .NET developers to fit all worksheet columns on single PDF page. This is a useful feature when developers want to generate a pdf file that fits all columns on a worksheet onto a single page. It also supports detecting file format type, checking if the file is encrypted along with many others new & improved features.

Lane Cove, NSW, Australia., December 23, 2013 - (PressReleasePoint) -

The latest version of Aspose.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 user want to generate a PDF file that fits all columns on a worksheet onto a single page.
They also provide a feature for detecting file format type and checking if the file is encrypted. Sometimes user 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 them. Aspose.Cells provides the FileFormatUtil.DetectFileFormat static method and some relevant APIs which user can use to process documents.
While making a hidden column visible user can now restore it to the previously assigned width or its original width. All user need to do is unhide the column with a negative width. In the new version, they 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.
They 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, user 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.
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. User 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.

Press Contact:
Zarfishan Zahid
Suite 163, 79 Longueville Road888.277.6734
Email partially hidden to block spam. Please use the contact form here.
Contact Zarfishan Zahid
Email the contact person for this press release. Do not send spam or irrelevant message.
8 + 0 =

Copy this html code to your website/blog to embed this press release.


Post new comment

1 + 3 =