EPPlus

EPPlus copied to clipboard

Formula parser optimizations and enhancements.

1

* Optimize tokenizer. * Reuse tokens for shared formulas. * Reuse expressions for shared formulas. * Add colon as operator. * Add intersect operator (Space) * Share atomic expressions in...

JanKallman

See #1327

swmal

Removing a `CalculatedColumnFormula` resets cell styles for that column

2

If I set a table column's `CalculatedColumnFormula` to be the empty string or null, the styles for all cells in that column are removed. I think this might be a...

craigbrown

See issue #1329

swmal

Xamarin forms UWP problem: excel cannot open the file because the file format or file extension is not valid.

7

I am testing the library and cant generate a valid output. This library in version 7 works on UWP? Tested: ExcelPackage.LicenseContext = LicenseContext.NonCommercial; using (var package = new ExcelPackage(rutaArchivo)) {...

pabloat81

The follwoing logic should be implemented internally: ```csharp var activeSheet = package.Workbook.Worksheets[package.Workbook.View.ActiveTab]; package.Workbook.Worksheets.MoveToStart("test"); package.Workbook.View.ActiveTab = package.Workbook.Worksheets.ToList().IndexOf(activeSheet); ```

swmal

Font Style Doesn't Stick Sometimes (Starting in 6.2.3)

3

I recently upgraded from EPPlus 6.1.1 to the latest version and noticed an issue. I am setting the entire worksheet to default to Arial 12pt, but certain cells do not...

robertmiles3

Reconsider our handling of "Alternate Content Roundtripping" in accordance with ooxml standard As in dataValidations s463 file. This occurs in excel when entering decimals with commas in a list validation...

OssianEPPlus

ConditionalFormatting Issue

3

Hi there, **OfficeOpenXml.ConditionalFormatting.Contracts.IExcelConditionalFormattingRule format1 = sheet2.ConditionalFormatting.ElementAt(0); var test = format1.Node.ParentNode;** I've recently upgraded from EpPlus version 5.0 to 7.0 and noticed that the IExcelConditionalFormattingRule.Node property has been removed from the...

st-dotnet

Editing a table using structured references in formulas result in a broken Excel sheet.

4

From EPPlus 7 adding rows to a table from a template using structured references in a table formula (for instance =@[ColumnName1]=@[ColumnName2]) results in a corrupted Excel file. On opening Excel...

bosma4u