Set Desired Image Dimension for Spreadsheet Export & Modify SQL DB Connection Setting


Well-known member
Mar 10, 2010
Programming Experience
Set Desired Image Dimension for Spreadsheet Export & Modify SQL DB Connection Setting

What is new in this release?

We are pleased to announce the new release of Aspose.Cells for .NET 8.4.1 . Microsoft Excel application allows creating the database connection so that the data could be bound/ fetched and loaded in the spreadsheets to refresh Pivot Tables, Charts or just the worksheet. The external data source is connected to the workbook through a data connection, which is a set of information that describes how to locate, log in, query, and access the external data source. Aspose.Cells for .NET API does not allow to create a database connection yet, however, some revisions back, the API had exposed the ExternalConnection class that contains the method & properties that could be used to review the database connection details stored in a spreadsheet. Most of the properties associated with ExternalConnection class were read-only until the release of Aspose.Cells for .NET 8.4.1. With this release, the API has provided the support to manipulate the database connection settings. Another worth mentioning feature is the support for setting desired image dimensions while exporting spreadsheets & charts to image formats. Aspose.Cells for .NET 8.4.1 has exposed the ImageOrPrintOptions.SetDesiredSize method to set the dimensions of the resultant image while exporting spreadsheets & charts to images. The SetDesiredSize method accepts two integer type parameters, where first is the desired width and second parameter is the desired height. Microsoft Excel has predefined settings to render comments while printing the spreadsheet or saving them in PDF format. Aspose.Cells APIs have borrowed this concept from Microsoft Excel and have exposed the PageSetup.PrintComments property & PrintCommentsType enumeration to facilitate the rendering of comments while converting spreadsheets to PDF format. The API has recently exposed the DataLabels.Characters method to retrieve an instance of FontSetting class that corresponds to the sub-string of ChartPoint.DataLabels. In turn, the instance of FontSetting class can be used to format the sub-string of the Data Labels with different font settings & color. Aspose.Cells for .NET 8.4.1 has exposed the Workbook.IsLicensed attribute which could be of great help in determining if the license file/key has been successfully loaded or not. If you access this property before setting the license, it will return false otherwise true for properly set valid license. In this release, several important issues have been addressed. For example, issues around writing Microsoft Excel file formats, applying formatting to the cells, copying rows, manipulating PivotTables, using PageSetup options, rendering HTML file format, manipulating shapes, rendering images from Excel worksheets, manipulating charts with formatting, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. We have also enhanced the Aspose.Cells formula calculation engine further and fixed a few relevant issues in this release. This release includes several enhanced features and bug fixes as listed below

- Set SQL Data Connection
- Support to Print Comments at the End of Sheet
- Rich Text Feature for Chart's DataLabels
- Pivot Table's data view in HTML does not correlate
- Pivot Table does not refresh while rendering to HTML
- Report Filter selections change
- Incorrect rendering of HTML while converting spreadsheet to HTML
- pivot table cells in group headers have incorrect styles
- Removing the source sheet causes exception on save
- The sort order of PivotChart's series data points is wrong
- Wrong conversion from HTML file to PDF
- Re-saving the XLS spreadsheet makes the result corrupt
- Date is overlapping with text in the left footer in the rendered PDF file format
- Double cell border is not printing properly for the last cell
- Missing table header border when converting to PDF
- Aspose doesn't print empty page
- Spreadsheet to PDF generates a blank PDF
- Pixels deteriorated a bit for the image in the output PDF file
- Cells that had dates and/or numbers with Hebrew words
- The logo with indentation wrong
- Colon in the end of the last word in the first line broke off
- The spaces between the Hebrew words vanished mashing the sentence into one word
- Support RenderToSize API for Worksheet Image
- FillFormat.GradientColorType returns PresetColors
- API returns null for DataLabel.NumberFormat
- Chart x-axis has negative values but only the minus sign (-) is shown
- Separator is read as "Auto" instead of "(NewLine)" for the Chart's Datalabels
- The Category axis' Major Minor and Base units in the chart changed
- Arrow is added to each trend element while rendering the chart to image
- Graph legend's size (Hebrew and English words) varied in the PD
- Setting CategoryAxis' CategoryType to TimeScale causes Chart.Calculate method stuck
- Missing Secondry Vertical Axis Values while rendering the Chart to Image
- Missing Secondry Verical Axis Values while rendering the Chart to Image
- Arrangement of the legends has changed after rendering the Chart to Image
- Half number lines and text do not show up for the x axis
- Chart exported to PDF have extra lines
- I've got a 0byte image - Shape2Image Error
- Chart mistakes when rendering container range
- Opening and re-saving an Excel file with SplitView results in a corrupted file
- Images in workbook cause it to not be openable
- Incorrect values returned for formula fields as compared to Excel
- Dropdown filter cannot be selected after loading and saving
- Loading and saving the XLSM makes the result corrupted
- Formula involving Named range cell is not read fine
- Value of Linked Cell of Radio Button is wrong
- Workbook.CalculateFormula gives different results from Excel
- Text style changed after loading a spreadsheet and saving back
- Cells.CopyRows has strange behavior with borders formatting
- Copy then paste a single row with multiple columns is not working
- GridWeb component load excel file problem with french culture
- GridDesktop is unable to find embedded resource license
- Shapes are not rendered properly in gridweb
- Moving worksheets in GridDesktop
- Some of the methods are missing in GridWeb

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.

- Export Worksheet or Chart into Image with Desired Width and Height
- Print Comments while saving to PDF

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#
- Download Aspose.Cells for .NET
- Online documentation of Aspose.Cells for .NET

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