Posted 8 September 2017, 2:38 pm ESTHi, I am sucesfully using a "custom function" in order to set the columns totals in a sheet.
But when I want to export the sheet to an Excel file using: FP.SaveExcel(MacroFilePath_EXCEL, FarPoint.Win.Spread.Model.IncludeHeaders.ColumnHeadersCustomOnly), the columns total is misunderstood, as you can see in the attached sample of the exported file.
I use a custom function because I want to include in the sum of the columns "just some cells" not "all cells" according my logic.
1) There is some way to export the sheet with their values (without formulas?), in other word, export the sheet just the way it look ?
2) There a way to export just "part of the sheet" ?, for example: to export the rows X to Y ?
Thanks in advance,