spreadsheet
spreadsheet copied to clipboard
Number cell problem with single quote
I have noticed that numeric cells have a single quote prefix occurring in them.
Instead of cell content 1234
it will be '1234
I cannot find the issue or reason why this is happening.
Please help @Iwark
Thank you.
Could you share some example code that is triggering this? You must not be hitting this line - example code would help to debug that.
This is caused by checkValueType not supporting floats and only integers (strconv.Atoi) To get around this, use a formula: in my case, i used =TO_DOLLARS()