-
-
Notifications
You must be signed in to change notification settings - Fork 1.7k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
GetCellValue does not return raw value, even with the option RawCellValue: true #1161
Comments
Thanks for your issue. Please use |
You mean to use |
Any update on this? |
I have possibly a related issue; I have 24-hour times in a column which even with RawCellValue set are returned without the leading zeros instead of the text "0050", for example. |
Hi @pgalbavy-itrs, thanks for your feedback, could you provide your input file attachment without confidential info? |
Will try - it turned out the cell was formatted by the user with some weird combination of languages and numeric types. I will have to go find a copy of the XLSX file before they fixed it on our advice. Found it; Will try to put value and format in it's own file - but under OneDrive cell format is: Yes, we don't know who picked that either. |
Unless I am reading the doc from, I suppose by passing the GetCellValue with the option RawCellValue set to True:
I can get the raw text of what has been written in the cell.
Does not seem to be the case though.
The above line would gimme me the result of the formula, a number, in var
cell
but I need is the formula string, like=SUM(O4,N4)
So, is this a bug, or am I not looking correctly, in which case what should I do to get exactly what has been written in the Cell?
Thank you
The text was updated successfully, but these errors were encountered: