When importing a comma delimited csv file to calc I get errors if the first character of a number is a plus sign. I also see an error importing the first field of the first line.
The csv file contains the following (created using vi, so there shouldn’t be any strange characters)
Number,fieldA,fieldB,fieldC
42,-42,+42,+0.14%
The resulting file in calc looks like this
???Number fieldA fieldB fieldC
42 -42 ? ?.42
where the ? is actually a character that looks like a black shield with a white ? inside it.
I attached a screenshot of the calc window (I hope what I did works) but i don’t seem to be able to upload the csv file. It won’t let me select it.
.
I suppose it is possible that there are some special characters (hidden) in the csv file but I don’t see any, even with a simple text editor like vi.
Using the latest version of LibreOffice for mac silicon. on a mac mini M1 running Sequoia 15.5
I have also tried many settings in the csv file import page with no success.
I suppose I’m doing something stupid, but I don’t know what it is. Any help would be appreciated.
thanks.
WOW! EarnestAI had the answer before I even finished editing my post. thank you. It was set to UTF-7, as soon as I changed it to UTF-8 the problem was solved. thank you.