Issue 86465 - Excel import/export: new chart error bar functionality
Summary: Excel import/export: new chart error bar functionality
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@graphics
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-02-26 09:01 UTC by bjoern.milcke
Modified: 2013-02-24 21:22 UTC (History)
1 user (show)

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

Attachments
test document for import/export (19.00 KB, application/vnd.ms-excel)
2008-04-03 10:58 UTC, daniel.rentz 		no flags Details
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 2008-02-26 09:01:47 UTC 
With the integration of CWS SRC680/chart20 (might become DEV300/chart20 soon) there are two new 
features available that can now be used by the Excel import/export filters:

* The error bar style "standard error" is now available.
  The "ErrorBarStyle" property is now a constant with predefined values in css::chart::ErrorBarStyle. 
(namespace chart, not chart2!)

* Error bar values (for y-error bars) can be taken from cell ranges.
  The ranges can be created via the data provider like it is done for series. The ErrorBar object implements 
an XDataSink for setting and XDataSource for getting the sequences.
Comment 1 bjoern.milcke 2008-02-26 09:03:16 UTC 
Setting target to 3.0

->DR: should be realistic as this is not UI-relevant, right?
Comment 2 daniel.rentz 2008-02-26 09:18:18 UTC 
started
Comment 3 bjoern.milcke 2008-02-29 16:42:26 UTC 
->dr: Note that the enum css::chart2::ErrorBarStyle was replaced by the constant
group css::chart::ErrorBarStyle. Please use the latter instead. As the Excel
filter is the only place now using the chart2-enum, it would be nice to remove
this file in offapi.
Comment 4 daniel.rentz 2008-03-03 08:22:43 UTC 
thanks for the hint, will use the const group
Comment 5 daniel.rentz 2008-04-03 10:58:02 UTC 
Created attachment 52492 [details]
test document for import/export
Comment 6 daniel.rentz 2008-04-03 12:38:27 UTC 
fixed in cws DEV300/dr61 (OOo 3.0)
Comment 7 daniel.rentz 2008-06-04 13:25:17 UTC 
back to QA
Comment 8 oc 2008-06-19 13:46:48 UTC 
Loading the exported error bar gives an error in Excel
Comment 9 oc 2008-06-19 13:47:32 UTC 
reassigned to dr
Comment 10 daniel.rentz 2008-06-24 10:38:24 UTC 
This error occurs in Excel2007 with ServicePack 1 only (!), when reading manual
error bars exported by Calc... Older versions of Excel (including Excel2007
without SP1) do not have a problem with these files. sigh...

fixed in DEV300/dr61 (OOo 3.0)
Comment 11 daniel.rentz 2008-06-24 13:21:42 UTC 
back to QA
Comment 12 oc 2008-06-25 14:50:21 UTC 
verified in internal build cws_dr61
Comment 13 thorsten.ziehm 2009-07-20 15:58:42 UTC 
This issue is closed automatically and wasn't rechecked in a current version of
OOo. The fixed issue should be integrated in OOo since more than half a year. If
you think this issue isn't fixed in a current version (OOo 3.1), please reopen
it and change the field 'Target Milestone' accordingly.

If you want to download a current version of OOo =>
http://download.openoffice.org/index.html
If you want to know more about the handling of fixed/verified issues =>
http://wiki.services.openoffice.org/wiki/Handle_fixed_verified_issues