OpenOffice Calc import special characters in CSV incorrrectly? Announcing the arrival of...
Flight departed from the gate 5 min before scheduled departure time. Refund options
Tannaka duality for semisimple groups
What is the origin of 落第?
Can two people see the same photon?
What are the main differences between the original Stargate SG-1 and the Final Cut edition?
Printing attributes of selection in ArcPy?
How do living politicians protect their readily obtainable signatures from misuse?
Test print coming out spongy
My mentor says to set image to Fine instead of RAW — how is this different from JPG?
What initially awakened the Balrog?
What would you call this weird metallic apparatus that allows you to lift people?
Monty Hall Problem-Probability Paradox
I can't produce songs
What is a more techy Technical Writer job title that isn't cutesy or confusing?
Moving a wrapfig vertically to encroach partially on a subsection title
Does the Mueller report show a conspiracy between Russia and the Trump Campaign?
Asymptotics question
Mounting TV on a weird wall that has some material between the drywall and stud
Why complex landing gears are used instead of simple,reliability and light weight muscle wire or shape memory alloys?
Why not send Voyager 3 and 4 following up the paths taken by Voyager 1 and 2 to re-transmit signals of later as they fly away from Earth?
Where is the Next Backup Size entry on iOS 12?
Nose gear failure in single prop aircraft: belly landing or nose-gear up landing?
What does 丫 mean? 丫是什么意思？
How many time has Arya actually used Needle?
OpenOffice Calc import special characters in CSV incorrrectly?
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)Set CSV import default to UTF-8 in CalcLooking for a very fast to load lightweight csv viewerOpenOffice ruined my CSV file - (how to save CSV on Linux with OpenOffice?)OpenOffice Calc weighted averageCSV files cant store special characters?Excel 2007 doesn't preserve asian characters when converting to csvLibreoffice calc export to pdf. Some characters appear differentHow to export a spreadsheet to a UTF-8 .csv from Excel 2016 on mac?Why does LibreOffice Calc change CSV file Character Set?Anki import from CSV is not working
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I'm trying to import a CSV file to OpenOffice Calc, but the program is reading special characters incorrectly.
For example, one of the fields in the CSV is "Puma La Cerámica", but Calc imports it incorrectly. The same thing with another string "Puma Titán". Calc also reads it inccorrectly.
Here's the printscreen of the OpenOffice Calc Text Import:
I've been testing with the different formats in the dropdown "Character Set", but it remains the same. I changed the "Language" dropdown to "Spanish", but nothing. The csv file is in Spanish.
Any help is appreciated. For what it's worth, Excel reads it correctly.
csv openoffice openoffice-calc
asked 5 hours ago
rbhatrbhat
304112
add a comment |
I'm trying to import a CSV file to OpenOffice Calc, but the program is reading special characters incorrectly.
For example, one of the fields in the CSV is "Puma La Cerámica", but Calc imports it incorrectly. The same thing with another string "Puma Titán". Calc also reads it inccorrectly.
Here's the printscreen of the OpenOffice Calc Text Import:
I've been testing with the different formats in the dropdown "Character Set", but it remains the same. I changed the "Language" dropdown to "Spanish", but nothing. The csv file is in Spanish.
Any help is appreciated. For what it's worth, Excel reads it correctly.
csv openoffice openoffice-calc
asked 5 hours ago
rbhatrbhat
304112
Can we assume that any solution needs to be at your end (you have no control over how the CSV file is prepared)? The best solution would obviously be interpreting the data correctly on import. I haven't researched that, but I can think of a workaround until a solution is presented. There is only a limited number of these special characters, and Calc makes substitutions that are easy to identify. Worst case, you could apply a collection of SUBSTITUTE expressions to replace any such instances.
– fixer1234
4 hours ago
Thanks for your comment. I have no control over how the csv file is generated.
– rbhat
5 secs ago
add a comment |
I'm trying to import a CSV file to OpenOffice Calc, but the program is reading special characters incorrectly.
For example, one of the fields in the CSV is "Puma La Cerámica", but Calc imports it incorrectly. The same thing with another string "Puma Titán". Calc also reads it inccorrectly.
Here's the printscreen of the OpenOffice Calc Text Import:
I've been testing with the different formats in the dropdown "Character Set", but it remains the same. I changed the "Language" dropdown to "Spanish", but nothing. The csv file is in Spanish.
Any help is appreciated. For what it's worth, Excel reads it correctly.
csv openoffice openoffice-calc
asked 5 hours ago
rbhatrbhat
304112
I'm trying to import a CSV file to OpenOffice Calc, but the program is reading special characters incorrectly.
For example, one of the fields in the CSV is "Puma La Cerámica", but Calc imports it incorrectly. The same thing with another string "Puma Titán". Calc also reads it inccorrectly.
Here's the printscreen of the OpenOffice Calc Text Import:
I've been testing with the different formats in the dropdown "Character Set", but it remains the same. I changed the "Language" dropdown to "Spanish", but nothing. The csv file is in Spanish.
Any help is appreciated. For what it's worth, Excel reads it correctly.
csv openoffice openoffice-calc
csv openoffice openoffice-calc
asked 5 hours ago
rbhatrbhat
304112
asked 5 hours ago
rbhatrbhat
304112
asked 5 hours ago
rbhatrbhat
304112
asked 5 hours ago
rbhatrbhat
304112
asked 5 hours ago
rbhatrbhat
304112
304112
Can we assume that any solution needs to be at your end (you have no control over how the CSV file is prepared)? The best solution would obviously be interpreting the data correctly on import. I haven't researched that, but I can think of a workaround until a solution is presented. There is only a limited number of these special characters, and Calc makes substitutions that are easy to identify. Worst case, you could apply a collection of SUBSTITUTE expressions to replace any such instances.
– fixer1234
4 hours ago
Thanks for your comment. I have no control over how the csv file is generated.
– rbhat
5 secs ago
add a comment |
Can we assume that any solution needs to be at your end (you have no control over how the CSV file is prepared)? The best solution would obviously be interpreting the data correctly on import. I haven't researched that, but I can think of a workaround until a solution is presented. There is only a limited number of these special characters, and Calc makes substitutions that are easy to identify. Worst case, you could apply a collection of SUBSTITUTE expressions to replace any such instances.
– fixer1234
4 hours ago
Thanks for your comment. I have no control over how the csv file is generated.
– rbhat
5 secs ago
Can we assume that any solution needs to be at your end (you have no control over how the CSV file is prepared)? The best solution would obviously be interpreting the data correctly on import. I haven't researched that, but I can think of a workaround until a solution is presented. There is only a limited number of these special characters, and Calc makes substitutions that are easy to identify. Worst case, you could apply a collection of SUBSTITUTE expressions to replace any such instances.
– fixer1234
4 hours ago
Can we assume that any solution needs to be at your end (you have no control over how the CSV file is prepared)? The best solution would obviously be interpreting the data correctly on import. I haven't researched that, but I can think of a workaround until a solution is presented. There is only a limited number of these special characters, and Calc makes substitutions that are easy to identify. Worst case, you could apply a collection of SUBSTITUTE expressions to replace any such instances.
– fixer1234
4 hours ago
Thanks for your comment. I have no control over how the csv file is generated.
– rbhat
5 secs ago
Thanks for your comment. I have no control over how the csv file is generated.
– rbhat
5 secs ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1427811%2fopenoffice-calc-import-special-characters-in-csv-incorrrectly%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1427811%2fopenoffice-calc-import-special-characters-in-csv-incorrrectly%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Can we assume that any solution needs to be at your end (you have no control over how the CSV file is prepared)? The best solution would obviously be interpreting the data correctly on import. I haven't researched that, but I can think of a workaround until a solution is presented. There is only a limited number of these special characters, and Calc makes substitutions that are easy to identify. Worst case, you could apply a collection of SUBSTITUTE expressions to replace any such instances.
– fixer1234
4 hours ago
Thanks for your comment. I have no control over how the csv file is generated.
– rbhat
5 secs ago