-
Notifications
You must be signed in to change notification settings - Fork 110
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
how should we read a string with leading 0 (zero)? #1326
Comments
Hi @makarandp0 Thank you for contacting us. I asked our developer to clarify this behavior. I'll update you once I have more information from him. |
This behavior is caused by interpreting string hfInstance.addNamedExpression('myVariable', "'02345"); This information will soon be included in our documentation: #960 I hope this answer is helpful to you. If not, please re-open the issue. |
Thank you for your reply @sequba, I did find this trick about literal I am looking for a formula workaround where we could parse it as string. Typically using CONCATENATE function works for other numeric values to be converted to string, but when it comes to leading 0, those are lost even before CONCATENATE gets a chance to do anything. |
BTW, I couldn't figure out how to re-open the issue :( |
@makarandp0 We've just released the new version of the documentation with a detailed description of how to force a string value type. |
We use hyperfomula with named expressions. I noticed that if a named expression was a string that could be parsed as a number and had leading zeros, hyperformula always strips out those zeros. I tried few alternatives like concatenating it with another string or such, but did not find a way to extract the string with leading zeros intact.
Can you suggest some way to extract the original string?
The text was updated successfully, but these errors were encountered: