Hi e-iceblue-team,
Having a bit of trouble with Spire.XLS at the moment.
I am starting out with a large Excel sheet with various formulas. I now want to copy only the calculated values into a new sheet (in another workbook). This new worksheet should ONLY contain the values, no formulas.
So far, the only way seems to be calculating cell for cell and copying the values manually. However, this is very slow and I additionally get "unknown formula IFERROR" exceptions.
Is there a better way to do this?
Alternatively, is there a way to replace all formulas in a certain range with their calculated values?
Best regards,
Markus