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
-
Marcia.Zhou
-
- Posts: 858
- Joined: Wed Nov 04, 2020 2:29 am