Do you need to process SXC and FODS file formats and want to have an API to handle these files? Aspose.Cells is the right library which will enable you to open or edit and save both OpenOffice/LibreOffice file types. You may also find other features and enhancements in the new Aspose.Cells for .NET v19.6. So let’s not wait another moment to review the release notes. To get complete details of the public release (Aspose.Cells for .NET v19.6), I am giving you a preview of the new features, enhancements, and fixes available in it.

Read or Write SXC and FODS Files using C#

We always try to provide features that are supported by other spreadsheet handling software. Many users demanded the support of SXC and FODS file types which are very common. So, here we are with the support of these file types in the latest release. Following is a brief description of these types along with the detail of their support in Aspose.Cells.

SXC Files

Spreadsheet created by StarOffice Calc; supports formulas, functions, charts, and macros; also includes DataPilot tables, which can automatically extract and summarize data from raw data sets. SXC files are also compatible with Apache OpenOffice Calc and can be exported in Microsoft Excel or IBM Lotus 1-2-3 formats.

FODS Files

Spreadsheet saved in the OpenDocument format, but stored as a flat XML file instead of the ..ZIP container used by .ODS files; allows the spreadsheet information to be more human readable; also can be an easier alternative than the ODS format for generating spreadsheets automatically without needing a spreadsheet editor.

Generate SXC or FODS File

You can generate SXC and FODS file using FileFormatType as an argument in Workbook constructor i.e. use FileFormatType.SXC and FileFormatType.FODS as an argument.

Load file

These files can be loaded using enumerator LoadFormat as follows:

SXC File

FODS File

Save File

The saving file of these types is quite easy by using SaveFormat enumerator while calling the Workbook.Save() function with second argument as SaveFormat.SXC and SaveFormat.FODS.

Other enhancements and fixes

  • Draw Slicer while rendering Excel to PDF.
  • Export Comments while Saving Excel file to Html.
  • Embedded OOXML file as a package for XLSX.
  • Security warning after re-saving an XLS file format.
  • Problems with medium lines/thick lines when XLSX saved as ODS.
  • Detecting whether the object file is chart or oleobject for ODS.
  • Handled “System.InvalidCastException”.
  • Handled “Shape to image error!” when converting XLSX to PDF.
  • Handled an exception “System.StackOverflowException” on rendering an Excel file to PDF file format.

To use these features and avail other enhancements and fixes, I recommend you to try the release Aspose.Cells for .NET v19.6. Moreover, I recommend you to browse Developers’ Guide for your complete reference on what you can deliver using the APIs. Also, you are always welcome to share your review, concerns or feedback on forums.