Save ODS File in ODF 1.2 Specifications & Insert Values in Excel ListObjects


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

We are pleased to announce the new release of Aspose.Cells for .NET 8.3.1 . It contains over 40 improvements, new features and bug fixes. The Aspose.Cells APIs have extended support for the OpenDocument format. Now it is possible to save the ODS (OpenDocument Spreadsheets) in conformance with the ODF 1.2 specifications. The Aspose.Cells APIs have exposed the methods IsStrictSchema11 for the OdsSaveOptions class to allow developers to save spreadsheets in ODS format conforming to ODF 1.2 specification. The default value of IsStrictSchema11 property is false, and means that from version 8.3.1 of the Aspose.Cells APIs, the ODS files will be saved as ODF format version 1.2 by default. For more details, please check the article Save ODS file in ODF 1.1 and 1.2 Specifications. Normally, you add values inside the ListObject/Table using the Cell.PutValue method; however, the PutValue method must be associated with an instance of a cell to identify the location the value should be inserted at. This mechanism can?t be used when you need to add values inside the ListObject using the row and column offsets. Aspose.Cells for .NET 8.3.1 has exposed the Cell.GetTable and ListObject.PutCellValue methods to allow you to access the ListObject from a cell and add values using row and column offsets. Aspose.Cells provides the DataLabels.ShowCellRange property to select or clear the option Label Contains ? Value From Cells. Aspose.Cells APIs have exposed the SparklineCollection.Add(String dataRange, int row, int column) method to specify the data range and location of the sparkline group. In the new version, we have also provided enhancements for specify a prefix for image URLs in CSS and HTML files, Get/set Cell background color in Cell.HtmlString attribute and retrieve Cell.DisplayStringValue with conditional formatting. We have fixed a few exceptions that occurred while loading and opening Microsoft Excel file formats. We have also fixed the exceptions that occurred in manipulating shapes, rendering sheets, calculating formulas and manipulating pivot tables. We have also improved the performance when loading Microsoft Excel files. In this release, several important issues have been addressed. For example, issues around reading/writing Microsoft Excel file formats, printing spreadsheets, rendering HTML file format, manipulating OLE Objects, copying worksheets, manipulating shapes, manipulating rows and columns, 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 fixed some issues regarding the Aspose.Cells formula calculation engine to enhance it. We have also fixed a few issues in the web based Grid control by Aspose.Cells for .NET while loading/saving an Excel file. This release includes several enhanced features and bug fixes as listed below

- Specify a prefix for image URLs in CSS and HTML files
- Get/set Cell background color in Cell.HtmlString attribute
- Retrieve Cell.DisplayStringValue with Conditional Formatting
- File open performance issue
- Opening and saving E926E.xlsb file makes it corrupt
- Bullet list under the heading is not properly converted to pdf
- Rotated WordArt in Apose.Cells not rendered rotated when exported to PDF
- Row Height specified in XSL is not reflecting in the resultant spreadsheet
- Printing worksheet does not render bottom/footer contents
- Some letters are cut off in PDF renderings
- Excel to TIFF conversion creating excessive output images
- Image quality poor in the header when converting to PDF file format
- Text is getting truncated while rendering spreadsheet to PDF format
- Printing does not respect page break and scaling setting correctly
- Image has been misplaced while rendering spreadsheet to PDF format
- Line width is not getting applied to the chart
- Line.WeightPx does not take 2.0 as a correct value
- SheetRender.ToImage not printing secondary vertical values
- Missing text on graph with Aspose.Cells
- Formulas are not calculated on a slightly complex Excel file
- Some HTML tags like Br etc. are missing in the output of Cell.HtmlString
- CalculateFormula() is causing Reference Error
- Double values change when opened by cells and saved to byte array
- Evaluation watermark sheet always included even setting a license in the code
- Sheet background image turns black in XLS format
- Range.Copy is deleting the comment of the cell from the next row
- Ole objects in last worksheet are converted into pictures
- Spreadsheet does not load with Open XML SDK 2.5 for Microsoft Office
- Ceiling formula bug
- Worksheet.Copy affects comments appearance (black background, incomplete content)
- CEWebWorksheets are not updated after calling GridWeb.ImportExcelFile
- Loading a new Excel file does not work anymore in latest Gridweb
- Charts are showing Evaluation Watermark even when GridDesktop License has been set
- DataValidation (List) lost after saving the template Excel (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.

- Converting Worksheet to Image
- Save ODS File in ODF 1.1 and 1.2 Specifications

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
- Demos 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