Released: Dec 11, 2024

8.0.0 버젼 업데이트

기능

Import Data from Object Collections and Data Tables

• When working with Excel sheets programmatically in business applications, one common task is to import data from different data sources, such as classes and objects, relational databases etc. In the v8 release, Document Solutions for Excel (DsExcel) adds the ability to import data from the following types of data sources:
  • Simple enumerable.
  • Multidimensional array.
  • Jagged arrays.
  • Custom objects.
  • Custom objects from weakly typed collection...

Released: Nov 21, 2024

7.2.5 버젼 업데이트

수정사항

• When copying array formulas and exporting them to Excel, the reference ranges change.
• The form fields are incorrect in the exported PDF file after processing template.
• Some conditional formats are lost in the exported Excel file.
• Exception is thrown on opening a specific Excel file with a password.
• The XMATCH function does not return correct value if lookup array contains empty cells.
• Exception is thrown on loading SJS file contains null author in comment.
• The autofit method does not work...

Released: Oct 31, 2024

7.2.4 버젼 업데이트

수정사항

• OutOfMemoryException is thrown on exporting Excel file to SJS file.
• The font name in specific cells has changed after loading the SSJSON file.
• Some unused named styles are missing after loading the original SJS file.
• Some data labels are missing in the exported image file.
• Exception is thrown on opening an SJS file.
• The chart is corrupted in the SJS file exported by DsExcel.
• Emoji characters in sheet name get corrupted in the exported SJS file.
• The fill color is incorrect after adding a new...

Released: Oct 10, 2024

7.2.3 버젼 업데이트

수정사항

• The alignment is incorrect in the exported Excel file when overwrite fillmode is applied to cross table in template.
• The invocation of the PrintManager consumes a lot of memory.
• The plot area is not in the center in the exported image file.
• Some resources are incorrect in the de-DE/de-CH/it-CH/fr-CH culture in the exported Excel file.
• Exception is thrown on exporting SJS file after copying formula from another workbook.
• Enhance the exception message when inserting column is invalid...

Released: Sep 18, 2024

7.2.2 버젼 업데이트

수정사항

• There are many unexpected diagonal lines in the exported PDF file.
• Exception is thrown on exporting HTML file if some shape width is zero.
• The exported Excel file is corrupted when the source data of the PivotChart contains CalcError.
• The result of AVERAGEIF function is incorrect.
• Exception is thrown on opening an SJS file that contains invalid quality factor.
• The text that exceeds the boundaries of the shapes has not been cropped in the exported PDF file.
• After setting the value to a cell...

Released: Aug 30, 2024

7.2.1 버젼 업데이트

수정사항

• The macro button is missing after processing template file.
• The XValues of chart are incorrect in the exported PDF file.
• The static cell did not expand with the adjacent cell.
• Performance issue on calling ToJson method.
• The value and reference range of defined name become "#REF!" after processing template.
• "_Report_0" is added to the end of the shape name after processing template.
• There is a null fallback FontFamily in the exported HTML file.
• Exception is thrown on setting formula of...

Released: Aug 19, 2024

7.2.0 버젼 업데이트

기능

Document Solutions for Excel

• Add Goal Seek to Spreadsheets
  • Excel's Goal Seek function enables users to determine the necessary input value to achieve a desired result. By setting a target output, the Goal Seek feature automatically adjusts input values until the desired outcome is reached. This feature is invaluable for scenario analysis and decision-making in Excel modeling.
  • DsExcel adds a new API to add the Goal Seek function programmatically to your spreadsheets. The new IRange.GoalSeek...

Released: Jul 19, 2024

7.1.5 버젼 업데이트

수정사항

• The formula becomes dynamic array formula in the exported Excel file after processing the template.
• The custom formatter is lost in the exported SSJSON file.
• The source data of the Pivot Table is not updated after data binding.
• Some constant text is lost in the exported Excel file when setting FillMode as overwrite.
• The applied range of conditional formatting is incorrect in the exported Excel file after processing the template.
• The IndentLevel is reset to 0 after setting horizontal...

Released: Jun 27, 2024

7.1.4 버젼 업데이트

수정사항

• Merged cells are unmerged in the exported Excel file when template cell have G=R property.
• The series line of chart changed after loading the SSJSON file then exporting to SJS file.
• The formula is lost after loading the particular SJS file.
• The font weight is lost after loading the particular SSJSON file.
• Performance issues on opening a particular Excel file which contains lots of external workbooks.
• Exception is thrown on exporting Excel file after deleting particular sheet.
• The customized...

Released: Jun 7, 2024

7.1.3 버젼 업데이트

수정사항

• The column style is lost after calling processTemplate method in the exported XLSX file.
• There is a performance issue when saving specific Excel files to an HTML file.
• Enhance the exception message when deleting range is not allowed.
• Exception is thrown on filling the specific template file.
• Row heights are changed after opening an XLSX file then export to SSJSON file.
• Exception is thrown on deleting row after loading some particular SJS file.
• Constant cells are expand along with the...