Create sheet by copying and move to end produced corrupted workbook

EPPlus v3.1 Step to reproduce bug: 1) open existing workbook with template sheet 2) create new sheet via copying template sheet 3) move created sheet to end 4) save workbook 5) excel can't op...

Id #15078 | Release: None | Updated: Thu at 12:40 PM by Avgur | Created: Thu at 12:40 PM by Avgur

Calculated Fields in PIVOT

Hi, we use some versions of your library, 4.0 for fast large plain reports, 3.2 for complex pivots and reports, and for pivot library has very large set of functions, but has no Calculated Fields,...

Id #15076 | Release: None | Updated: Oct 20 at 7:57 PM by DenisPastukhov | Created: Oct 20 at 7:57 PM by DenisPastukhov

Autofit columns doesn't work with columns whit format

Hi. I use this code to fit the columns: ws.Cells(ws.Dimension.Address).Worksheet.DefaultColWidth = 1 ws.Cells(ws.Dimension.Address).AutoFitColumns() If I don't use DefaultColWidth the columns ar...

Id #15075 | Release: None | Updated: Oct 18 at 9:17 AM by Rumpelstinsk | Created: Oct 18 at 9:17 AM by Rumpelstinsk

Issue with special characters in cache formula values

Using the latest v4 Beta build, I've found that it doesn't properly "clean" cached formula results. So, when editing a pre-existing worksheet, where a formula had previously returned the text "IF V...

Id #15071 | Release: None | Updated: Oct 15 at 4:31 PM by spyd0r | Created: Oct 15 at 4:30 PM by spyd0r

ExcelRangeBase.Copy

Hello I'm encountering this issue wherein am trying to copy cell range like code below: var oWs = package.Workbook.Worksheets["FormatSheet"]; var oRow = oWs.Cells[String.Format("{0}:{0}",1)];...

Id #15070 | Release: None | Updated: Oct 15 at 7:25 AM by paul1987 | Created: Oct 15 at 7:25 AM by paul1987

EPPLUS - iPAD/iPhone Date format

I generate an Excel file using EPPLUS. It has a date column with CustomFormat. I can open this file using Excel (desktop) as well on Android devices without any problem. But if I open this file...

Id #15069 | Release: None | Updated: Oct 13 at 10:58 AM by rajeevraina | Created: Oct 13 at 10:58 AM by rajeevraina

ExcelWorksheet.InsertRow(int,int,int) does not copy cell styles

Method ExcelWorksheet.InsertRow(int, int, int) does copy the StyleID of the template row (identified by the third parameter) to all newly-created rows; unfortunately, this is not at all sufficient....

Id #15068 | Release: None | Updated: Oct 15 at 7:07 AM by evgnib123 | Created: Oct 13 at 7:38 AM by rdeago

Error while copy sheet

I have to copy all sheets from attached file to a new file with the sheets name modified. In the copy of the sheet, calling the newPackage.Workbook.Worksheets.Add, I get several errors. I use the...

Id #15066 | Release: None | Updated: Oct 10 at 10:43 AM by Gozergod | Created: Oct 10 at 10:43 AM by Gozergod

How to add contents on an existing file

I have a existed file(xlsx),how can add contents and not overwirtten?I use the EPPlus 3.1.3.

Id #15065 | Release: None | Updated: Oct 13 at 7:04 AM by aaa2742 | Created: Oct 10 at 8:10 AM by aaa2742

In Beta 4 Formulas with Structured References May Return Zero

A very minor issue in Beta 4 appears to be preventing formulas that use Structure References from being computed correctly. My Excel spreadsheet contains the values 'Estimated Quantity' in colum...

Id #15063 | Release: None | Updated: Oct 13 at 6:45 AM by JanKallman | Created: Oct 1 at 5:56 AM by PhilipLGarrett