spreadsheet icon indicating copy to clipboard operation
spreadsheet copied to clipboard

Number cell problem with single quote

Open nlandeker opened this issue 5 years ago • 2 comments

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.

nlandeker avatar Jan 29 '20 20:01 nlandeker

Could you share some example code that is triggering this? You must not be hitting this line - example code would help to debug that.

ttacon avatar Aug 29 '20 19:08 ttacon

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()

Rubberbandits avatar Feb 26 '22 18:02 Rubberbandits