Released: Apr 8, 2024

Actualizaciones en v7.1.1

Características

• Added new Rotation, HorizontalFilp and VerticalFlip properties to ExcelShapeBase and ExcelPicture.
• Added new SetColor() method to ExcelDxfColor.

Correcciones

• Fixed an issue where RichText wasn't set properly on a multicell range.
• Escape character before an apostrophe in date formats are no longer removed by EPPlus.
• The GenericImageReader failed to read some jpeg/exif images.
• Setting the TextBody.Rotation on Chart DataLabel's caused the workbook to become corrupt in some cases...

Released: Mar 27, 2024

Actualizaciones en v7.1.0

Características

• Improved HTMLExport - The HTML exporter can now export all conditional formatting's except icon sets and data bars and their priority order.
• Improved performance on range rich text.
• ExcelRangeBase.LoadFromCollection improvement - Number format for columns added via LoadFromCollection can now be set in runtime via the IExcelNumberFormatProvider interface.

Correcciones

• Inserting rows would cause an exception to occur in formulas in rare cases.
• Special signs such as ' when last in a...

Released: Mar 11, 2024

Actualizaciones en v7.0.10

Correcciones

• 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

Actualizaciones en v7.0.9

Correcciones

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

Released: Jan 24, 2024

Actualizaciones en v7.0.8

Correcciones

• 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

Actualizaciones en v7.0.7

Correcciones

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

Released: Jan 10, 2024

Actualizaciones en v7.0.6

Características

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

Correcciones

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

Released: Dec 22, 2023

Actualizaciones en v7.0.5

Correcciones

• 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

Actualizaciones en v7.0.4

Características

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

Correcciones

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

Released: Dec 5, 2023

Actualizaciones en v7.0.3

Características

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

Correcciones

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