Before you insert a table into a document, it helps to have an idea of the visual result you want to obtain as well as an estimate of the number of rows and columns required. Every parameter can be changed at a later stage; however, thinking ahead can save a large amount of time as changes to fully formatted tables often require a significant effort.
To insert a new table, position the cursor where you want the table to appear, then use any of the following methods to open the Insert Table dialog box:. Under Nameyou can enter a different name than the OOo-generated default for the table. This might come in handy when using the Navigator to quickly jump to a table. Under Sizespecify the initial number of columns and rows for the new table.
You can change the size of the table later, if necessary. Under Optionsset up the initial table characteristics. Selecting the options in this section of the dialog produces the following results:. The AutoFormat button opens a dialog from where it is possible to select one of the many predefined table layouts. See Automatic formatting of tables for more information. After making your choices, click OK. Writer creates a table as wide as the text area from the left page margin to the right page marginwith all columns the same width and all rows the same height.
You can then adjust the columns and rows later to suit your needs. You can create tables within tables, nested to a depth only limited by imagination and practicality.
The figure below demonstrates a simple, two-level example. To achieve this, simply click in a cell of an existing table and use any of the methods mentioned in Inserting a new table above. You can also create a table by typing a series of hyphens - or tabs separated by plus signs. Use the plus signs to indicate column dividers, while hyphens and tabs are used to indicate the width of a column. In order for this command to work effectively, the starting text needs to have clear demarcation between what will become the columns of the table.
Paragraph marks indicate the end of a row. In the top part of the dialog box, select the symbol that separates the columns.
This would normally be a tab, but it could be a semicolon or comma if you are importing a CSV file. The other options in this dialog are the same as those in the dialog used to insert a table shown above. In this case, the separator between elements is a semicolon. By selecting the text and applying the conversion, we obtain the following result. You can also use the Convert menu to perform the opposite operation; that is, to transform a table into plain text.
This may be useful when you want to export the table contents into a different program. Jump to: navigationsearch.
Apache OpenOffice 3 Writer Guide.Before you insert a table into a document, it is beneficial to have an estimate of the number of rows and columns required.
However, if necessary, you can easily make changes later. To insert a new table, position the cursor where you want the table to appear, then use any of the following methods to open the Insert Table dialog box:. Inserting a new table using the Insert Table dialog box. Under Nameyou can enter a different name than the OOo-generated default for the table. This might come in handy in case you want the tables displayed in the Navigator in a certain sorted way.
Under Sizespecify the initial number of columns and rows for the new table. You can change the size of the table later, if necessary. Under Optionsset up the initial table characteristics.
Selecting the check boxes in this section of the dialog produces the following results:. The AutoFormat button opens a dialog from where it is possible to select one of the many predefined table layouts. See AutoFormatting tables for more information. After making your choices, click OK. Writer creates a table as wide as the page margins, with all columns the same width and all rows the same height. You can then adjust the columns and rows later to suit your needs.
Tip: To directly insert a table with the default properties, click on the little arrow next to the Table icon on the Standard toolbar. To create the table, click on the cell that you want to be on the last row of the last column. Holding down the mouse button over the Table icon will also display the graphic. With OpenOffice. The figure below demonstrates a simple, 2 level example.
To achieve this, simply click in a cell of an existing table and use any of the methods mentioned in Inserting a new table. Nested table example. The shaded table is nested in a cell of the larger table.
Subscribe to RSS
Stack Overflow for Teams is a private, secure spot for you and your coworkers to find and share information. Base does not typically use update queries but see below.
Enter something similar to the following, then press Execute :. Under some circumstances it is possible to create an update query. It gives an error that The data content could not be loadedbut it still performs the update and changes the data.
To get rid of the error, the command needs to return a value. Learn more. How to create an update query with Open Office Base? Ask Question. Asked 4 years, 3 months ago. Active 4 years, 3 months ago. Viewed 5k times. Thomas Lamothe Thomas Lamothe 90 1 1 silver badge 7 7 bronze badges. Active Oldest Votes. Jim K Jim K 8, 2 2 gold badges 13 13 silver badges 35 35 bronze badges. If it works then please mark the answer as accepted. Sign up or log in Sign up using Google. Sign up using Facebook.
Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Featured on Meta. Feedback on Q2 Community Roadmap. Technical site integration observational experiment live on Stack Overflow.
How to Create a Table of Contents in OpenOffice/LibreOffice
This section is an exercise in explaining how the Wizard works. The Wizard permits the fields of the table to come from more than one suggested table. We will create a table with fields from three different suggested tables in the Wizard.
You have a choice of two categories of suggested tables: Business and Personal. Each category contains its own suggested tables from which to choose.
Each table has a list of available fields. In this step you give the fields their properties. When you click a field, the information on the right changes.
You can then make changes to meet your needs. See Figure 4. Click each field, one at a time, and make the changes listed below. If you have a large collection of music, you might want to create a table for each type of music you have. Rather than creating each table from the wizard, you can make a copy of the original table.
Each table can be named according to the type of music contained in it. Design View is a more advanced method for creating a new table.
It allows you to directly enter information about each field in the table. We will use this method for the tables of our database. The first table to be created is Fuel. FuelCost uses currency and two decimal places.Is there a way to create tables in calc, as well?
I'm not looking for how to create tables in writer, but in calc itself. In excel as ofI think you can do this. It treats the cells differently than if they were just part of a spreadsheet. AutoFilter is not nearly the same thing as Table.
Table is defined range that Excel is taking special care of. For example, each column of a table must have different name, and you can use this column names in formulas which makes formulas much more clearer to understand and check for errors. Also if you have Pivot tables that use Table as a source, you doi not have to worry to update source of your pivot when your table grows I use tables very extensively and I hope they will be in Calc soon.
The Calc AutoFilter feature provides the data sorting and filtering features of Excel's inserted Tables. Named ranges group the data together into a unit.
Why do you want to insert a table into a Calc spreadsheet? It doesn't seem like a feature that I'd use much, but perhaps there are some scenarios where it would be quite powerful?
In Excel, creating a table from an area is a powerful tool that creates dropdown menus for sorting and filtering the data, automatically extends any formulas when adding new rows and more. The name is a bit misleading and I'm hoping it exists in LibreOffice under a different name.
What a stupid comment. You know something, I don't wear dumb cowboy hats, That's not something I'd do. I suppose there might be some scenario that might need them This is actually a really powerful feature in Excel.
So if the libreOffice developers ever decide to implement this feature the world will be a much happier place This is a very old unsolved thread, so obviously it remains relevant. I just want to second sethsn's explanation of why this feature is so useful. Particularly important is the fact that it allows the user to automatically copy the formulas each time you, say, add a row of data.
By creating a table in Excel, the bottom range of the data set is defined so that by simply pressing "Tab" at the last cell, another row can be added that retains all formatting AND formulas from the above row. There are many other threads that have been marked as "solved" that are essentially asking how to do this, but one gets the feeling that other commenters and moderators do not quite understand the question e. Thanks again to sethsn. I would upvote you if I had any karma It already works, they are called database ranges.
I opened one of my old spreadsheets that already had a table in it and all of the normal table functionality that excel has works in Calc.This book was written by Edgar Rice Burroughs, the creator of Tarzan. Did you use this instructable in your classroom?Open Office 4 Calc Spreadsheet Beginners Tutorial
Add a Teacher Note to share how you incorporated it into your lesson. First create your document. All your TOC entries need be a Header. In this example I used Header3. Since I was using Header3 for my chapter titles I selected Level 3. This is normal. Now you need to click the white space to the right of the E button. Then click your Hyperlink button. Here it is A Table Of Contents with clickable links.
How to Make A Table In OpenOffice or LibreOffice
Note: if you make any changes to your document that would change the start location of your chapters etc. Thanks for the instruction. So far it works as expected, but when I print or export as pdf the page numbers disappear in the print page. Is there some explanation why this will happen?
Oh thank you! I'm sitting here at work, tired as a dog, needing to update my TOC and google brought me straight here and now it's done. More by the author:. About: Linux user. My last Windows was XP. Switched to Linux and never looked back.
My fath Add Teacher Note.The problem I am having is that once I create a table in the document, I don't know how to move it! I tried selecting the whole table you know, by moving my mouse cursor to the top left corner of the table so it turns into a diagonal arrowthen cutting it. But nothing happens. Dragging the table after selecting doesn't help either. This is becoming very frustrating, can any one educate me on how to move tables in a Writer.
One really needs the option to move tables where ever one needs to on a page. I'm sure the team at Scribus can show you the code needed to accomplish this. Office programs are blurring the line between DTP and simple word processing documents. These options are becoming a necessity for all objects on the page.
This makes a big difference. In Scribus you position areas within the page and you fill these areas afterwards with text. In Writer, content will progressively fill the page then allocate a new one.
But for frames, you don't define areas in the page. Even frames are not routinely anchored to page not recommended unless you are fully aware of the consequences but to paragraphs and flow with the paragraph. Based on LibreOffice 3. This step removes the contents of the cells but leaves the empty cells, which must be removed in step 6.
This pastes the cells and their contents and formatting. But I think the Documentation's method for "moving" a table is so cumbersome, and does not allow drag and drop, should count as a big bug, not an "enhancement" request!
In my opinion, it would be better to treat this problem as a request for enhancement. I realize this is a really old post, but I was wondering if there was any new developments with moving tables.
Moving a table by clicking and dragging still has the same bug as described above. Cut and Paste method isn't great as you can't have tables side by side. The frame method described below works, but slows the software down when there are too many frames in the document.
There are several bugs in the move table code at least under Windows and apparently on a Mac too. When you select a table the easiest way to select a whole table is to click on any cell and then use the menu Table, Select, Table the cursor should change to the Move cursor.
It doesn't. You still get the Edit cursor but you can use it to click and drag the table somewhere else. The Table with contents will be moved but a copy of the Table borders will remain in the original position which doesn't make any sense since you wanted to MOVE the table So your only option is to delete the Table borders that were left on the original position.
Pedro Wow this is a pretty big bug!! Can you tell me how to get the Edit cursor?