Issue 87594 - trendline (regression curve) crashes Excel 2007
Summary: trendline (regression curve) crashes Excel 2007
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-03-29 18:28 UTC by aziem
Modified: 2013-02-24 21:19 UTC (History)
2 users (show)

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

Attachments
test documents made in OOo 2.4.0 Linux (45.73 KB, application/x-compressed)
2008-03-29 18:29 UTC, aziem 		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 aziem 2008-03-29 18:28:45 UTC 
Simple .xls spreadsheet with exponential regression curve in XY Chart crashes
Excel 2007 every time. 

To reproduce, open 4_curve.xls (made in OOo 2.4.0 Linux) in Excel 2007. 
Eventually, Excel 2007 recovers the file without the chart.

I also tested OOo 2.3.1 with same results.
Comment 1 aziem 2008-03-29 18:29:44 UTC 
Created attachment 52364 [details]
test documents made in OOo 2.4.0 Linux
Comment 2 maimon 2008-03-30 22:23:47 UTC 
The same happens with Excel 2003, but I don´t know if this must be called a
"bug" - Calc and Excel charts are incompatible in many ways.
Comment 3 aziem 2008-03-30 23:02:50 UTC 
I think there is a regression.  Around December, I had the same or similar
working with a developer's snapshot of OOo 2.4.0 with Excel 2003.  A few months
later (now), I went back to update my article with the OOo 2.4.0 final, and then
I noticed the crash with Excel 2007.
Comment 4 kla 2008-03-31 08:45:51 UTC 
confirmed, pls have a look.
kla
Comment 5 daniel.rentz 2008-04-02 13:26:24 UTC 
started
Comment 6 daniel.rentz 2008-04-02 13:43:30 UTC 
fixed in cws DEV300/dr61 (OOo 3.0)
Comment 7 aziem 2008-04-05 14:52:20 UTC 
FWIW, no crash in Excel 2003
Comment 8 jbierling 2008-05-08 19:21:26 UTC 
This does not appear to be fixed.  Beta 3.0 shows this same issue.  Beta 3 also
can lose existing trendlines saved in Excel 2007.
Comment 9 jbierling 2008-05-08 19:46:07 UTC 
A point of clarity -- Chart loses Excel's polynomial trendlines.  Linear
trendlines carry over.  But again, saving the document with a linear trendline
in Chart will crash Excel when Excel tries to open it.
Comment 10 daniel.rentz 2008-05-19 10:27:59 UTC 
This fix is not part of a released version of OOo yet. Target is OOo 3.0, so it
will be integrated in the 3.0 Final.

Our chart component does not support polynomial trendlines, see issue 20819,
therefore the Excel import filter drops these trendlines.
Comment 11 jbierling 2008-05-19 13:26:23 UTC 
OK, the fix was dated April 2 and the code freeze for the 3.0 beta was April 3
so I assumed it had made it.  I'll try testing this again with the next beta.
Comment 12 daniel.rentz 2008-06-04 13:41:12 UTC 
DR->OC: to verify, create a simple chart with trendline, save as XLS, load in
Excel 2007.

back to QA
Comment 13 oc 2008-06-13 14:48:30 UTC 
verified in internal build cws_dr61
Comment 14 nataliamhitekschool 2009-04-16 07:19:36 UTC 
verified in OOO310m9 - can be closed
Comment 15 thorsten.ziehm 2009-07-20 14:52:38 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