Ask Your Question

Why do I get these strange symbols when uploading a file.

asked 2019-06-01 06:52:33 +0200

JackyAnn gravatar image

updated 2019-06-04 21:23:33 +0200

EDITED as I have concluded this is now more a Chromebook than a LO issue. I did manage to copy and paste as rtf but with a fresh download of LO it remained. I will add back if I find and learn anything on a Chromebook form that is relevant here.

Edited to say I have now attached two attachments made in LibreOffice and showing what happens. It gives a partial answer as I discovered pasting as RTF works.

It still begs the question of why all the other ways you can copy and paste have the strange symbols.

"You’ve achieved"

If I create a new ODT file and try to paste into that the same thing happens. In addition, if I simply copy and paste I get the problem and every sentence is numbered. When I try to paste special, then I lose the numbers and get the symbols.

This happens when I upload a file. Please, can someone tell me why and what to do? It also happens when I try to copy and paste into a downloaded template to another.

Thank you.

I am using a Chromebook. I uploaded to (Cannot use the editor in libreoffice so have to use the web version.) Due to Chromebook limitations I can only get libreoffice 5.2

In answer to comments about ISO's below:

The problem happens even copying from one Libreoffice file to another. The document where I first found the problem is a libreoffice ODT file. I uploaded using the Chrome browser. The document was formatted, but the problem is in the body text, not the headers. I understand what you say about the apostrophe but why would it happen in libreoffice files when I am not uploading to anywhere, but copying and pasting?

If the problem happens in ODT files, then is there something that I can do to change things in my version of libreoffice. Reinstalling has not solved the problem. Chromebooks can only get to Libroffice 5.2.

(I do not know how to put a BOM mark before a document. I am lost there. For people like me, we need not just the information you give, but also the information as to how you would actually do it from the point of opening the file! I will ask another question about that!)C:\fakepath\New origninal file.odt(/upfiles/15596383281019131.odt)

edit retag flag offensive close merge delete


This seems unrelated to LibreOffice. Perhaps you could ask the website to which you are uploading.

robleyd gravatar imagerobleyd ( 2019-06-01 10:30:17 +0200 )edit

I second robleyd's comment. The issue seems to be irrelevant here, especially considering that you specify that

Cannot use the editor in libreoffice

Anyway, what kind of file are you trying to process?

gabix gravatar imagegabix ( 2019-06-03 08:20:07 +0200 )edit

Please see my comment above. It IS relevant as I find the same thing happens when I copy and paste into a new libreoffice file. In fact I edited to say where I had first encountered the probllem in answer to the person who kindly did give me information.

JackyAnn gravatar imageJackyAnn ( 2019-06-04 06:21:32 +0200 )edit

Strange it happens in a LO-to-LO process. Can you attach a sample file if not confidential? Or at least an excerpt of it with the mishap.

ajlittoz gravatar imageajlittoz ( 2019-06-04 07:56:23 +0200 )edit

I suppose that OP ( @JackyAnn ) needs to re-write the question from scratch. I tried to read the question several times, and couldn't understand what happens when.

A good question would look similar to this: [OS version; LO version]

I open pre-existing ODT file (link here) (or create a new text document); write there these characters: "ABC" (using that keyboard layout); save it back; then close LO, and try to upload the file to resource XYZ using browser NNN. Then I open the file in web view, and see this: ... (screenshot). Or I select characters from here to there, press Ctrl+C to copy to clipboard, switch to another newly created text document, and Ctrl+V, and see this ...

The level of details you give determines if others, not standing behind you, will be able to understand your problem in the first place - the neccessary step to be able to ...(more)

Mike Kaganski gravatar imageMike Kaganski ( 2019-06-04 08:28:39 +0200 )edit

The downvote here looks unfair - I upvote to compensate. If someone downvotes: please provide some explanation in cases there's nothing obvious.

Mike Kaganski gravatar imageMike Kaganski ( 2019-06-04 08:30:15 +0200 )edit

If the problem happens in ODT files

Exactly, if. I can see no proof to it. The problem may be about the server, we don't know how files are processed. In such a case, you can't do much.

By the way, I tried to upload a sample ODT file produced with LO Writer containing a single phrase:

You’re right.

It has been processed correctly.

I've created and uploaded another one with the same content using LO Still processed correctly.

Can you share the file?

gabix gravatar imagegabix ( 2019-06-04 08:33:54 +0200 )edit

I have reinstalled LibeOffice. I have made a new file with different text and tried to copy and paste every way there is not uploading to anywhere and the problem remains. It happens wherever I copy or paste of upload but NOT if I copy from elsewhere and paste. There is no pont telling a chrome user anything to to with LO 6 and beyond. We cannot get it. We are limited to L0 5. It cannot be the server as the problem happens working in LO offline. I do not want to share a long file but will make and upload a short one. My current theory is this is related to LO on a Chromebook but I am away and cannot use other hardware to experiment.

