Issue 125788 - RFE Tables for Calc feature urgently wanted
Summary: RFE Tables for Calc feature urgently wanted
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 4.1.1
Hardware: PC Windows 7
: P3 Normal with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: usability
Depends on:
Reported: 2014-10-23 22:45 UTC by King Z
Modified: 2014-10-24 07:26 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Tables-Sorted areas. Shows exactly what i am explaining. Used in answering a question someone posted (45.89 KB, image/png)
2014-10-23 22:45 UTC, King Z
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description King Z 2014-10-23 22:45:00 UTC
Created attachment 84106 [details]
Tables-Sorted areas. Shows exactly what i am explaining. Used in answering a question someone posted

In OpenOffice you can make auto filter columns and use them as tables. But they are still not as functional as MS Office excel (even as far back as excel 2003)

Tables are some of the most used things you can find in excel, very very handy and very functional with the right formulas

I would like someone to make this feature for OpenOffice, in MSoffice;

* you can select the table and it gives you the option to add a new line

* it only creates a new line in the table, not across the entire spreadsheet

* it copies the border, colour and any formulas to the next line

* it also changes any linked formulas (to entire columns/rows within the table) so that it then includes the new entry into the table

* you can also select the table (it actually is called table 1,2,3 etc., when you link formulas to the table it comes up with TABLE1)

* also extra features like 'Add Totals Row' etc.

In OpenOffice, You can auto filter, but this still is not a table.
You can highlight an area with headers, click on > DATA \ FIlter > Auto Filter
This will then turn the "table" into a sorted by header area, limited to the selected area.
If you do not have headers or have a blank in the headers, it will say there are no headers and will ask you if you want to use headers on the first line <YES> <NO>

In this picture i have shown you that you can;
use multiple AutoFilter areas on one page
auto change linked formulas (you have to INSERT ROW on the 'any' or last line of the formula)
will copy the borders and colour down, but not the formula within the table
Inserts row across entrie page not just within the table, which can cause major headaches
Comment 1 Andreas Säger 2014-10-24 07:26:16 UTC
Tables are "database ranges". But database ranges are not fully implemented.

1. Database ranges should expand calculated fields on insertion.
2. Database ranges should insert and delete rows within their own area.
3. Database ranges should obsolete Tools>Options>Calc>General "Expand references ..."
4. Database ranges should NOT copy the header formatting when inserting below the header row.
5. Database ranges should remember their filter settings even when you turn off the filter temporarily (like Base does).

On the other hand there is the most useful Base component which gives a lot more than alleged table ranges on spreadsheets.
When a database range in Calc is linked to a true database row set, point 1 and 2 are well implemented, 3 and 4 are not issues anymore and for point 5 there are additional ways to filter and unfilter a list (and use them in Calc or not).

Since virtually "nobody" is able to develop even the most simplistic database, I developed a macro driven solution for the spreadsheet addicted: (Expand list ranges) which covers point 1, 2 and 3 even when no database range has been defined using the concept of "current region".
I have another unpublished macro which addresses point 5 which makes use of the fact that the range address of a criteria range is preserved in the FilterDescriptor of a db-range after you removed the filtering.