Problem Deserializing Comments from an Excel File created by Google Sheets Export

We are using EPPlus to read an Excel .xlsx file created by Google Sheets. The original Google Sheets document contains both "Comments' and 'Notes' in the cells of the header row. When EPPlus reads ...

Id #15151 | Release: None | Updated: Today at 2:08 AM by PhilipLGarrett | Created: Today at 2:08 AM by PhilipLGarrett

ExcelRangeBase.Clear() doesn't act as expected

Hi, Sorry, just found another bug. ExcelRangeBase.Clear() doesn't act as expected (nothing be cleared). No exception though. Demo project attached. Thanks, -Steven

Id #15150 | Release: None | Updated: Thu at 1:00 PM by StevenXi | Created: Thu at 1:00 PM by StevenXi

Row copy act incorrectly

Hi, Another bug found in row copy, no exception but the output doesn't seem be right. demo project attached.

Id #15149 | Release: None | Updated: Thu at 11:48 AM by StevenXi | Created: Thu at 11:48 AM by StevenXi

Couple bugs relate to PageIndex.RowCount has negative value

Hi, Just found couple bugs relate to PageIndex.RowCount has negative value, involves Copy/Delete cells. Source of the negative value is CellStore.DeleteCells() Tried to fix one of them in the...

Id #15148 | Release: None | Updated: Thu at 11:17 AM by StevenXi | Created: Thu at 11:17 AM by StevenXi

Part already exist ( Package.Save() )

Hi, I'm unable to save any package that has more than one sheet. I am opening the XLSX file using FileInfo. THe file already has the sheets in it, I'm just printing to them and saving the file. I...

Id #15147 | Release: None | Updated: Wed at 11:26 PM by sillymoose | Created: Wed at 7:47 PM by sillymoose

ExcelRangeBase.Copy() failed

Exception "Non-negative number required.", test code attached (works in v3): private static void Main(string[] args) { var template = new FileInfo(@"..\Template.xlsx"); const string output ...

Id #15146 | Release: None | Updated: Wed at 7:27 PM by StevenXi | Created: Wed at 5:30 PM by StevenXi

ws.InsertColumn throw exception in some sheets

The workbook attached. For sheet 1, "ws.InsertColumn(3, 1);" throws exception "ColumnMax can not span over existing column 10." while sheet 3 works correctly although they looks same. Test case:...

Id #15145 | Release: None | Updated: Thu at 9:58 AM by StevenXi | Created: Wed at 4:44 PM by StevenXi

Issue when change Font.Name from style

I detected an error that sometimes happens (In other worksheet) when you try to change Font.Name from Style otherWorksheet.Cells["A36"].Style.Font.Name = "Tahoma"; Error in GetStyleId method, fr...

Id #15144 | Release: None | Updated: Wed at 1:52 PM by jdnichollsc | Created: Wed at 1:48 PM by jdnichollsc

Writing data to a worksheet with formulas

Hello; I have a problem using EPPLUS, when I set a value to a cell that is used in a formula, when then I open the workbook in excel, the formula is not updated with the new value.

Id #15143 | Release: None | Updated: Wed at 1:36 PM by jdnichollsc | Created: Wed at 1:01 PM by JorgeLopez

Return empty value in Rgb property from ExcelColor

Hi people! I try to get a Rgb value from style of a cell but this return a empty value. EPPlus Version 4.0.1, change set c6c16f4d9f16. I Attached a demo to reproduce this error. Thanks, Nicho...

Id #15142 | Release: None | Updated: Tue at 8:36 PM by jdnichollsc | Created: Tue at 8:36 PM by jdnichollsc