EPPlus

EPPlus copied to clipboard

Can't remove a table column's calculated column formula

2

I've found a few odd things with the CalculatedColumnFormula property. I'm not sure if they're bugs or I'm using it wrong, or some combination of the two. 1. If I...

craigbrown

Repeat Labels in Pivot Table fillDownLabels is not defined in C#

7

I want to repeat Labels in Pivot Table but the fillDownLabels is not defined in C# ``` `if (!isPivotTree) { pivotTable1.RowGrandTotals = false; pivotTable1.ColumnGrandTotals = false; pivotTable1.Fields.ForEach(field => { field.Outline...

medaminrannen

Row of Cell with TextWrap Auto Sizes in Excel but not in LibreOffice Calc

2

I can make a simple XLSX file using EPPlus 6 using the following lines of code: ``` worksheet.Column(2).Style.WrapText = true; worksheet.Cells[2, 2].Value = "A line of text that should wrap";...

jsid72

No Worksheet Found [DotnetCore 3.1 / EPPLUS 5.5.3)

2

# Scenario 1. Open this file : [Classeur1.xlsx](https://github.com/EPPlusSoftware/EPPlus/files/5947533/Classeur1.xlsx) 2. use this code in an console project ```c# ExcelPackage.LicenseContext = LicenseContext.NonCommercial; using (ExcelPackage xlPackage = new ExcelPackage(file)) { if (xlPackage.Workbook.Worksheets.Count ==...

Portekoi

Support Open XML Strict

2

Hi What are your thoughts on supporting Open XML Strict? Use case: We are an archive and we want to longterm preserve spreadsheets in the proper Strict format, so we...

Asbjoedt

Some japanese texts are not handled correctly when reading OfficeOpenXml file

1

The library method ExcelRange.GetValue() returns null for the following text. This is the representation of text in sharedStrings.xml within xlsx file archive: ``` {0} へのパスを入手できません。 {0} を実行し、 Revizto プラグインを初期化してください。解決しない場合は、一度予定を取り消し、再度タスクを予定してください。 ```...

PsykerUdot

Support for copying 'What-if Analysis' Data Table {TABLE()} functionality between workbooks?

2

Hi - I have a use case where I need to copy Excel sheets from one workbook to another, and preserve everything. It works quite well, using: outputPackage.Workbook.Worksheets.Add(workSheetName, sourceSheet); However,...

ses4j

Performance issue with rich text

3

I'm inserting text with superscript footnote ids into cells and have found and usage of rich text is ~15x slower than plain text Attached is a benchmark comparing epplus to...

StevenQuickGS1

Exception: Saving file containing comments --wbPackage.Save()

6

I have been using EPPlus 4.5.3.2 in my project. Recently in my development setup, I updated to version 5.8.8. Now I am facing exceptions when working on xlsx files containing...

HyderAli1990

BigInteger are shown as text in Excel

1

I had encountered a strange behavior in EPPlus 6.0.3 with BigIntegers. By filling the sheet with **LoadFromCollection** where the list contains members of type **BigInteger** the corresponding columns in the...

sebcom