Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Thu Feb 18, 2021 3:18 am

sheet2.Range("B27").Value

Gives the formulas entered in the cell. How do I get the calculated value displayed on cell?

Thanks.

skyfox1964
 
Posts: 9
Joined: Sun Oct 11, 2020 2:30 pm

Thu Feb 18, 2021 5:24 am

I should have done a bit of digging before I posted. Found the fix. In case anyone else is having this issue, answer is...

Instead of using

"sheet2.Range("B27").Value

Use

sheet2.Range("B27").DisplayedText


Cheers.

skyfox1964
 
Posts: 9
Joined: Sun Oct 11, 2020 2:30 pm

Thu Feb 18, 2021 8:45 am

Hello,

Thanks for your inquiry!

Glad to hear that the issue has been solved.

If you encounter any issues related to our product in the future, just feel free to contact us.

Have a nice day!

Sincerely,
Marcia
E-iceblue support team
User avatar

Marcia.Zhou
 
Posts: 858
Joined: Wed Nov 04, 2020 2:29 am

Return to Spire.XLS