![]() you can just tick "Save content as shown" and leave "Fixed column" unticked, and skip the next two paragraphs, or you can "eat your vegetables", and revel in the discourse to follow. The options controlled two tick boxes are a little esoteric. Text delimiter: Use the quotes marks, even if your data has quotes marks in it. Whatever is going to import what you are exporting can probably deal with either. These settings are what you won't see if you haven't ticked the "Edit filter settings" box earlier.Ĭharacter set: You are unlikely to want to change this.įield delimiter: You probably want to use either a comma or the tab character. ![]() The next dialog has three things to set, and two tick boxes. ("Current" is CSV, even though, as you haven't saved in CSV yet, "current" isn't quite the way I'd describe it. unless you've turned these warnings off (Bad Idea) get a new dialog, asking you if you want to "Keep Current Format" or "Save in ODF" Elect "Keep Current". (If you do lots of CSV exporting, and always use the same settings, you can untick this.) If the "Edit filter settings" box (bottom of dialog) isn't ticked, tick it. ![]() Use the "Save In" and "File name" boxes to set where your data is saved, and the file's name, in the usual way. If you have saved in CSV previously, you can "turn the questions back on" by doing a Save As in some other format, and then going back to doing a Save As in "Text CSV (.csv)" Some of the following only come up the first time you save some data in a CSV file, unless you take steps. Having caught your rabbit (got the data into an ooCalc worksheet), you just do a simple "Save As." (Details follow.)Īt the bottom of the Save As dialog box, change "Save as type" to "Text CSV (.csv)" Empty cells to the left of, or above your table result in extra (if empty) items at the start of each line, or extra lines at the start of the CSV file.) (Empty cells to the right of, or below your table are ignored. If your data is in an ooBase table or query, just go to the ooBase main project manager window, right click on the name of the table or query (don't try this for a form, it won't work, or for a report unless you want to explore things I haven't explored!), click on "copy", and then proceed as before: Go to an ooCalc sheet, click on the cell which will be the upper left corner of the table in the ooCalc sheet, and then press ctrl-V.Īs saving to CSV always saves all of the current ooCalc sheet, it will pay you to paste anything to be saved in a CSV file into the upper left hand corner of an empty sheet. If your data is in a table in ooWriter, you can just select the columns and rows you want, press ctrl-C, move to an ooCalc sheet, click on the cell which will be the upper left corner of the table in the ooCalc sheet, and then press ctrl-V csv from databases.įirst move your data onto an ooCalc worksheet. ![]() (The link will take you to that thread.) Much of what follows is also relevant, even to exporting. If you want to export data from a database, there is a useful discussion about some details of that in a thread about exporting records from an Open/ Libre Office database at. On this page you can learn how to create a CSV file from data in any Open Office application. Page contents © TK Boyd, Sheepdog Software, 3/06-3/17.Įxporting from Open Office Applications to CSV Files _ (Enlarge, reduce, restore to default, respectively.) (This is more fully explained, and there's another tip, at my Power Browsing page.) With most browsers, pressing plus, minus or zero while the control key (ctrl) is held down will change the texts size. Make your browser window as wide as you want it. There's more about ooBase in the main index to this material. and saving million$, but still Getting The Job Done. Big organizations, governmental and civilian, are adopting it as their standard office suite. Open Office's database, "Base", aka "ooBase" is free! But don't let that fool you. You may find that the database being shipped with OpenOffice (ver.2 and higher) delights you as much as it has me. Open Office TutorialsĬreating CSV files from Open Office Applications TABLE OF CONTENTS for Open Office database tutorials. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |