Ask Your Question

How to "format as a table" as in Excel ? [closed]

asked 2020-12-28 20:23:29 +0200

ThierryH2 gravatar image

This seems a recurring question in this forum, but it too quickly gets closed with an "answered" tag, which is, in my opinion, wrong (the closest question I found was created in 2015 :

=> So, I'm re-opening the topic once again.

This Excel feature is really a key one for a spreadsheet management tool such as... Excel... or Calc ! We are using those tools to manipulate data, organized in tables. That's the core feature of those tools...

Before Excel introduced the "format as table" feature, we had to do all the stuff "by hand". AND TO MAINTAIN IT when the table content was changing. Very uncomfortable and time consuming...

Today, with this feature, it is very simple to:

  • organize dynamic data in table (named range, easier references in external vlookup,...)
  • create a footer with smart formulas (sum, subtotal,...), that remains a footer, whatever you add/remove in the table and that don't get sorted in the table content flow...
  • add new lines in the range (simply press tab key at the end of the table)
  • get formulas automatically created in the columns (limit risks of mistake)
  • use explicit column titles as names in the formulas (simplify writing and maintenance)
  • get a consistent auto formatting (such as alternate colors for rows,...) whatever sort/insert/delete action you can do on the table itself
  • ...

Is there any target to get this replicated in Calc ?

For sure, from a user perspective, this is not an "advanced" feature of Excel (even if technically, it could be a real pain to implement !)... It gets used by many "basic users" nowadays, and is dramatically missing from Calc.

Any hope to get this in the roadmap ?


edit retag flag offensive reopen merge delete

Closed for the following reason question is off-topic or not relevant by ebot
close date 2020-12-28 20:48:49.682215

1 Answer

Sort by » oldest newest most voted

answered 2020-12-28 20:47:01 +0200

ebot gravatar image

updated 2020-12-28 20:48:34 +0200

If you want to make suggestions for improvement, you are unfortunately wrong here. That's why such questions are closed again relatively quickly.

On this page, users help other users with problems they have with the application LibreOffice. Therefore your theme is off-topic here.

Please post your suggestions for improvement on Bugzilla. Thank you.

How to Report Bugs in LibreOffice

edit flag offensive delete link more


OK. That's clearer now (with your comment, it clarifies for sure !) I will try to log an enhancement in Bugzilla... Thanks

ThierryH2 gravatar imageThierryH2 ( 2020-12-28 21:20:01 +0200 )edit

Question Tools

1 follower


Asked: 2020-12-28 20:23:29 +0200

Seen: 102 times

Last updated: Dec 28 '20