Ask Your Question
3

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

2

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

8 Answers

Sort by » oldest newest most voted
2

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

Comments

1

This links leads to the most comprehensive and complete answer. :)

loved.by.Jesus gravatar imageloved.by.Jesus ( 2019-03-14 09:50:47 +0200 )edit
0

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

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

edit flag offensive delete link more

Comments

1

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 2020-04-16 23:19:27 +0200

ratkiley gravatar image

updated 2020-04-16 23:43:08 +0200

It seems that Calc separates the complex assortment of features included in Excel's "Insert Table" formatting, named ranges, and filtering / sorting. AutoFormat / Themes both are LibreOffice Calc's equivalent of Excel's "Insert Table" formatting. 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.

https://www.techrepublic.com/blog/tr-...

edit flag offensive delete link more
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

1

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
1

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

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.g. here https://ask.libreoffice.org/en/question/17859/automatic-formula-when-add-row/).

Thanks again to sethsn. I would upvote you if I had any karma ...(more)

ChristophC gravatar imageChristophC ( 2019-11-24 23:43:43 +0200 )edit

https://www.youtube.com/watch?v=0nbka... at minute 37 explains this REALLY good. this is a killer feature, and libreoffice should really try to get this done.

flypenguin gravatar imageflypenguin ( 2019-12-30 15:07:21 +0200 )edit

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. In the data dropdown, choose "Define range", and then select the area for the table and name it.

Testestestest gravatar imageTestestestest ( 2020-02-02 06:21:38 +0200 )edit

@Testestestest - That feature in LibreOffice Calc is not Dynamic, it only creates a data range of what you already have... its nothing like Tables in Excel at all, the same feature as this in Excel will be to select the area and give it a name... that is neither dynamic... I just tried it in LibreOffice Calc 6.4...

To everyone saying that the "Create Datarange" in LibreOffice do the same as "Tables" in Excel, it do not, It is not dynamic, it do not dynamically extend the data range with new row (as a table in i.e. Base do...

The "Data - Define Range" in Calc only define a static range, as if selecting a Range with Cells in Excel and giving it a name...

StoltHD gravatar imageStoltHD ( 2020-02-22 05:38:55 +0200 )edit
0

answered 2020-02-02 06:22:30 +0200

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. In the data dropdown, choose "Define range", and then select the area for the table and name it.

edit flag offensive delete link more

Comments

That feature in LibreOffice Calc is not Dynamic, it only creates a data range of what you already have... its nothing like Tables in Excel at all, the same feature as this in Excel will be to select the area and give it a name... that is neither dynamic... I just tried it in LibreOffice Calc 6.4...

StoltHD gravatar imageStoltHD ( 2020-02-22 05:29:20 +0200 )edit
Login/Signup to Answer

Question Tools

Stats

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

Seen: 72,431 times

Last updated: Apr 16