0
votes
0answers
13 views

How do I change the EOL character when importing a CSV file into Open Office Calc?

I've got a CSV file that has enclosed newline (\n and \r, mixed) characters in its data. Because the consumer of that file is not able to handle that correctly (out of my control) we decided to use ...
1
vote
0answers
79 views

Default font and cell padding when opening files in LibreOffice/OpenOffice Calc

I've seen solutions for setting a default font when creating new files. What about a default font (and cellpadding) when opening an existing CSV file? LibreOffice seems to always default to Liberation ...
0
votes
0answers
61 views

Disable prompt when opening a CSV file in LibreOffice/OpenOffice Calc

Every time I open a CSV file, LibreOffice presents me with a prompt asking to confirm Character Set, Language, and Separator options (tab, comma, semicolon etc). This prompt is not present in ...
0
votes
0answers
65 views

OpenOffice Calc with csv file produces Err:520

I'm loading a csv file into OpenOffice Calc (version 4.0.1) and in only 1 column I get 'Err:520' as the cell value. I checked under Tools->Options->OpenOffice Calc->View->Display to check whether ...
1
vote
0answers
38 views

How to make just one text column be unquoted in final CSV?

I'm using OO calc and i have one column with phone numbers that have leading 0s, which are vital for the number to be valid. I can format the cell as text but i do not want the numbers to be quoted ...
1
vote
1answer
109 views

Database workflow advice? [closed]

I've got a product database that I need to update a couple of times a week and am looking for some advice on what workflow I should setup. I can export my database from my online store as a CSV, I ...
1
vote
1answer
220 views

Delete cell content in Libre (Open) Office based on the cell value

I have a huge csv file (tens of thousands of rows) that I need to filter based on different criteria. After trying to find a proper CSV editor, I decided to use LibreOffice Calc. CSVed is great, but ...
4
votes
1answer
2k views

Saving to CSV file always adds quotation marks in OpenOffice

I'm trying to use OpenOffice Calc for editing CSV files with TAB as delimiter. No matter what I do, Calc is insisting on adding quotation marks (") to the strings. If a cell content is number only, ...
5
votes
1answer
2k views

Copy value in Open Office Calc

I have a handful of cells in several spreadsheets that contain =AVERAGE(<some range>) and when I try to copy them into another spreadsheet I just copy the function and get #REF!. Is there any ...
1
vote
1answer
445 views

How can I open a subset of a large (35MB) .xlsx file?

I have Ubuntu 10.04 running on a Dell Optiplex with 4GB of memory and two 3.16GHz processors. I received a 35MB spreadsheet. It opened in Gnumeric after 5 minutes with errors, and it hasn't opened ...
0
votes
2answers
4k views

OpenOffice ruined my CSV file - (how to save CSV on Linux with OpenOffice?)

I am running OpenOffice 3.2 on Ubuntu. I had a CSV (comma separated value) file which I had manually created. I opened it in OpenOffice, and entered about 100 items (to make use of using formulas to ...
0
votes
1answer
1k views

Remove last n chars from a column in a CSV?

Is there a way in microsoft excel or open office calc to remove the last n chars from a field. Lets say all fields in one column are 31 chars long and I want to remove the last 6 chars. Is there ...
1
vote
4answers
115 views

What is the least-error-prone way to share CSV data?

One of my jobs is to upload product data to the company store. The data is initially pulled from the company database by my supervisor, and she puts it into an Excel spreadsheet and exports as CSV. I ...
0
votes
4answers
912 views

Difference between CSV in Excel and CSV in OpenOffice.org

There are different implementations of Comma Separated Values; two of them are Microsoft Excel and OpenOffice. Is there any difference between these CSV implementations? For example both can open ...
3
votes
2answers
3k views

Set CSV import default to UTF-8 in Calc

Every time I open a CSV (comma separated values) document in OpenOffice.org Calc I get a dialog with CSV preferences. The current default character set is "Eastern Europe (ISO-8859-2)". I would ...