Hello all.
Using Excel Buffer to export some data to excel.
I have the following Line of code
EnterCell(RowNo, ColNo, STRSUBSTNO('=SUM(e%1:e%2) * 100', RowNo - (tmpBOM.COUNT), RowNo - 1),
TRUE, TRUE, '##0.00', '', FALSE, 0);
The above works well in a NAV 2009 environment where the formula gets calculated and I am getting on actual value for the formula defined above
STRSUBSTNO('=SUM(e%1:e%2) * 100', RowNo - (tmpBOM.COUNT), RowNo - 1)
however when I use the same line of code in a report I can creating in Business central , the value in Excel is =SUM(e6:e8) * 100
Any ideas what am I missing.
Do I need to set a property in that field and mark it as a formula field ?
