How to find the referenced cells in a formula

first post: Frans_van_Ek wrote: Hi I need to get the referenced Cells in a formula. e.g. the form...

How to change Checkbox value in xlsx?

first post: hujg wrote: Hi! I have a template file xlsx with checkbox objects. Is there a ...

latest post: c_melgarejo wrote: I have the same controls in my template. When adding the value to t...

ExcelScatterChartSerie markers

first post: crazycris84 wrote: How I can set the marker for an ExcelScatterChartSerie? Thanks. I...

latest post: crazycris84 wrote: I would know if it's my error or the library can't permit me change...

WorkSheet Dispose method not working

first post: aseghaier wrote: Hi, we are trying to run this code : using Ws =pck.workbook.workshe...

latest post: swmal wrote: Hi, Dont use the using statement on worksheet, use it on the Excel...

XYScatterSmooth Chart Error

first post: crazycris84 wrote: I have a XYScatterSmooth chart in an Excel file (XLSX). I insert ...

Worksheet.Drawings is null

first post: pwinant wrote: I am creating a new ExcelPackage from an existing template. That pa...

Getting cell value from forumla

first post: tomisy wrote: Hi! I need a cell value, what defined by a formula. It is possibl...

latest post: tomisy wrote: Thank you! It works without the = sign!

answered by: swmal wrote: I think that you should remove the leading = sign. from your formul...

Set columns header text

first post: Unga wrote: I use next entity for employee data: public class Employee { ...

latest post: anthonyjshaw wrote: I recently forked and the pull request was recently approved for su...

Smoothed Line VB

first post: ClassyBear wrote: Hi, Every time I add a line graph it sets it as a 'smooth line'. ...

latest post: ClassyBear wrote: **ClassyBear wrote:** > ``` > Dim chtPre = objWorksheetChartPre.Dr...

Style handing problem

first post: psh24 wrote: In Japanese xlsx, cellStyle in styles.xml is not sorted by xfId as ...

latest post: swmal wrote: Thanks, we will have a look on this. /Mats