Calc table compatibility with Excel

[CupcakeMedia]

What’s up!

I’ve gone through every single button in every single menu but I cannot for the life of me find it -

How the hell to you create a table in Calc?

At work, most of our main data analysis generators rely on using tables made in Excel. I just can’t figure out how to create a table in Calc for an equivalent effect. Anyone knows where the button for this is supposed to be?

[pab78]

What exactly do you want to do?

[CupcakeMedia]

We have an Excel sheet that contains a number of sheets and tables. In each sheet there is a table with the same rows: [[ID]:[ID]], [[Validation]:[Validation]] and so on. Basically it’s for data analysis of whatever it is we need to track. Excel and Spreadsheet both work, but we can’t add the table formulas in Calc.

[vebjorl]

I’ve also been looking for this feature, and I can’t seem to find it. I know what you mean, but when searching around on the forums there are a lot of people that don’t understand the difference between:

• Inserting a table in Writer - which is merly text formatting
• Punching in data within the worksheet in Calc and call that a “table”
• Actual creation/insertion of Table as in formatting/creating an object out of a range of cells so it is easier to manage and analyze this group of related data (MS Excel has this feature)

There are a few old threads also related to this (missing) feature:

[Calc] - Alternative to "Format As Table" feature in Excel 2007/2010/2013

At the moment you need to do this step by step: create named ranges, add autofilter and use autoformat for style. There is a Google Summer of Code idea proposal for implementing ranges/formula features. While right now there is no ongoing development, one could use the pointers from the proposal to develop or fund the development of such feature.

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?

Sadly I don’t think it is developed yet?

[mikekaganski]

If the feature you refer to is called “Data Table” in Excel (Data tab->What-If Analisys), then it must be “Multiple Operations” in Calc.

The original question is just another improperly asked question. A person who wants to get a useful response should have described it like “I use feature X in Excel like this: … . How do I get similar results in Calc?” instead of using a general term in presumption that everyone in the world would be familiar with some specific naming in a suite of that user’s choice.

Thanks @vebjorl for a useful information.

[AliceInWondermall]

Admittedly - if you read this question and don’t understand it then you wouldn’t be able to answer it even when you do understand.

But also -

I use feature X in Excel like this:
In the case of Excel tables, I don’t know how many people know or understand how a table works or differs from regular ranges. It’s in effect a sandbox, but the question already explains that.