Issue 93894

Summary:

Trendlines in some OpenXML files disappear

Product:

Calc

Reporter:

hephooey <hephooey>

Component:

viewing

Assignee:

AOO issues mailing list <issues>

Status:

CONFIRMED ---

QA Contact:

Severity:

Normal

Priority:

CC:

elish, issues, rainerbielefeld_ooo_qa, robbin.knapp

Version:

3.3.0 or older (OOo)

Target Milestone:

---

Hardware:

OS:

Linux, all

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
sample file	none
Sample Excel file	none
Sample Excel file opened in Excel shows trend line	none
Sample Excel file opened in Calc does not show trend line	none

Description hephooey 2008-09-15 02:50:06 UTC

I have some OpenXML files generated by M$ Office 2007, which use trendlines in 
the files. They can be viewed normally in Office 2007, but when I try to open 
it in OpenOffice 3 RC1, I cannot see the trendline or the fit formula. I tried 
to convert the OpenXML .xlsx file to old Office 2003 .xls format, and I still 
cannot see the trendline. I do not know if this is related to the fact that 
OOo does not have polynomial regression support as we try to fit a quadratic 
function.

Comment 1 hephooey 2008-09-15 03:00:40 UTC

Created attachment 56532 [details]
sample file

Comment 2 hephooey 2008-09-15 03:02:21 UTC

Now I think the problem is related to the polynomial regression support, if I 
change the trendline to linear function. I can see the line and the formula, 
the position of the formula on the plot is weird though

Comment 3 robbk 2009-02-04 13:54:34 UTC

We have a binary (not XML) Excel file with a polynomial trendline. The trendline
is not shown when opening in Calc 3.0. Excel offers 6 types of trendlines. Calc
only offers four. The polynomial trendline is missing in Calc. This needs to be
added. Let me know if you need my sample Excel file. We are running Windows.

Comment 4 robbk 2010-01-05 14:59:39 UTC

Created attachment 66998 [details]
Sample Excel file

Comment 5 robbk 2010-01-05 15:00:23 UTC

Created attachment 66999 [details]
Sample Excel file opened in Excel shows trend line

Comment 6 robbk 2010-01-05 15:01:04 UTC

Created attachment 67000 [details]
Sample Excel file opened in Calc does not show trend line

Comment 7 robbk 2010-03-24 15:41:54 UTC

Any chance of getting a Target milestone on this? Thanks.

Comment 8 Edwin Sharp 2013-11-19 17:47:40 UTC

No trendline and no formula visible in attachment 56532 [details].

AOO410m1(Build:9750)  -  Rev. 1539999
2013-11-09_04:08:11 - Rev. 1540252
Debian

Comment 9 Rainer Bielefeld 2014-03-03 18:33:54 UTC

Correct Version (observed first in 3.0 RC)