Using v12.1400.0.43 in a console app.
I have a worksheet with formulas in two columns; current use case has 2000 rows, but could be more. I need to consume the results of the worksheet formulas for further processing. If I attempt to call
ExportDataTable(worksheet.UsedRange, ExcelExportDataTableOptions.ColumnNames | ExcelExportDataTableOptions.ComputedFormulaValues) the table still isn't returned after a five minute run (returns instantaneously if not using ComputedFormulaValues). Is this behavior expected? I can't wait that long for this process...
As a potential workaround, I attempted to copy the range of cells with formulas to another range, and only paste the values. While the documentation seems to imply I can do this using
range1.CopyTo(range2, ExcelCopyRangeOptions.None)
the resultant fields in range2 still are the formulas, not the computed values. Is this behavior expected? How can I copy & paste only the values of the formulas?
How best can I accomplish my end goal? I saw a potentially similar thread about calculation engine (61789), but it was so old that I hope it is no longer accurate. The link to a sample file within that thread no longer works, anyway.
