Released: Feb 3, 2025

V2.0 (Build: 4.0.250103.5744) での更新項目

機能

• Xceed Workbooks for .NET now supports .NET 9.
• Xceed Workbooks for .NET now supports non-Windows environments in a .NET 5+ context. Note that a new dll, named Xceed.DrawingUtils.NET.dll, is required to make this work and should replace System.Drawing or System.Drawing.Common when using Color, Point, RectangleF, Font & similar types.
• A new class, called DataValidation, can now be used to integrate Excel’s validation feature into Xceed Workbooks for .NET.
• A new class, called PageLayout, now allows to define the options related to the Worksheet’s page & printing layouts.  
• PageLayout
  • A new property, called Margins, now allows to add margins to a Worksheet.
  • Multiple methods have been added to allow the insertion & removal of page breaks in the Worksheet.
  • Two new properties, respectively called RowBreaks & ColumnBreaks, can now be used to keep track of where page breaks are inserted in the Worksheet.
• Worksheet
  • A new property, called PageLayout, now allows to get how the Worksheet is laid out.
• Alignment
  • A new property, called IndentLevel, now allows to define the indentation for the content of a Cell.
  • A new property, called IsShrinkToFit, now allows to shrink a text so that it fits within a Cell.
• Cell
  • A new method, called CalculateFormula, now allows to calculate the Cell’s formula & then update the Cell’s Value property with the results of the calculation.
  • A new method, called CopyAndPasteTo, now allows to either copy or cut data & then paste it elsewhere in the Workbook.
  • Formulas read from a loaded workbook now include the “=” sign so that said formulas can be calculated.
  • The maximum number of shared strings allowed is no longer 65536, but 4,294,967,295, which means that shared strings will no longer be repeated in Cells.
• CellRange
  • Two new methods, called CopyAndPasteTo and CutAndPasteTo, now allow to respectively copy or cut data from a CellRange and paste it elsewhere in the Workbook.
  • A new enumeration, called CopyOptions, allows to determine if the data found in a specific Cell or CellRange will be copied or cut before being pasted into a new location.
  • A new enumeration, called PasteOptions, allows to determine what kind of data is pasted into a new location.
• Workbook, Column, Row, Worksheet and Ranges
  • A new method, called ReplaceContents, can now be used to replace multiple search values with new values, without the need to repeat the process for every value that needs to be replaced.

不具合の修正

• Column
  • The Column’s Width property will now be set automatically to 255 instead of throwing an exception when a Document containing a Column larger than 255 is loaded.
• Workbooks
  • Using multi-threading to set multiple Cells’ properties no longer throws exceptions.
• Worksheet
  • Chart Worksheets are now loaded correctly.