https://bugs.documentfoundation.org/show_bug.cgi?id=132780
--- Comment #40 from Baelor <[email protected]> --- I just tried this using your explanation. Yes, it works sort of, but it lacks so much functionality and simplicity for the user compared to Excel, this really merits a feature request. 0) Feature is hidden away in tab "Data". 1) No visual indication, that a range is even existing and how big it is. 2) New rows or columns are not added automatically. 3) No auto-replace of absolute cell adresses with cell range names within formulas. 4) No formatting options. PS: There are also data ranges in Excel and they behave similar to these in Calc. But "format as a table" adresses a different need and is not treated the same way. ********** As a long-time Excel user I made multiple attempts to switch to OOCalc and later LibreOffice Calc but it was (and is!) this missing feature "Format as table" that got me. This is **THE** feature of Excel that permits: - very fast and easy and clear structuring of data, - low risk of formula errors as well as - easy maintainability. Lots of the classic errors of tabular calculations can be avoided with this (on the surface) simple feature and therefore I use it wherever possible. ********** I really would like to see this implemented in an open-source solution because I want to finally ditch Excel and Microsoft. I would sponsor this feature with money, if this is possible. I have the yearly billing for Office 365 that I can allocate to this feature for LibreOffice, if someone takes up the ball. (In reply to Regina Henschel from comment #37) > (In reply to John Mills from comment #36) > > (In reply to Pedro from comment #35) > > > There's so many differences than it's not even funny. > > > > We can start with name: Database range is meaningless to the common user. > > > One can't even fathom it is supposed to be a similar functionality (hence > > > why it was placed in Data tab in Tabbed UI instead of Insert tab. In > > > Excel, > > > Table is in Insert tab). > > > Scope there: > > > 1 - Change name of "Define Range" uno command to Table. > > > 2 - Move command from Data Tab to Insert tab in Tabbed UI. > > There is no "Table" inserted. Compare with what happens, when you use > "Insert Table" in Writer or Impress. The term "Database Range" describes the > purpose and the features better than the term "Table". The term "Table" > means all of the cells. > That name "Database Range" exists for more than 25 years. OpenOffice and > LibreOffice users know it. Coming from Excel you simple need to learn, that > it is "Database Range" in LibreOffice. -- You are receiving this mail because: You are the assignee for the bug.
