Using named ranges in cell formulas

Hi, I'm having problems getting a workbook to recalculate correctly when using named ranges in cell formulas. I have a simple workbook where I've named the range A2:A4 'Index' and populated it ...

Id #15235 | Release: None | Updated: Mar 23 at 6:27 PM by r2718 | Created: Mar 23 at 6:27 PM by r2718

Exception with ExcelRange.Copy and merged cells (still present in 59920b4b5f9f)

This relates to the work item 15200 marked as solved. I slightly modified the test case and the problem is still there. Exception: "Can't merge and already merged range" It looks like when ins...

Id #15234 | Release: None | Updated: Mar 23 at 12:27 PM by ioan38 | Created: Mar 23 at 12:27 PM by ioan38

xlApp.Workbooks.Open throwing com exception

Hi, What are the possible causes of the xlApp.Workbooks.Open(<filename>) throwing a System.Runtime.InteropServices.COMException? I tried to check the stack trace and I can't find a cause other t...

Id #15233 | Release: None | Updated: Mar 23 at 11:04 AM by rcw823 | Created: Mar 23 at 9:45 AM by rcw823

Chart Axis DisplayUnit Label

Just to follow on from the completed DisplayUnit request. Here is a bit of code I slapped together to display the label. Not the best :/ but works for now. const string _displayUnitLabelPath = "...

Id #15232 | Release: None | Updated: Mar 22 at 9:34 PM by Mubien | Created: Mar 22 at 9:34 PM by Mubien

O(n^2) when adding conditional formatting rules

The function OfficeOpenXml.ConditionalFormatting.AddRule calls to GetNextPriority to find out the next priority for the new rule. GetNextPriority in turn walks through all rules to determine the ...

Id #15231 | Release: None | Updated: Mar 20 at 10:46 AM by Oko2021 | Created: Mar 20 at 10:46 AM by Oko2021

Pictures from Excel file are not loaded correctly when contained in 'oneCellAnchor'

There is an explicit setting in ExcelDrawings.cs AddDrawings() method when loading the file, which causes pictures contained within an oneCellAnchor element to not be loaded correctly, because it i...

Id #15230 | Release: None | Updated: Mar 16 at 1:36 PM by fabianv | Created: Mar 16 at 1:36 PM by fabianv

Missing AlternativeText property by Excel comment

Hi, Excel comment has a property of Alternative Text, which is not implemented in EPPlus. To implement it, it is enough to add the following property to ExcelVmlDrawingBase class: public st...

Id #15229 | Release: None | Updated: Mar 13 at 2:25 PM by horbach | Created: Mar 13 at 2:25 PM by horbach

Bug in ExcelWorksheet.CopyColumn regarding Hidden

In that function, we do: newC._hidden = c.Hidden ... newC.Width = c._width That effectively unhides the new column. So, if we have two consecutive hidden columns in a worksheet (<col min="6" ...

Id #15228 | Release: None | Updated: Mar 12 at 1:29 PM by orloffm | Created: Mar 12 at 1:29 PM by orloffm

unable to draw a chart with Y Seconder y axis

Hi i am unable to draw a chart with Y Seconder y axis ,the cell values will pass dynamical y,not hard code .i want the loop how to draw char with multiple Y AXIS . i am able to draw primary axis....

Id #15227 | Release: None | Updated: Mar 17 at 8:51 AM by VinGol | Created: Mar 11 at 11:31 AM by balahari

Setting GapWidth, BaseUnit and TickLabels.Orientation for ColumnStacked charts

I need to be able to accomplish the following VBA operations on a ColumnStacked chart (the XAxis values are end of month dates, so it needs to be set up as months, otherwise the bars correspond to ...

Id #15226 | Release: None | Updated: Mar 16 at 9:43 AM by shadowaltar | Created: Mar 11 at 4:10 AM by mayerwin