How can I access the currently displayed value of a given cell range but not the actual value of that cell? For example – see this below image, where I have not increased the width of the cell enough to display the actual value which is getting rounded off.
If I try to get the Range
for this cell and access the values
property, it gives back 12.001123
. I tried the text
property as well from the documentation, but it gives back the 12.001123
as well. I want to access the value that is showing up right now in the UI i.e. 12.00112