Issue 12527 - Query from within a formula
Summary: Query from within a formula
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.0.2
Hardware: PC Windows XP
: P5 (lowest) Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: rfe_eval_ok
Depends on:
Blocks:
 
Reported: 2003-03-20 20:30 UTC by jhansonxi
Modified: 2013-08-07 15:12 UTC (History)
1 user (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 jhansonxi 2003-03-20 20:30:19 UTC 
Need a query function in the spreadsheet that can be used from within a formula
to perform a single cell query against a data source and return a value.  I
often have to make custom reports based upon database data and it is a pain to
dump an entire table into a spreadsheet then pick out the data using complicated
VLOOKUPS.

Issue #11154 is similar.

Split from Issue# 12482
Comment 1 oc 2003-09-17 09:41:21 UTC 
Hi Bettina, one4you
Comment 2 bettina.haberer 2003-11-27 16:29:33 UTC 
Considered for 'Office later'.
Comment 3 bettina.haberer 2010-05-21 15:01:10 UTC 
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".