Ask Your Question
1

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

Comments

1

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
1

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

...you will now have an AutoFilter button on your toolbar.

edit flag offensive delete link more

Comments

Hello.

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
1

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
0

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

Doctor_Pi gravatar image

You might want to check this answer:

https://ask.libreoffice.org/en/questi...

edit flag offensive delete link more
0

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

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

edit flag offensive delete link more

Comments

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
0

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: http://help.libreoffice.org/Writer/Inserting_Tables

edit flag offensive delete link more
0

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

m.a.riosv gravatar image

Perhaps is this what you are looking for:

https://wiki.documentfoundation.org/R...

edit flag offensive delete link more
0

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

Comments

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

Question Tools

Stats

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

Seen: 29,394 times

Last updated: Mar 02 '16