Issue 11154 - Needed is the ability to use all the Calc database functions (dsum, dget etc) but with the range being direct from the datasource (F4). That is for example, the ability to sum up the sales for the month direct from the datasource and return a single cell
Summary: Needed is the ability to use all the Calc database functions (dsum, dget etc)...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 1.0.2
Hardware: All All
: P3 Trivial with 4 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: rfe_eval_ok, third_party_support
Depends on:
Blocks:
 
Reported: 2003-02-03 13:03 UTC by kelvine
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description kelvine 2003-02-03 13:03:29 UTC 
As an enhancement suggestion may I suggest the following.

The current spreadsheet database functions only work on the spreadsheet's 
database area.

What I would like is the ability to use all the Calc database functions
(dsum, dget etc) but with the range being direct from the datasource (F4).  
That is for example, the ability to sum up the sales for the month direct from 
the datasource and return a single cell result into the spreadsheet.

When talking about the datasource I am also saying both tables and queries.

This would mean people could more easily extract information from their 
external datasources for manipulation within Calc.

They could more easily use OpenOffice.org to produce management reports from 
core business data.

I noticed a number of people wanting better database facilities to help 
migrate from Microsoft Office to OpenOffice.org and I felt this might help 
convert some applications.

The other advantage of this approach is it makes the external data more 
accessible whilst not being restricted by the 32K row limit.

Hope this helps.

Kelvin
Comment 1 oc 2003-09-17 09:41:37 UTC 
Hi Bettina, one4you
Comment 2 bettina.haberer 2003-12-02 09:52:52 UTC 
Summary: Needed is the ability to use all the Calc database functions
(dsum, dget etc) but with the range being direct from the datasource
(F4).  
That is for example, the ability to sum up the sales for the month
direct from the datasource and return a single cell result into the
spreadsheet. 
Datasource: Concerns both tables and queries.

Considered for Office Later.
Comment 3 erwin.tenhumberg 2004-10-01 15:14:36 UTC 
enhanced summary, set keywords and reassigned issue according to RFE process
Comment 4 pagalmes.lists 2007-03-09 15:00:12 UTC 
+1