Ask Your Question

Calc table compatibility with Excel

asked 2017-02-22 09:26:01 +0200

CupcakeMedia gravatar image

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?

edit retag flag offensive close merge delete


What exactly do you want to do?

pab78 gravatar imagepab78 ( 2017-02-22 14:01:45 +0200 )edit

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.

CupcakeMedia gravatar imageCupcakeMedia ( 2017-02-23 20:38:24 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2017-03-01 07:10:55 +0200

updated 2017-03-01 08:11:12 +0200

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.

edit flag offensive delete link more


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.

AliceInWondermall gravatar imageAliceInWondermall ( 2017-03-07 12:45:04 +0200 )edit

answered 2017-03-01 06:41:24 +0200

vebjorl gravatar image

updated 2017-03-03 05:41:38 +0200

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:

Sadly I don't think it is developed yet?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-02-22 09:26:01 +0200

Seen: 587 times

Last updated: Mar 03 '17