# Creating Tables in Calc

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

First time here? Check out the FAQ!

We will be migrating from Ask to Discourse on the first week of August, read the details here

Creating Tables in Calc

2

You might want to check this answer:

1

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

0

Indeed, when an Excel Table is extended, Excel generates a new row, uses banding color for clarity, copies formulae present in the existing row, moves cell focus to the new row and 1st column, etc... It is a real time saver.

But, there is another significant advantage to Excel Tables not yet mentioned here: **Associated Charts Are Extended Automatically**

- Assume you are in Excel and you've created a Table with 1 row of headers and 5 rows of data/formulae/etc...
- Assume you've created a Chart (e.g. line graph) that includes all 6 rows (header + data).
- When you extend the Excel Table, Excel creates and inserts a new empty row automatically. When you the user enter the data/formulae/etc... the row is now complete. The associated Chart automatically adds that new complete row into the Chart. This is incredibly helpful and saves time.

Use-Case: Financial Data Entry

- Your row might include a date, a cost basis, a current market value.
- You have 5 months of data, from January 1, 2020 to May 1, 2020. Your Chart has 5 data points.
- When you extend the Excel Table and add a 6th set of data, your Chart automatically extends to include the 6th set of data (e.g. June 1, 2020). Normally, you would have to edit the chart and the chart's data ranges. That takes time and multiple clicks.

In summary, I would be happy to see LibreOffice add Excel Tables as a feature.

0

0

Perhaps is this what you are looking for:

0

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

0

0

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?

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.

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)

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)

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.

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

0

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

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

Seen: **83,986 times**

Last updated: **Jan 04**

Remove <style> element when cut from Calc and pasted into another application [closed]

How do I export a chart in an image format from LibreOffice Calc? [closed]

Are there plans for a "papercut" project for libreoffice [closed]

Is it normal for Calc goal seek to take very long? [closed]

Please refine "Search" in Calc - implement functions in Gnumeric [closed]

LibreOffice Calc will not link to external data via internet [closed]

Is there a LibreOffice .odt, .ods viewer for Android? [closed]

Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.

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.