Issue 20487 - Q-PCD Database-18
Summary: Q-PCD Database-18
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2003-09-30 17:23 UTC by niklas.nebel
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description niklas.nebel 2003-09-30 17:23:21 UTC
Task tracking system for Childs



Product Requirement 
Calc should provide functions that allow to access database fields and meta data
in the spreadsheet. Currently no update access is possible for Spreadsheets.
Customers need write access . The contents of the spreadsheet documents cannot
be edited within the data source connection.   Importing data from other

Customer Need/Problem
Extend the functionality of the existing database functions that use spreadsheet
data instead of a real database today. The benefit is that the users can create
some kind of 'light reports' by just using the functions to get the data and
then apply the Calc calculations mechanisms. This would be similar to the stock
quote demo that was shown at LinuxWorld by Frank G. Need to make it possible to
import data from Spreadsheet rather than just accessing via data source.


Eng Effort

Eng Owner
Niklas Nebel

Product Concept
The preferred way to do spreadsheet calculations on data from a database is to
import the data into a database range in the spreadsheet. That way the possibly
time-consuming database operation is decoupled from the spreadsheet
calculations, as several formulas can use the same database range, and the user
can manually refresh the range, repeating the database operation. If it is
really necessary to do such calculations without the use of a database range, we
could implement an add-in function like those available for other spreadsheets.
This function would have to execute the database query every time the cell that
contains the formula is recalculated. A read/write data source for spreadsheet
documents is possible, but would inevitably lead to problems where the database
values are the result of some conversion (formula results, or number-to-text).
If these cells were also modifiable, it would be easy to inadvertently lose
information in the spreadsheet. The availability of spreadsheets as read/write
data source might also lead users to using spreadsheets where databases would be
more suitable, causing problems later. If we accept these problems, we can
implement the read/write access. Importing spreadsheet data into a database is
already possible via drag&drop of a cell range onto a 'Tables' entry in the Data
Sources window. Given the low priority and potential problems, nothing will be
changed for 'Q'.

Functional Specification
Comment 1 frank 2003-10-15 15:53:21 UTC
Hi Lutz,

please decide what to do.

Comment 2 frank 2003-10-16 11:41:51 UTC
reassigning for clarification
Comment 3 marc.neumann 2003-10-16 12:07:27 UTC
reassigning for clarification, if we do this for 'Q' or not.
Comment 4 frank 2003-10-16 12:24:46 UTC
Re-assigned I've said.
Comment 5 lutz.hoeger 2003-10-23 07:43:48 UTC
added keyword Q-PCD
Comment 6 Martin Hollmichel 2004-05-28 15:01:12 UTC
according to the announcement on releases
( this issue
will be re-targeted to OOo Later.
Comment 7 masupnicur 2010-11-10 16:15:09 UTC
Created attachment 73127
Comment 8 Rob Weir 2013-07-30 02:19:00 UTC
Reset assignee on issues not touched by assignee in more than 2000 days.