EPPlus

EPPlus copied to clipboard

One line fix to ExcelNamedRangeCollection to correct the Address property of named ranges when inserting rows and columns. More unit tests added in Address (and checking added to existing tests)....

kirbatious

Removed redundant dictionary lookups and redundant key casing. My benchmarks show measurable speed increase. The underlying dictionary is already OrdinalIgnoreCase, so no need to apply key.ToLower(CultureInfo.InvariantCulture) The calls should be...

Kizaemon

Property "Indexed" of class "ExcelColorXml" always returns 0, even if was initialized as int.MinValue. This leads to method "LookupColor" of class ExcelColor always returns #FF000000.

enragez

ERROR: Name contains invalid characters

3

Good morning, I am writing to inform you that since version 4.5.3 (also 4.5.3.1) we have encountered the following problem: Name contains invalid characters. The code that cause the problem...

Jakc95

I have added Font Charset Property to the Font Style. This Property is important for Non Default character sets. The bug is shown when someone opens an excel file with...

mzatkhahi

Saving XSLM gives currupted error message on opening

8

Opening and saving attached XSLM with following code: ``` [TestMethod] public void Test() { using (var package = new ExcelPackage(new FileInfo(@"C:\temp\MakroTemplate.xlsm"))) { package.SaveAs(new FileInfo(@"C:\temp\MakroOut.xlsm")); } } ``` MakroTemplate.xlsm can be...

Guest83

WMF and EMF being converted to PNG In ExcelPicture for PR #490

1

When inserting the vector-based image formats WMF or EMF, EPPlus will store the images as PNGs. This is because at some point a call is made to `Image.Save()` which uses...

aesalazar

Calculate() breaks the resulting value

9

EPPlus 4.5.3.3 Code provided: var cellRange = excelWorksheet.Cells[row, column]; cellRange.Calculate(); cellRange.GetValue(); The cell contains the formula for working days. After calling the Calculate () method, the Value field cannot be...

prof1k

What is the status of this project? Is it still active?

23

I'd like to respectfully address the elephant in the room here. I'm sure a lot of people have this question and for some reason it has not been asked here...

TechSavvySam

I am getting the "Start cell Address must be less or equal to End cell address" Exception when trying to set a value for a cell range. using (var excelPackage...

lolsoftware