1
vote
0answers
24 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
28 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
1answer
77 views

Set CSV as default import into a spreadsheet

In Libreoffice I can import a CSV file into a spreadsheet by simply double-clicking on the text file. In Openoffice 4.0 I have to click once on the text file to select it, then in the file type ...
0
votes
1answer
701 views

Set row delimiter in Excel

How can I use row delimiter other than \n? CSV fields contain \n and the row delimiter is \n\n\n\n, to separate line breaks in fields from the row delimiter. I'm using Excel 2010, and in need to ...
1
vote
3answers
1k views

Convert ZIP code to state in OpenOffice

I'm trying to move data from two of our old systems into a new system. Problem is, somewhere along the line the 'state' column of our DB was corrupted. I have a column of ZIP codes I need to ...
4
votes
1answer
762 views

Custom CSV (.csv) filter for OpenOffice.org or LibreOffice?

Is it possible to create a some kind of 'custom CSV filter' for OpenOffice.org or LibreOffice spreadsheet program. What I need is to have the program to use predefined CSV settings for loading and ...
0
votes
2answers
3k 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 ...
7
votes
1answer
1k views

Looking for a very fast to load lightweight csv viewer [duplicate]

Possible Duplicate: light text editor for csv file? (on windows) I frequently need to open csv files just to have a look at what is inside and what its structure is. I also may need to find ...
1
vote
2answers
302 views

Getting a Cross-Section from Two CSV Files

I have two CSV files that I am working with. One is massive, with about 200,000 rows. The other is much smaller, having about 12,000 rows. Both fit the same format of names, and email addresses ...
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 ...
3
votes
1answer
734 views

Read data from separate CSV file in OpenOffice Calc

I have a very large CSV file (many thousands of rows) that I want to work with. Due to the size of the file, I don't want to import it into openoffice. Rather, I want to create a spreadsheet that ...