This project has moved. For the latest updates, please go here.

Copy Paste Values

Jan 5, 2012 at 8:39 AM

Hello everybody,

In my sheet I would like to use the "copy paste values"-function. My sheet contains a lot of formulas and I would to get rid of them, but still keep the result of the calculation.

Is this already an option in the current release? If not, will it be available in the near future?

Kind regards,

Coordinator
Jan 5, 2012 at 3:20 PM

If you're opening a workbook created in Excel and the user had auto calculate formulas on (the default) then you can use:

cell.ValueChached

If not then you can't, that's because ClosedXML doesn't calculate formulas and I don't think it's coming soon =/