Description: My university's Learning Management system exports gradebooks as CSV files where each line begins and ends with #, and expects them to come back in the same format. If I try to use LibreOffice to make even minor edits, it will alter all of these characters. For example, I download the file. I open in nano. The first line is "#56987425,Vickie.Brewer,42,38,89,77,E.... " I open in LibreOffice and change the 42 to 43. Now the first line is "+ACM-56987425,Vickie.Brewer,43,38,89,77,E...." This is undesirable. LibreOffice was not asked to edit the first cell, and should not be editing things it was not asked to edit. Steps to Reproduce: 1.Create a csv file which contains '#' 2.Open in LibreOffice, make a change, and then save. Actual Results: File is altered in ways that only become visible when it is opened with a different software. Expected Results: One should be able to expect that the software will not make invisible changes which it has not been asked to make. Reproducible: Always User Profile Reset: Yes Additional Info: No other information. Why is this field required?
Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.
Created attachment 200271 [details] csv file before it is opened
Created attachment 200273 [details] csv file after it has been opened One edit has been made by the user: change 42 to 43 in row 2, column 3. Various other changes (replace all instances of '#' by '+ACM-', all instances of '-' by '+AC0-', all instances of '!' by '+ACE-') seem to occur automatically.
Created attachment 200286 [details] Screenshot text impor window See the text import window that I think works fine. I think the matter is to avoid the first '#' disappear, if the column is treated as number, not as text.
*** This bug has been marked as a duplicate of bug 166208 ***