Created attachment 103394 [details]
Example file for spreadsheet tables feature
in Excel 2007 and newer, select a range, go to Home->Format as Table, and choose a table type. This sets that range as a "Table" along with the nice alternating row colors. Opening this file in Calc or creating a table in Calc will not display any colors.
Moreover, it is possible to refer to these tables by their name in cell formulas. Currently Calc has Err:508 where a cell refers to these table cells.
High - I think that this will be needed and cause headaches for certain users because to them it looks like data loss
@Andras - seems like these are two separate bugs but I figure it's on your radar
*** Bug 80956 has been marked as a duplicate of this bug. ***
Dupe of Bug 66377 - Feature request: Format As Table
Eike Rathke recently added support to recognize the tags, so the Err:508 should be gone now in LO 5.0.
*** This bug has been marked as a duplicate of bug 66377 ***
-There seemed to be two functions that Andras Timar requested on 20140724.
-One was the removal of the Err:508, which seems to have been completed.
-The second request was to build the 'table' functionality into Calc, modeled after Excel.
-The 'Table' function in excel manages many things easier including (but not limited to) named ranges, enhanced formatting and pivot table function, column names in formulas, expands said named range when new columns or rows are added, and generally better preps the data (normalizes) for use in a database environment more so than just using regular cells and named ranges.
-see thread here: https://ask.libreoffice.org/en/question/4767/creating-tables-in-calc/
-also microsoft's explanation here: https://support.office.com/en-us/article/Overview-of-Excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c
This one function is really the only reason that I (and i suspect many others) are still using MsExcel. It is a function that most excel users dont use b/c they dont know the benefits. Those that use it have more confidence in their results b/c of the softwares' managing of the named ranges (no cells are accidentally left out).
I am willing to pay for this functionality to be built into Calc if someone will do the coding (i dont know how). I know others will benefit greatly.
REOPENED is incorrect status - moving back to NEW.
As for paying - are you willing to pay hundreds if not thousands of dollars? That's likely how much it'll cost if you're going to hire a company. If you are willing to - I suggest contacting one of our certified developers to get a quote. Millions of lines of code, just tracking down the code can take several hours...at $100/hr (reasonable rate for consulting/coding), you're looking at a few hundreds to just track the code down.
As for "many users sticking with Excel" - so be it. That's now how we run the program - if there are features that our competitors have that we don't, we're not going to demand that volunteers implement those features just to appease users (who aren't the ones doing the work).
If you didn't mean to pay for the entire project yourself, you could always start a crowd funded project at:
Please post it here if you do.
Table formatting still not implemented in 22.214.171.124.alpha1+
Build ID: a5a71cea62ac3041006c5e9815ae2317999639ac
Eike Rathke has already laid the basic foundation allowing formulas that use reference by table to be imported and exported.