https://bugs.documentfoundation.org/show_bug.cgi?id=132780
--- Comment #37 from Regina Henschel <[email protected]> --- (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. > > > > Moving on. > > When one defines a table in Excel, it provides a Table design with a Table > > Style. Database Range has nothing. > > > > It has a handle to drag the Table to the neighbor columns and rows. Database > > range has nothing visible. > > > > Scope: > > 1 - Implement a table style upon creation of a database range. > > 2 - Implement a handle to expand table size. Yes, you need to style the cell range in a separate step. You can do it independent from defining a database range. Yes, changing the source area is currently not possible by dragging. You need to modify the source area in the "Define Range" dialog. You should write a feature request for each. > > > > When selecting the Range in Calc in a completely different command (hidden > > in a menu) it is possible to expand the range of the table. However, it does > > not propagate the table style. It fills the new cells with new values based > > on expanded table. > > > > When creating a Table in Excel, a new tab in the UI is created (Table > > Design) with multiple options to change the design of the table (Header Row, > > First Column, Last Column, Banded Rows, Total Row, Last Column, Banded > > Columns). Nothing in Database Range. > > > > Scope: > > Table Styles. Any type of table styles. AutoFormat table styles should be > > implemented to Selected Range. It should be possible to better configure > > AutoFormat styles. Yes, a binding of a table style to a Database Range does not exist. Currently the feature "Table style" lacks a lot. You will find several bug reports. Currently a "Table style" is not a style but more like a stencil. You need to apply it again after changes in the area size. > > > > There's the option to export the table data to Sharepoint list. Is write access to a Sharepoint possible, if you do not have a license for Microsoft Office? > > > > There's a Tools group with: > > 1 - Remove Duplicates, will come in LibreOffice 25.2 > > 2 - Insert Slicer, Not really needed, UI gimmick. > > 3 - Convert to Range Data > Define Range > Delete > > 4 - Summarize with PivotTable. Data > Select Range; Data > Pivot Table. [..] > This is 100% correct, there is a considerable disparity between Excel and > Calc here. Features available for Database Range in LibreOffice, I do not see in Excel: Can reflect a table or query of an external database. Can sort with different algorithm Can filter case sensitive Can filter using regular expressions Output filtered data to different sheet -- You are receiving this mail because: You are the assignee for the bug.
