Issue 117785

Summary: calc mean_value line is not restored on reloading
Product: Calc Reporter: tjohn <tjohn>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: elish, issues, rb.henschel
Version: OOO330m20   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
file which had a mean line none

Description tjohn 2011-04-09 17:03:09 UTC
Upgraded from 3.2 to 3.3.
The mean_value line in my charts are not restored when reloading spreadsheets saved in Excel 97 format with OOo 3.2.

The mean_value lines must be manually reinserted into each chart for each data series.
Comment 1 tjohn 2011-04-09 17:23:50 UTC
Using only OOo 3.3, saving and reloading spreadsheets in Excel 97 format does not restore chart mean_value line. 

Requires manually re-editing each chart and re-creating the mean_value lines for each variable in chart in each workbook.
Comment 2 Regina Henschel 2011-04-09 19:20:41 UTC
As far as I know Excel does not have the feature "mean line". For to be sure all features of OOo are preserved, always store in ods format.
Comment 3 tjohn 2011-04-09 21:04:54 UTC
Understood. Please close or delete this bug report.
Comment 4 Oliver-Rainer Wittmann 2012-06-13 12:18:08 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.
Comment 5 Edwin Sharp 2013-07-12 14:21:24 UTC
Mean value disappears when re-open.

Rev. 1502185 Win 7
Comment 6 Edwin Sharp 2013-07-12 14:24:32 UTC
Created attachment 81060 [details]
file which had a mean line

created with 2.4.3 with mean line
re-open with 2.4.3 mean line gone
open with Rev. 1502185 and add mean line
re-open with Rev. 1502185 mean line gone
Comment 7 Rob Weir 2013-07-30 02:15:52 UTC
Reset assignee on issues not touched by assignee in more than 2000 days.