Ask Your Question

Creating Tables in Calc

asked 2012-08-13 01:23:47 +0200

Greg gravatar image

updated 2013-01-30 09:17:21 +0200

qubit gravatar image

In excel you can create a table simply by using insert->table. Is there a way to create tables in calc, as well?

edit retag flag offensive close merge delete



I'm not looking for how to create tables in writer, but in calc itself. In excel (as of 2007, I think) you can do this. It treats the cells differently than if they were just part of a spreadsheet.

Greg gravatar imageGreg ( 2012-08-14 22:20:23 +0200 )edit

6 Answers

Sort by » oldest newest most voted

answered 2016-03-01 22:56:38 +0200

Doctor_Pi gravatar image

You might want to check this answer:

edit flag offensive delete link more



This links leads to the most comprehensive and complete answer. :) gravatar ( 2019-03-14 09:50:47 +0200 )edit

answered 2014-03-20 16:44:03 +0200

Mycah gravatar image

AutoFilter (does the same thing as Insert Table in Excel)

This feature is called AutoFilter in Calc

  1. Select your data range
  2. Click: Data > Filter > AutoFilter

To add a single-click button, just add the Tools Toolbar to your view:

  1. Click: View > Toolbars > Tools will now have an AutoFilter button on your toolbar.

edit flag offensive delete link more



But how to change table name ?

When you extract an excel file, i saw xl/tables/table1.xml with information of table.

LibreOffice don't read and don't save this information.

Gwenael Pellen gravatar imageGwenael Pellen ( 2014-08-07 20:54:18 +0200 )edit

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

Mario J. gravatar imageMario J. ( 2014-10-16 21:07:10 +0200 )edit

tankyou very much

علیرضا ج gravatar imageعلیرضا ج ( 2016-12-22 23:55:12 +0200 )edit

answered 2012-08-13 06:21:39 +0200

linuxissue gravatar image

I suppose you can use the cells in Calc as table as indicated by this help:

edit flag offensive delete link more

answered 2016-03-02 00:37:07 +0200

m.a.riosv gravatar image

Perhaps is this what you are looking for:

edit flag offensive delete link more

answered 2013-01-30 09:16:49 +0200

qubit gravatar image

Hi @Greg,

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?

edit flag offensive delete link more



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.

Kaivosukeltaja gravatar imageKaivosukeltaja ( 2014-02-02 11:57:46 +0200 )edit

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...

MrZoolook gravatar imageMrZoolook ( 2016-12-01 12:03:44 +0200 )edit

This is actually a really powerful feature in Excel. If you routinely create tables of data with calculated columns (even as simple as total price = qty * unit price) then the Excel table saves a huge amount of effort: - It automatically populates the formula throughout the table - and continues to do so as you extend the table - It automatically moves cells below the table down to make room for new roles - You refer to columns by name rather than address which hugely improves readability as well as obviating the need to use absolute references - It enables autofilter on each column and allows several columns to have filters on them - The table can be referenced as a unit when used, say, as input to a pivot table - It automatically formats the tables with alternating row colors to aid readability - It allows you to total columns by name from outside the table (which ...(more)

sethsn gravatar imagesethsn ( 2019-10-08 04:15:56 +0200 )edit

So if the libreOffice developers ever decide to implement this feature the world will be a much happier place :-).

I ditched MS Office on my Mac in favor of libreOffice for stability and speed but I confess I do miss this one feature.

sethsn gravatar imagesethsn ( 2019-10-08 04:17:24 +0200 )edit

answered 2014-09-13 10:19:27 +0200

Yes, you can. Insert->Object->Chart

edit flag offensive delete link more



There is a difference between the words create and insert. The question was regarding creation of a table, not insertion of a table.

Bus42 gravatar imageBus42 ( 2016-08-01 16:52:24 +0200 )edit
Login/Signup to Answer

Question Tools


Asked: 2012-08-13 01:23:47 +0200

Seen: 54,326 times

Last updated: Mar 02 '16