[Solved] Calc adding +ACI- when i export to text csv

[AlphaAI]

Hello,

I have a ods file which has two columns with text in one or both or either.
The current sheet is saved as a text csv file.
csv formatting is kept and UTF-8 is chosen.
When I import it in my app, it shows that the text has +ACI- appended to it
plus it also has this in a few places +AF4-

I have tried to do a search and replace to remove those +ACI- but it cannot locate them in the document

Can someone please tell me how to fix this?

Ben

[AlphaAI]

Not only that
here are the other codes

+AD4- >
+Adw <
+AC0- -
+ACo- *
+AD0- =
+ADs ;
APA- <
+AF4- ^

Why is this happening?
I need this corrected. I dont want to go through the Find and Replace all, that is just too painstaking

Ben

[AlphaAI]

I believe this problem has been fixed.

[jrkrideau]

I believe this problem has been fixed.

Don't leave us in suspence, what did you do? Others may learn from your experience.

[edwardtilbury]

mine's doing it too, really odd..

I have to open the csv, save as ods, then open in excel and save as csv... UGH!

OOO Calc 3.2 on Ubuntu 10.04 x64

[acknak]

Can you attach a sample file with the extra characters in it?You can use the "Upload Attachment" link (below the message entry area after you click "POST REPLY"). [Forum] How to attach a document here You'll have to put it in a zip archive to get the forum to accept it.

[edwardtilbury]

Here's the wacky +ACI- file

[acknak]

The data in your file is encoded as UTF-7 (http://en.wikipedia.org/wiki/UTF-7), instead of the more usual ascii/latin-1 or UTF-8. Each of the +ACI- sequences encodes one double quote character.

Unfortunately, the text encoding used in a csv file is not recorded in the file itself, so you must tell Calc how the file is encoded when you import it.

In the Text Import dialog, select your file, then change the "Character set" to UTF-7, and you'll see all the usual quote characters.

[leolopes]

The thing is that my .csv file was not originally encoded that way. It was OO that saved it with that encoding. It seems to assume files are encoded in UTF-7 when it opens them, then keeps that state in memory and saves them with that encoding, overriding what the actual encoding was originally.

[acknak]

So, what's your question?

It seems like a reasonable feature to me, that Calc preserves the encoding when you work with a text file.

If you want to save it with a different encoding, just use File > Save As, and tick the "Edit filter settings" check box, then select a different encoding.

[darias]

I just upgraded to 3.3 and found that my csv files are being written out with the junk "+.*-" character strings. I read the thread and there appears to be no way to avoid one's clean csv from being converted. This behavior did not occur in previous releases. I consider this a bug and will try to revert to an older version of OO until it is fixed.

--Dan

[kingfisher]

As acknak said, the text import dialogue enables you to select an appropriate code.

[edg]

Some of the answers given to this question were unhelpful and I don't consider it as "Solved". Here is the proper solution: The +AC0, etc. is showing because you opened the CSV document as UTF-7. Instead, the CSV file should be opened as UTF-8. Then it will save with quotation marks without you having to set filter parameters each time. If you have inadvertently saved as UTF-7, just reopen in Calc and set the filter to save with quotes. Next time you open the document, select UTF-8 and you'll be set from then on.