Ask Your Question

Creating Tables in Calc

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

Greg gravatar image

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

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 +0100 )edit

6 Answers

Sort by » oldest newest most voted

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

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 +0100 )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 +0100 )edit

tankyou very much

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

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

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 +0100 )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 +0100 )edit

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

Doctor_Pi gravatar image

You might want to check this answer:

edit flag offensive delete link more

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

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 +0100 )edit

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

m.a.riosv gravatar image

Perhaps is this what you are looking for:

edit flag offensive delete link more

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

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
Login/Signup to Answer

Question Tools


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

Seen: 45,703 times

Last updated: Mar 02 '16