Ask Your Question
1

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

asked 2013-03-24 22:26:46 +0100

Yuriy Samorodov gravatar image

updated 2013-03-24 22:28:51 +0100

Hello Community!

There is a great feature in Excel 2007 an newer: Format as Table. It comes handy because with 3 clicks it does the following:

  1. Format headings and cells with data, applies borders and makes spreadsheet look very professional
  2. Applies a name to a the table making it a Dynamic named range as a whole.
  3. Makes each column a named range
  4. You may call each cell by its name like:

    =vlookup([@SearchTerm],TableToSearchIn[#All],1,0)

Here is a great video covering this feature in Excel: Excel 2010 Table Formatting

So the question is: Is there any way to do the same thing in LibreOffice Calc?

Thank you, Yuriy

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-01 21:59:45.497597

1 Answer

Sort by » oldest newest most voted
2

answered 2013-05-26 15:38:08 +0100

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.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-03-24 22:26:46 +0100

Seen: 8,063 times

Last updated: May 26 '13