[Issue 125788] New: RFE Tables for Calc feature urgently wanted

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=125788

          Issue ID: 125788
        Issue Type: DEFECT
           Summary: RFE Tables for Calc feature urgently wanted
           Product: Calc
           Version: 4.1.1
          Hardware: PC
                OS: Windows 7
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: ui
          Assignee: issues@openoffice.apache.org
          Reporter: King_ZZR@live.co.uk

Created attachment 84106
  --> https://issues.apache.org/ooo/attachment.cgi?id=84106&action=edit
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

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 125788] RFE Tables for Calc feature urgently wanted

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=125788

King Z <Ki...@live.co.uk> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |usability

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 125788] RFE Tables for Calc feature urgently wanted

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=125788

Andreas Säger <vi...@t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |villeroy@t-online.de

--- Comment #1 from Andreas Säger <vi...@t-online.de> ---
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:
https://forum.openoffice.org/en/forum/viewtopic.php?f=21&t=2350 (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.

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.