[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 Rafael Lima changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||5067 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 Rafael Lima changed: What|Removed |Added CC||rafael.palma.l...@gmail.com --- Comment #21 from Rafael Lima --- This is a much needed feature in LibreOffice Calc. Whenever I teach LO Calc to Excel users, this is possibly the #1 feature that they miss. And I personally agree that this feature provides awesome UX and it should exist in LO Calc (alongside Table Slicers - see Bug 119807). The "Format As Table" feature in Excel is not only about formatting, but rather about providing functionality that makes it much simpler to work with tables, as pointed out in Comments #19 and #20. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 NISZ LibreOffice Team changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||4786 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 --- Comment #20 from j...@protonmail.com --- Tables are ubiquitous in any Excel spreadsheet I make. I'm very happy to see everything that's been implemented so far. It makes feature parity seem very possible. Here are the gaps I consider most important: - The @ operator to specify a structured reference to a cell in the current row. Calc's syntax to accomplish the same thing is much more verbose, implicit, and, as far as I know, undocumented. - Calculated columns: some way to ensure that every cell of a field inside a database range uses the same formula, that changing the height of the range will also copy the formula, that changing the formula in one cell will change it for the whole column. - The ability to rename a database range, updating the name in any references elsewhere in the workbook. - Formula bar autocomplete for structured reference syntax, especially when selecting a range of cells. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 --- Comment #19 from Thierry --- I filed a duplicate of this request (sorry !), explaining again some of the good reasons to add this feature. As I mentioned in my request: 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 - ... And I fully agree with @Pedro : no, this is not a bug of Calc loosing formatting, but a request for enhancement. => we are looking for introducing this notion of "table" I really think we need this feature in Calc, to be able to continue using LibreOffice as a standalone alternative to Microsoft Office in a consistent and effective way... I also realize it may not be easy to develop, but, at least, let's track this need and look at it... Thanks ! -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 m.a.riosv changed: What|Removed |Added CC||t_hu...@yahoo.fr --- Comment #18 from m.a.riosv --- *** Bug 139291 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 NISZ LibreOffice Team changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||6541 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 Thomas Lendo changed: What|Removed |Added Blocks|108019 |107977 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=107977 [Bug 107977] [META] Calc feature enhancements https://bugs.documentfoundation.org/show_bug.cgi?id=108019 [Bug 108019] [META] Calc UX bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=66 ||377 Blocks||108019 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108019 [Bug 108019] [META] Calc UX bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 --- Comment #17 from Pedro --- (In reply to Roman Kuznetsov from comment #16) > I think it's a dupe of bug 66377. > > Pedro, what do you think? That bug seems to be about Calc losing formatting of tables created in Excel. It is related but not the same thing, since I want to focus on including the functionality in Calc, not only just keeping the Excel formatting. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added CC||79045_79...@mail.ru --- Comment #16 from Roman Kuznetsov <79045_79...@mail.ru> --- I think it's a dupe of bug 66377. Pedro, what do you think? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 Heiko Tietze changed: What|Removed |Added CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda |.freedesktop.org|tion.org Keywords|needsUXEval | --- Comment #15 from Heiko Tietze --- (In reply to Eike Rathke from comment #14) > I agree, those Table features are still missing. Removing UX for now. Please ping if you need input. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 Eike Rathke changed: What|Removed |Added Version|6.4.0.3 release |Inherited From OOo -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 Eike Rathke changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #14 from Eike Rathke --- I agree, those Table features are still missing. There was a GSoC idea for the table styles but that never got picked up, https://wiki.documentfoundation.org/Development/GSoC/Ideas#Implement_table_styles I just added this bug for reference there (or actually changed it from the old outdated and misleading one). -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 QA Administrators changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 --- Comment #13 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 --- Comment #12 from Pedro --- That's just one of the functionalities. I mentioned plenty of others: These tables have several elements: Header row - All tables have filtering enabled in header row to sort or filter quickly. Banded rows - Alternate shading to distinguish data. Calculated column - insert a formula in one cell in a table column and you can create a column in which that formula is applied to all cells in the same table column. Total row - Can add a total row to a table. Excel will provide an AutoSum drop-down liist to select from functions Sizing handle - a sizing handle in the lower right corner that allows to drag and make the table the size I want (selecting which cells are part of it).~ These allow the quick automation and make data manipulation in tables really easy and simple. To me simplicity first means making work easier for end-users, not simplicity by decreasing work for developers and having a less feature complete piece of software. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 Heiko Tietze changed: What|Removed |Added CC|heiko.tietze@documentfounda | |tion.org| --- Comment #11 from Heiko Tietze --- My take: simplicity first. If you want to make charts of growing sheets use a pivot table or special functions. We don't need to copycat all Excel inventions. But let's see what Eike thinks. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 --- Comment #10 from Pedro --- No,it's not the same as Autoformat Styles. Tables in Excel have numerous specific functionalities attached to them that I clearly enumerated in the first post and in the attachments. AutoFormat Styles is just an aesthetic change to a number of cells that you select. Furthermore, you can't select Autoformat Styles to less than a 3x3 cell selection (which is quite silly). -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 Heiko Tietze changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #9 from Heiko Tietze --- Isn't it the same as Format > Autoformat Styles...? https://help.libreoffice.org/6.4/en-US/text/scalc/guide/autoformat.html (Also known as Table Style in Writer; see also bug 101802) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 V Stuart Foote changed: What|Removed |Added CC||vstuart.fo...@utsa.edu See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=85 ||063 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 QA Administrators changed: What|Removed |Added Whiteboard| QA:needsComment| -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #8 from m.a.riosv --- Partially implemented. https://wiki.documentfoundation.org/ReleaseNotes/5.0#Table_structured_references https://wiki.documentfoundation.org/ReleaseNotes/5.1#Table_structured_references -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 Telesto changed: What|Removed |Added CC||libreoffice-ux-advise@lists ||.freedesktop.org Keywords||needsUXEval -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 --- Comment #7 from Pedro --- Created attachment 160864 --> https://bugs.documentfoundation.org/attachment.cgi?id=160864=edit OnlyOffice Desktop Editors has same feature and has GPL3 license Important thing to mention: OnlyOffice Desktop Editors has an initial implementation of this feature. It's licensed under GPL v3 so maybe its code for this feature could be used as a blueprint to introduce this feature in Calc? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 Pedro changed: What|Removed |Added Attachment #160451|Explainer of tables in |Explainer of tables in description|Excel 365 |Excel 365 5 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 --- Comment #6 from Pedro --- Created attachment 160452 --> https://bugs.documentfoundation.org/attachment.cgi?id=160452=edit Explainer of tables in Excel 365 6 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 --- Comment #5 from Pedro --- Created attachment 160451 --> https://bugs.documentfoundation.org/attachment.cgi?id=160451=edit Explainer of tables in Excel 365 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 --- Comment #3 from Pedro --- Created attachment 160449 --> https://bugs.documentfoundation.org/attachment.cgi?id=160449=edit Explainer of tables in Excel 365 3 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 --- Comment #2 from Pedro --- Created attachment 160448 --> https://bugs.documentfoundation.org/attachment.cgi?id=160448=edit Explainer of tables in Excel 365 2 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 --- Comment #4 from Pedro --- Created attachment 160450 --> https://bugs.documentfoundation.org/attachment.cgi?id=160450=edit Explainer of tables in Excel 365 4 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132780] Feature Request: Add Calc Tables with functionality similar to Excel tables
https://bugs.documentfoundation.org/show_bug.cgi?id=132780 --- Comment #1 from Pedro --- Created attachment 160447 --> https://bugs.documentfoundation.org/attachment.cgi?id=160447=edit Explainer of tables in Excel 365 1 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs