https://bugs.documentfoundation.org/show_bug.cgi?id=150635
--- Comment #6 from Mike Kaganski <mikekagan...@hotmail.com> --- (In reply to Tamas from comment #5) > I could not find any reference to the > steps you mentioned anywhere in the LO CALC GUIDE or anywhere else. You have a problem that importing a CSV, some data imports not as you expect. Moreover, you think that the problem is that you cannot *format* cells as text (I use your teems). The most straightforward thing to check is help. You press F1, and a search of keyword CSV in Index gives you "csv files -- importing and exporting" [1] among the top results. That page includes the mention how to *format* columns in the dialog. > Wouldn’t > it be simpler if Calc had an option to store larger than 15 digit numbers > as text, since converting text to numbers is relatively easy and well > documented. No. This proposal assumes that numbers shorter would import "correctly", which is not the case (not all decimal numbers are representable in binary), and would make part of column have numbers, part text, leading to more confusion. Whenever you are dealing with such data type agnostic media as CSV, no amount of guessing would solve user problems, and the correct answer is "user should do the decision themselves". [1] https://help.libreoffice.org/latest/en-US/text/scalc/guide/csv_files.html?DbPAR=CALC -- You are receiving this mail because: You are the assignee for the bug.
