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:
| Updated: Mar 23 at 6:27 PM by r2718 | Created: Mar 23 at 6:27 PM by r2718
This relates to the work item 15200 marked as solved. I slightly modified the test case and the problem is still there.
"Can't merge and already merged range"
It looks like when ins...
Id #15234 | Release:
| Updated: Mar 23 at 12:27 PM by ioan38 | Created: Mar 23 at 12:27 PM by ioan38
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:
| Updated: Mar 23 at 11:04 AM by rcw823 | Created: Mar 23 at 9:45 AM by rcw823
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:
| Updated: Mar 22 at 9:34 PM by Mubien | Created: Mar 22 at 9:34 PM by Mubien
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:
| Updated: Mar 20 at 10:46 AM by Oko2021 | Created: Mar 20 at 10:46 AM by Oko2021
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:
| Updated: Mar 16 at 1:36 PM by fabianv | Created: Mar 16 at 1:36 PM by fabianv
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:
Id #15229 | Release:
| Updated: Mar 13 at 2:25 PM by horbach | Created: Mar 13 at 2:25 PM by horbach
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:
| Updated: Mar 12 at 1:29 PM by orloffm | Created: Mar 12 at 1:29 PM by orloffm
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:
| Updated: Mar 17 at 8:51 AM by VinGol | Created: Mar 11 at 11:31 AM by balahari
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:
| Updated: Mar 16 at 9:43 AM by shadowaltar | Created: Mar 11 at 4:10 AM by mayerwin