Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 saving when I open, let's say file named 'somefile.myext'. Also I would need the loaded data to be placed in a prestyled spreadsheet.

In this particular case, I would need the CSV settings to have tab as a field delimiter and no text delimiter at all. Prestyled spreadsheet would contain Blue gray coloring for every odd row (achieved with conditional formatting formula), some font styling and probably some column width definitions.

share|improve this question

closed as too broad by Raystafarian, DavidPostill, mdpc, fixer1234, Scott Feb 22 at 5:37

There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs. If this question can be reworded to fit the rules in the help center, please edit the question.

    
almost sounds like you want to be able to create a program to take csv datasheets and format them into the style you want. This questions should probably goto SO and not SU. –  g19fanatic Feb 16 '11 at 19:50

1 Answer 1

You need a database then. CSV files are plain text, and therefore don't carry formatting. You can try to create a template, then import the data through Copy-Paste on another window, and tell it to use Destination Formatting

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.