Hi everyone,
I have a problem with the character << ’ >> in formulae.
I created an Excel sheet like this :
I filled the row data columns by hand and then add 2 formulae. No problem with that.
Before I continue, just notice the name of the first column has a simple quote and in the formula, this simple quote is replaced with a double quote.
I create a sample of code that open the excel filesheet and reads the cell below the name of the column (the goal is to read the formula)
public static void exemple2()
{
// i open the report
Workbook report = new Workbook(“C:\Users\lowia\Desktop\test.xlsx”);
// i list the table
ListObjectCollection tables = report.Worksheets[0].ListObjects;
// foreach table
foreach (ListObject aTable in tables)
{
for (int a = 0; a < aTable.ListColumns.Count; a++)
{
// i take the cell just below the cell that contains the name of the column
// and look at that cell
Cell uneCellule = report.Worksheets[0].Cells[aTable.StartRow + 1, aTable.StartColumn + a];
// if the cell below the name of the column has a formula, we write it on the console
if (uneCellule.IsFormula)
Console.WriteLine(uneCellule.Formula);
}
}
Console.ReadKey();
}
Here’s the answer: 
There is a problem with the first formula since it refers to a colum which has a simple quote in its name.
When i remove the simple quote in the name of the first column, everything works fine…
Can you guys fix that ? If yes, when ?
Thanks in advance,
Best Regards,
Louis.
Hi,
Please check/follow up your other thread:
<a href="
Thank you.