Steps to reproduce action: import csv with fields with numbers with many digits like 030820111683300181256010077 result: field is formatted as number with exponential notation with 14 decimals like 3,08201116833002E+025 action: format the field as text result: field is displayed in exactly the same way expected result: field is displayed as the original digit string
(In reply to Dominik Lenné from comment #0) > expected result: > field is displayed as the original digit string ..and formatted as number or text? If you want to have it as text, you can choose the column in the import dialog and change the Column type to Text.
(In reply to Buovjaga from comment #1) > (In reply to Dominik Lenné from comment #0) > > expected result: > > field is displayed as the original digit string > > ..and formatted as number or text? If you want to have it as text, you can > choose the column in the import dialog and change the Column type to Text. and then use this one http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates ;)
(In reply to Buovjaga from comment #1) > ..and formatted as number or text? If you want to have it as text, you can > choose the column in the import dialog and change the Column type to Text. Thanks for the answer. Yes this is a way to avoid the problem in the first place, and is really very clever thought out. OTOH people expect that a format function does what it sais it does. So a possibility would be to place a remark into the dialog something like "Does not work for imported data. Format can be defined during import process."
(In reply to Dominik Lenné from comment #3) > OTOH people expect that a format function does what it sais it does. So a > possibility would be to place a remark into the dialog something like "Does > not work for imported data. Format can be defined during import process." Then that would only apply for cells with text formatting.. Would you have a smart suggestion on in what situations how to inform the user? E.g. formatting cell(s) of which one or more has text formatting (although Format > Cells may highlight Number..) and when the user applies different formatting that then he gets a pop-up explaining...
I do not understand the problem, if you are not happy with the standard number format, use # ##0 or 0 format instead. That said the standard format for numbers has the good idea to generally fit in the default cell width, when the 0 format will give ### if the cell is not wide enough which is generally the case with big numbers like in your example. I propose to close this bug report as NotABug. Best regards. JBF
(In reply to Jean-Baptiste Faure from comment #5) > I propose to close this bug report as NotABug. Yep, that seems appropriate as no response from reporter to Cor's question.