Read Write SXC and FODS files with Aspose.Cells for .NET 19.6

Share on FacebookTweet about this on TwitterShare on LinkedIn
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 preview of the new features, enhancements and fixes available in it.

Support for SXC and FODS

We always try to provide features which are supported by other spreadsheet handling software. Many users demanded 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.

Features provided by Aspose.Cells

Generate file

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

Load file

These files can be loaded using enumerator LoadFormat as follows: SXC File
FODS File

Save File

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.