Posted 8 September 2017, 4:08 am EST
Thanks BobM, that works great except for one thing. When we have a custom formula set up on a cell, and use the :"FarPoint.Excel.ExcelSaveFlags.NoFormulas", it does not evaluate the result of the custom formula to the exported cell.. It is showing as blank.
Our custom formula is basically set up to act as an Excel SumProduct formula by adding up one column based upon the values in two other corresponding columns. The only thing I can think of is to loop through the grid and switch out all the custom formulas and replace with "SumProduct" during the export process.. That just seems very inefficient, especially when dealing with a 15K+ row grid.
example of sumproduct that works in excel for us:
=SumProduct((P9:P21="22")*(AH9:AH21="3")*R9:R21)
I know the version of SumProduct including in spread is a watered down version of Excel's SumProduct and does not support the formula above, which is why we went with the custom formula in the first place.