EPPlus 릴리스

Released: Mar 11, 2024

v7.0.10 버젼 업데이트

수정사항

  • Having a workbook with group drawings in group drawings caused EPPlus to fail on load.
  • Having #REF with a sheet reference when inserting a Row/Column caused the formula to become corrupt.
  • Files from 7.0.6 and prior with Data Validations would sometimes fail to be read.
  • Data Validations with AlternateContent nodes are now read if the Fallback node contains formulas.
  • Some cultures would sometimes get double negative signs in the .Text property of cells.
  • Invalid characters in the name...

Released: Feb 15, 2024

v7.0.9 버젼 업데이트

수정사항

  • The formula tokenizer did not handle minus correctly before table addresses.
  • Inserting rows/columns could cause drawings to get a incorrect width/height.
  • Saving multiple times caused hyperlinks to multiply.
  • Saving multiple times caused dxf border styles for tables to become corrupt if set.
  • EPPlus can now handle up to 66 indexed colors.
  • VALUE function did not support multi-cell input.
  • Deleting the first worksheet in a workbook where IsWorksheets1Based is true no longer throws out of range...

Released: Jan 24, 2024

v7.0.8 버젼 업데이트

수정사항

  • Validation of VBA module names failed when containing a space.
  • Decryption of workbooks where the hash algorithm SHA1 was used sometimes failed.

Released: Jan 19, 2024

v7.0.7 버젼 업데이트

수정사항

  • Implicit intersection in formulas with full row or full column addresses incorrectly calculated to #VALUE.
  • Inserting in a range with a formula that has a table address with two parts, i.e. Table1[[#This Row],[column1], caused the formula to become corrupt.
  • Conditional formatting's with #REF addresses caused an Exception.
  • HeaderFooter - Fixed issue introduced 7.0.6 where RightAlignedText was set as CenterAlignedText.
  • Formula parser handled negation incorrectly in some cases before addresses...

Released: Jan 10, 2024

v7.0.6 버젼 업데이트

기능

  • Added new TextSettings property to set text fills, outlines and effects on chart elements to ExcelChartTitle, ExcelChartLegend, ExcelChartAxis and ExcelChartDatalabel.
  • Upgraded RecyclableMemoryStream to 3.0.0.
  • Improved performance when opening files with many defined names in Excel.
  • Added a check for maximum header and footer text length.

수정사항

  • ToDataTable didn't handle RichText correctly when exporting values.
  • Calculation threw a NullReferenceException on calculating a copied worksheet with...

Released: Dec 22, 2023

v7.0.5 버젼 업데이트

수정사항

  • Calculating formulas with expressions that had double cell negations, returned an incorrect result.
  • Calculating a formula that had a negation of an empty cell returned a #VALUE error.
  • Pivot table fields with a specified subtotal function sometimes caused the workbook to become corrupt.
  • Deleting a worksheet with hyperlinks that refers to an internal address caused an exception.

Released: Dec 15, 2023

v7.0.4 버젼 업데이트

기능

  • Added follow dependency-chain option which allows calculating the given cells without calculating dependent cells.

수정사항

  • Deleting pivot tables sometimes did not clear their pivot caches.
  • The formula tokenizer did not handle single/double quotes and encoding correctly in table addresses.
  • The JSON export did not encode column header cells and comment texts.
  • Worksheet Copy did not copy images with hyperlinks correctly
  • ExcelRangeBase.FormulaR1C1 translation did return a correct value when having a...

Released: Dec 5, 2023

v7.0.3 버젼 업데이트

기능

  • Added support for Microsoft .NET 8.
  • Added Alignment and Protection properties to ExcelDxfStyle - Affects Table and Pivot Table styling.
  • Improved handling of negation of ranges in formula calculation.
  • Added AlwaysAllowNull property to ToDataTableOptions parameter of the ExcelRangeBase.ToDataTable function.

수정사항

  • ExcelValueFilterColumn.Filters. Blank property now hides rows even if it contains no other filters.
  • Resolved issue where ExcelValueFilterCollection.Add("") or adding null on...

Released: Nov 23, 2023

v7.0.2 버젼 업데이트

수정사항

  • External references did not work correctly in the VLOOKUP function.
  • Table addresses sometimes returned an incorrect address in formula calculation.
  • Empty arguments were not handled correctly in the Unique, Sort and SortBy functions.
  • Corrected behavior for comparisons between null values and empty strings in range operators.
  • Fixed a bug where adding the same image to a worksheet twice with the same path resulted in a null reference.
  • Resolved workbooks becoming corrupt when setting...

Released: Nov 9, 2023

v7.0.1 버젼 업데이트

수정사항

  • Copying a worksheet with the ExcelWorksheet.CodeModuleName set and not having a VBA project in the workbook caused the name to be duplicated.
  • Delete and create an Auto filter caused the workbook to become corrupt.
  • Worksheet Copy did not copy images in the header/footer when the destination worksheet was in another workbook.
  • Worksheet Copy did not copy images inside group shapes correctly when the destination worksheet was in another workbook.
  • Match function did not work with single cells in...