JackyAnn gravatar imageJackyAnn ( 2019-06-04 10:42:32 +0200 )edit

the problem happens working in LO offline

Really? As I understand, the problem happens when you upload a file to the server.

gabix gravatar imagegabix ( 2019-06-04 10:53:58 +0200 )edit

@gabix: "and tried to copy and paste every way there is not uploading to anywhere and the problem remains"

Mike Kaganski gravatar imageMike Kaganski ( 2019-06-04 10:56:46 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2019-06-02 13:50:10 +0200

petermau gravatar image

updated 2019-06-04 18:30:42 +0200

If you are using an editor or system that does not support Unicode you will need to EXPORT your LibO file to downgrade the support character set. For example .txt. This will allow you to select ISO-8859-1 which should be supported by your prowritingaid. If not you could try US-ASCII as the system appears to only understand English. (I think, we in Europe would say English-US, rather than English-GB) You will probably have the same problem if you COPY/PASTE to go over to Chrome. What keyboard setting, language setup, data types does prowriting support?

Libreoffice and the Internet default to Unicode, the International standard since 1997 which supports about 138,000 characters. Unicode includes ISO-8859-1 (1987 vintage) which supports the first 255 characters used in Western Europe including England and France. And it supports US-ASCII (1968 vintage) the first 127 characters used in America.

As I mentioned above, if you copy and paste the system must support Unicode. If not you will have this problem. Also, if you EXPORT to a RTF file you must specify the character set your system understands. Otherwise the file again will be still Unicode. Have you defined your Chrome system Keyboard to support Unicode (UTF-8)?

It is importance to understand that copy / paste from one file to another, even if both are Libreoffice .odt files is controlled by the operating system settings, including language. The fact that both files use Unicode (UTF-8) is overuled by your operating system. A bit like having a colour camera, television but black and white film. I assume that one of your problems is there. Language is also important. If you are in Europe and use the € (Euro) sign, for example, you would have the same type of problem. This is why I asked what keyboard and Language settings you have defined. You may have not set these things yourself but they are important to sort out your problem which must be frustrating for you.

By the way, most of my users are not programmers.

edit flag offensive delete link more


You do not have to be one to think like one. I did edit to explain I was talking of a mindset. I am now pretty sure this is a Chromebook issue. My theory is Google wants to force us all to Google docs...

JackyAnn gravatar imageJackyAnn ( 2019-06-04 21:13:27 +0200 )edit

answered 2019-06-01 08:25:17 +0200

ajlittoz gravatar image

updated 2019-06-01 10:45:24 +0200

This looks like a confusion between Unicode and ISO-8859-x.

The source file is probably UTF-8 plain text. For some reason, the uploading process thought it was ISO-8859-x and converted it to Unicode giving the surprising text.

Edit your question to explain how you uploaded the text (which intermediate steps with which applications). Mention your OS, that could help to suggest tools.


I'd like more technical details on the process of uploading.

How was the initial file content typed? Locally with a text editor (not a document processor like LO)?

Was this initial file uploaded via the Chrome browser? Or some other tool/protocol like ftp?

I guess that you had a plain text (without any formatting effect like bold or italics) file which was uploaded using an HTML tool. HTML protocol uses "headers" to describe the exchanged data. One of these headers tells the recipient the character encoding used at source. It is ISO-8859-1 by default. When source file is plain text, there is no marker inside it (*) to contradict this default. At the other end, this wrong encoding is remembered.

When file is opened by LO, the byte stream is erroneously taken for an ISO-8859-1 while it is in fact an UTF-8 stream. Your original text is probably "You've achieved" with a typographical apostrophe U+2019 RIGHT SINGLE QUOTATION MARK, which UTF-8 encoding is 0xE2 0x80 0x99. 0xE2 is "â" both in ISO-8859-1 and Unicode which explains the first strange character. 0x80 and 0x99 are control characters in the C1 set; they may display strangely, accounting for the other characters.

You must find a way to force the uploading mechanism to transmit the file as an UTF-8 stream. If you can't select the encoding in the utility, try to put a "BOM" (byte order mark or ZERO WIDTH NO-BREAK SPACE) at the start of your file.

BOM is U+FEFF, but included as such in a UTF-8 stream, it may disrupt correct interpretation. Its UTF-8 encoding is 0xEF 0xBB 0xBF. This may be quite difficult to insert unless you have an hexadecimal editor.

(*) The only marker which can flag a plain text file is BOM appearing as the first character in the file.

edit flag offensive delete link more

answered 2019-06-04 21:50:23 +0200

gabix gravatar image

can someone tell me why and what to do?

I can’t tell why. I can tell what to do: wipe that ChomeOS and install Linux. Will work.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-01 06:52:33 +0200

Seen: 143 times

Last updated: Jun 04