How to copy a cells content without function

[dfense]

Hello.

Let's say, cell A1 contains a function (=SUM(B1:C1)). How can i copy just the summary of cell A1, maybe as text, to another cell? If i use Range.Copy(), it copies the whole function to the new cell...

Regards

[Jason.Tan]

Hello dfense,

Thank you for your inquiry.
You can try to following way to copy formula to new cell as text.

Code: Select all

sheet.Range["E5"].Text =  sheet.Range["B5"].Formula;

Please let me know if you have any questions and concerns.

Best Regards

[dfense]

Are you sure that you mean it this way? If i would set the text property of the destination cell to the source formula, it would just display "=SUM(B1:C1)" as text, not the calculated value.

[Jason.Tan]

Hello,

Sorry for confuse to you.
Your requirement can work ground with calculation engine of workbook, the new features will be release in next version.
Please let me know if you have any questions and concerns.

Best Regards.