Wednesday, September 28, 2016

Read/Write Values from ActiveX ComboBox Control & Set Class Identifier for OleObjects using .NET

What’s new in this release?

Aspose team is pleased to announce the new release of Aspose.Cells for .NET 9.0.0. This release includes some new features and other enhancements with critical bug fixes. Aspose.Cells for .NET API has exposed the ChartPoint.IsInSecondaryPlot property with this release. Boolean type property can be used to detect if a ChartPoint resides on secondary plot or not. The Aspose.Cells APIs can be used to insert and/or manipulate existing ActiveX controls. One such example is an ActiveX ComboBox which can now be created as well as manipulated with Aspose.Cells for .NET APIs. This release has exposed a new property which can be used to retrieve or set the class identifier for an OleObject. Please note, the class identifier decides which application is required to load the embedded resource/OleObject and how. For instance, a PPT file can be embedded in a spreadsheet with 2 different views, that is; presentation view or slide view, whereas both views have different class identifier values. The API has exposed the Shape.TextOptions property which can be used to control all aspects of the shape’s textual contents such as font style, color, font weight and so on. This release has fixed a few critical bugs as well as enhanced its core for more stability. There are some worth mentioning enhancements, such as loading the Workbook with specific System Culture Info, Use Aspose.Cells.GridDesktop control in WPF Application, enhanced the Aspose.Cells’ Calculation Engine for performance considerations, improved HTML import engine for cell borders as well as cell text alignment and handled a few exceptions such as NullPointerException and Invalid text of the defined name.” for certain scenarios. In this release, several important issues have been addressed. For example, issues around reading and writing Microsoft Excel file formats, rendering to HTML file format, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. This release includes several enhanced features and bug fixes as listed below
  • Read/write values from/to ActiveX ComboBox control
  • Using Aspose.Cells.GridDesktop in WPF application
  • Import of HTML fails when script tag uses CDATA
  • Contents are missing while converting HTML to XLSX
  • Unable to convert background or foreground colors from HTML
  • Error message is shown when double-clicking on any value of the PivotTable in the output file
  • The resultant file becomes corrupted when open and save the XLS file
  • Final XLSX file has a lack of the caption styles while these are present in the input XLSX and intermediate HTML
  • Issue with Spreadsheet to HTML conversion: STYLE tag between BODY and HTML tags
  • ICustomFunction doesn't work with [@columnName]
  • Wrong SUM displayed when calculating formulas
  • API incorrectly calculates the formula value as compared to MS Excel
  • Wrong calculation of the cell value
  • Wrong value from cell when calculating formulas
  • PDF result does not match with Excel for printing title rows
  • The data is hidden in the conversion result of PDF
  • Rendering to image file fails for a worksheet
  • Spreadsheet to XPS: Process never completes and takes too much memory
  • Sparklines are not rendered right while rendering spreadsheet to PDF/image
  • Chart.Calculate() method spoils the chart image
  • Saving to memorystream (SpreadsheetML), the process is hanged and takes lots of time
  • Unhiding the row hidden by Aspose.Cells does not work properly in Microsoft Excel
  • Picture formula is gone after removing and reinserting the picture
  • Re-embedding the presentation slide in XLS results in presentation view upon double clicking
  • Line with arrow head isn't rendered completely in XLSX & PDF formats
  • Printer settings are changed on opening and re-saving the source XLS file
  • "pane" xml within "customSheetView" xml not being replicated from designer spreadsheet
  • The Y and X Axis of the graph become bold after loading and saving an XLS file
  • The text-size of chart's vertical axis labels is changed after loading and saving XLS file
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. 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.

No comments:

Post a Comment