Hi
i'm using CellRange.Copy method with these parameters:
reportRange.Copy(masterRange, true, false);
The problem is that it's copying formulas not values
I would like to copy only values
I can't use reportBook.CalculateAllValue() because file has 15 sheets and a lot of formulas. it takes too many time
consider i have to copy 46 sheet from different files into one
it should be like computedFormulaValue parameter for ExportDataTable method
thanks bye