Released: Dec 11, 2023

7.0.0 中的更新

特性

• Async User-Defined Function Support - A user-defined function derived from the new AsyncCustomFunction class now supports asynchronous calculations. Additionally, the CalcError type introduces a 'Busy' enum, signifying that a cell is currently engaged in calculating an asynchronous formula. This enhancement in DsExcel empowers users to leverage asynchronous calculations within their custom functions, providing flexibility and efficiency in scenarios involving complex computations.
• Enhancements in DsExcel Templates
  • Maintain Image Aspect Ratio - New properties, namely image.keepaspect or image.ka, have been introduced to DsExcel Templates. When set to true, these properties ensure that the aspect ratio of the image is maintained, allowing it to fit within the cell size regardless of its height or width.
  • Repeat Shapes and Images in Pagination Mode - Introduced enhanced support for the repetition of shapes and images with data in a Microsoft Excel file when the Excel template is processed. This enhancement ensures a more dynamic handling of shapes and images, adding flexibility to your report generation process. The shapes or images will repeat as per the parent of the top left cell from where the image or shape starts.
• Export Excel to HTML with CSS Inline Option - This functionality allows you to export an Excel file with style attributes embedded directly within HTML elements. Accompanying this capability, DsExcel introduces the HtmlSaveOptions.CssExportType enum, providing three values for exporting Excel files to HTML with different CSS options:
  • External: Export CSS to separate files.
  • Internal: Export CSS with the style tag in HTML.
  • Inline: Export CSS with the style attribute inside HTML elements.
• Set the First Page Number to 'Auto' in the Page Setup - When printing an Excel sheet, users can now incorporate the 'FirstPageNumber' property within the Page Setup Dialog to introduce numbering to the pages. To utilize a default numbering system, the option exists to set this property to 'Auto.'
• Improvements in Grouping for OptionButton Controls - The grouping functionality of OptionButton controls within a GroupBox has been enhanced to align more closely with MS Excel. Notably, OptionButtons within separate GroupBoxes now operate independently, ensuring that the selection of one group does not affect the choices in another. These enhancements streamline the management and behavior of OptionButton controls within GroupBoxes, offering increased flexibility and consistency in their operation.
• Enhanced Formatting for Trendline Equations in Charts (and Export)
  • Introduced formatting properties to the ITrendline interface to enhance the visual interpretation of trendlines. A new property, DataLabel, has been added to the ITrendline interface, allowing users to access the data label associated with the trendline. This feature enables users to utilize properties such as Font, Format, NumberFormat, Orientation, Direction, and AutoText from the IDataLabel interface to format the trendline equation label.
  • This release also includes the ITrendline.Delete method, providing a means to remove the trendline equation label when needed. Notably, trendline equations will now be supported in exports to PDF, HTML, and images, ensuring consistency across various formats. These enhancements contribute to a more comprehensive and visually appealing representation of trendline data in DsExcel.
• Specify the Default Value for the Cell - Users now have the option to establish a default value for a cell. If the regular value is unspecified, the default value will be shown and included in the calculations. DsExcel adds IRange.DefaultValue property to get or set the default value of the cell.
• Support Smooth Lines in the Chart in PDF Export - In pursuit of a visually appealing representation and a comprehensive understanding of the charted data, DsExcel now supports smooth chart lines while exporting Excel files to PDF. The following chart types benefit from this feature:
  • Line Chart.
  • Scatter Chart.
  • Combo Chart.
• Direct Acroform Creation with DsExcel API - Introduced a new feature that allows users to create Acroforms directly using the DsExcel API when exporting spreadsheets to PDF. A new property, PdfSaveOptions.FormFields, has been added. When set to true, this property enables the export of Excel Form controls as PDF Form controls while exporting an Excel file to PDF. The corresponding properties of certain Form controls are mapped to their respective PDF Form control properties.
• Support Exporting of Funnel Charts to PDF - Added support for Funnel Charts when exporting Excel files to PDF. So you can now add a Funnel chart to Excel and directly save the file to PDF.
• Specify Columns to Quote on Exporting to CSV - Added new CsvSaveOptions.QuoteColumns property to designate the specific columns requiring quotation marks. The indices of the column can be specified in the property.
• More Features for SpreadJS Integration - DsExcel incorporates support for additional SpreadJS features, enhancing compatibility with the client-side SpreadJS product. It's important to note that these added features function exclusively with SpreadJS and are incompatible with Microsoft Excel.
  • Support for cell.altText property.
  • Support for IRange.DefaultValue.
  • Support for Mask style.
  • Support for the password in the protected sheet.