Issue 20341 - Q-PCD EaseOfUse-24 (Calc as Data Editor)
Summary: Q-PCD EaseOfUse-24 (Calc as Data Editor)
Status: CLOSED WONT_FIX
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: Other Other OS
: P3 Trivial (vote)
Target Milestone: ---
Assignee: bjoern.milcke
QA Contact: issues@graphics
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-09-29 16:15 UTC by bjoern.milcke
Modified: 2013-02-24 21:21 UTC (History)
1 user (show)

See Also:
Issue Type: FEATURE
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 bjoern.milcke 2003-09-29 16:15:02 UTC 
Source: Dieter Loeschky

Category: Charts

Product Requirement:
Chart: Data source

Customer Need/Problem:

Difficult to edit data in charts with own data


Product Concept:

New data input concept using a spreadsheet

If a chart contains its own data, like in a presentation chart, this data may
currently only be modified by using the Chart Data dialog, which is quite
uncomfortable.  We will instead use the OOo Calc application as editor for
chart-internal data.  A stored chart document will contain a stream holding the
spreadsheet, thus there is no need to explicitly store the data agin.  This way,
we have the full functionality of OOo Calc in our data editor, which enables us,
amongst other things, to use formulas and external data sources.  Charts that
are embedded as OLE-objects will change the view to the spreadsheet when the
data editing command is executed.  Both views can be changed between by little
tabs at the bottom of the screen (like the sheet-tabs in OOo Calc).

Functional Specification
-
Comment 1 bjoern.milcke 2003-09-29 16:15:49 UTC 
.
Comment 2 lutz.hoeger 2003-10-23 07:44:03 UTC 
added keyword Q-PCD
Comment 3 bjoern.milcke 2004-04-28 15:14:16 UTC 
Title changed to something more meaningful.
Comment 4 Martin Hollmichel 2004-08-09 14:04:21 UTC 
according to http://www.openoffice.org/servlets/ReadMsg?list=releases&msgNo=7690
this issue will be set to OOoLater
Comment 5 kla 2004-10-04 14:03:29 UTC 
*** Issue 34838 has been marked as a duplicate of this issue. ***
Comment 6 kla 2004-10-08 12:17:35 UTC 
*** Issue 35123 has been marked as a duplicate of this issue. ***
Comment 7 bjoern.milcke 2005-09-06 16:35:11 UTC 
Due to technical reasons we are not able to implement this feature.

The OASIS Open Document format was just standardized.  The format for charts
that have their own data is specified that this data is listed in a single
<table:table> element that contains the data inside the <chart:chart> element of
the chart object.  Thus we are limited to a single spreadsheet.  Furthermore
there is no component that exports spreadsheets into an existing XML document as
sub-element.  And finally the import of OOo 2.0 can only handle tables where the
data is present in a contiguous block starting at cell A1, i.e. documents not
conforming to this would loose data.

The idea of using Calc was to get a powerful data editor with only little
effort.  The current situation, however, requires that we put effort in reducing
the power of this data editor (allow only one sheet, disable embedded objects,
disable any formatting, and probably also formulas, because this would get lost
in the round-trip with OOo 2.0), and in writing components that can transform
the spreadsheets in a conforming format.

As a result we get a data editor with little more power than the old one with a
big effort.

Additional Remark: We haven't found a suitable way to use a hybrid solution,
i.e., export the data in the usual way, plus exporting a spreadsheet as an
additional embedded object.  The main problem is to synchronize this data.
Comment 8 bjoern.milcke 2005-09-06 16:36:40 UTC 
closed
Comment 9 kla 2010-04-07 13:33:38 UTC 
*** Issue 110617 has been marked as a duplicate of this issue. ***