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: [email protected]
Reporter: [email protected]
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.
