Released: Dec 11, 2023

7.0.0 での更新項目

機能

Document Solutions for Excel, .NET Edition

• 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.

Document Solutions for Imaging

Document Solutions Image Viewer

• Select parts of the image, cut, copy, and paste - Added an array of selection tools and the ability to cut, copy, and paste from images. This enhancement is designed to streamline the image editing process, making it both easier and faster to select specific regions and focus on particular elements within an image to perform detailed analyses.
  • The Selection tool dropdown has been added to the secondary toolbar of the 'Paint tools' plugin. The following Selection tools have been added to the editor:
    • Rectangular Marque Tool - Ideal for making square and rectangular selections, this tool ensures accuracy in defining specific areas within the image.
    • Lasso Tool (Free Selection) - Empowering creativity, the Lasso Tool allows you to draw freehand selections, giving you the flexibility to highlight intricate details or irregular shapes.
    • Elliptical Marque Tool - Perfect for creating round and elliptical selections, this tool adds a touch of sophistication to your editing capabilities.
    • Polygonal Lasso Tool - For more intricate selections, the Polygonal Lasso Tool lets you draw polygonal and jagged outlines, providing precise control over the chosen area.
• Effortless Editing Workflow - Added a set of intuitive commands for seamless editing:
  • Cut, Copy, and Paste - Execute these fundamental actions within the editor using standard keyboard shortcuts: Ctrl + X, Ctrl + C, and Ctrl + V (or Cmd + X, Cmd + C, and Cmd + V on Apple macOS). This functionality allows you to effortlessly move and duplicate selected portions of the image.
  • Painting Inside a Selected Part - Customize your brush settings, including size, hardness, and opacity, and select your preferred color to paint within the selected part of the image.
• Add brightness and contrast to your images - Introduced two additions to the list of available filters: Brightness and Contrast. These filters help users enhance images, allowing for precise adjustments to highlight specific features and achieve the desired visual impact.
  • Brightness Filter - This is a versatile tool designed to modify the luminosity of an image by fine-tuning the intensity of each pixel's color channels.
  • Contrast Filter - This filter enhances or diminishes the distinction between light and dark areas, infusing depth and impact into every element. The adjustment of contrast with a specified 'Intensity' level transforms the image's tonal range. Bright areas become more vibrant, while dark areas acquire a heightened intensity. Leveraging the 'Intensity' slider within a range of -100 to 100, users can tailor their contrast adjustments to meet their needs.

Document Solutions for PDF

Document Solutions for PDF

• New Caret Annotation - The CaretAnnotation class enables precise pointing out of missing content or necessary changes programmatically. This is especially required if you need to add a CaretAnnotation at several places in the document programmatically.
• Custom Time-Stamps - In certain scenarios, a service may not be able to connect and return a required timestamp from the client due to security reasons. In these scenarios, a customized timestamp service may be required to send a valid timestamp token back to the client. The client then utilizes the timestamp token to sign the PDF file, ensuring compliance with various PAdES B-T/B-LT/B-LTA levels.

Document Solutions PDF Viewer

• Floating Search Bar - This feature allows users to search through documents seamlessly, providing a dynamic and user-friendly search experience. The Search icon is available by default in the toolbar of DsPdfViewer.
  • As you start typing, the search mechanism will automatically begin searching for matches within the document, highlighting or displaying results in real time as you type. This dynamic search process allows for immediate feedback and helps you quickly locate the relevant content you are looking for. With the new floating search bar you can:
    • Navigate search results using the 'Previous' and 'Next' buttons.
    • Customize Search Preferences Note: Click on the 'Settings' button to open the search settings menu to customize and fine-tune your search preferences.
    • Close the floating search bar by either clicking the close button or pressing the ESC key when the search input is focused.
    • Apply through code - A new option, useFloatingSearchBar, has been introduced. When 'true', it enables the use of a floating search bar in place of the sidebar search panel. To use the sidebar search panel instead of the floating search bar, set the useFloatingSearchBar option to 'false'.

Document Solutions for Word

• Picture Effects - Introduced a robust set of features that allow users to apply a diverse range of effects to pictures. This expansion not only enhances the visual appeal of documents but also streamlines the process of incorporating Microsoft Word-supported picture effects through code.
  • Using these effects, you can perform the following programmatically on images:
    • Change picture brightness and contrast.
    • Recolor with preset.
    • Change image color.
    • Set transparent color.
    • Overlay a specific color tint onto a picture.
    • And much more.
  • The following new API have been introduced:
    • RecolorType enum - Specifies the type of an image color change.
    • ImageEffectType enum - Specifies the image effect type.
    • UserColor class - Represents an extended color.
    • WebVideoProperties class - Represents the properties for displaying an online video to the user.
    • ImageEffect class - Represents a base class for image effects.
    • AlphaBiLevel class - Represents an Alpha bi-level effect.
    • AlphaCeiling class - Represents an alpha ceiling effect.
    • AlphaFloor class - Represents an alpha floor effect.
    • AlphaInverse class - Represents an alpha inverse effect.
    • AlphaModulation class - Represents an alpha modulate fixed effect.
    • AlphaModulationComplex class - Represents an alpha modulate complex effect.
    • AlphaReplace class - Represents an alpha replace effect.
    • BiLevel class - Represents a bi-level (black/white) effect.
    • ColorChange class - Represents a color change effect.
    • ColorReplacement class - Represents a solid color replacement effect.
    • Duotone class - Represents a duotone effect.
    • Grayscale class - Represents a gray scale effect.
    • HslEffect class - Represents a hue/saturation/luminance effect.
    • Luminance class - Represents a luminance effect.
    • Tint class - Represents a tint effect.
    • ImageEffectList class - Represents a list of image effects.
    • EmbeddedImageData class - Represents the embedded image data.
    • PicturePreset enum addition - Picture, slightly rotated counterclockwise, with white border.
  • Made new API additions and changes to:
    • ImageData class.
    • Blur class.
    • FillOverlay class.
• New CanAdd.. methods in content objects, sections, and Body classes - You can now also use 'CanAdd' CanAdd(ContentObjectType) and CanAddContentControl(ContentControlType) for ContentObject, Section, and Body classes to check whether a content object can be added to the end of another content object without raising an exception. It makes it easier to determine this earlier while coding with DsWord so that the process of adding content objects at the right locations becomes easy without causing errors later.