There are a ton of threads on this topic, but no simple and definitive answers.
Can someone please tell me how to permanently disable cell rounding on the .csv file which is created by script?
Basically, '377635637222436751' is being converted to '377635637222437000' automatically and that isn't really acceptable for my needs.
I've tried this:
Tools->Options->Calc->Calculate "Precision as shown"
Format > Cells > Numbers > Category > (scroll down for) Text.
(but considering my script creates the .csv — this option isn't very good since it must be done after the file is created)
And neither is working. The number stays rounded — even after formatting the column after the file is created.
Does anyone have any suggestions?