Issue 124286 - Legend of chart in saved as .xls in wrong position when reopened in AOO
Summary: Legend of chart in saved as .xls in wrong position when reopened in AOO
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2014-02-21 14:34 UTC by slacka
Modified: 2014-03-02 15:54 UTC (History)
2 users (show)

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

Attachments
Simple .xls chart missing legend after export (8.50 KB, application/vnd.ms-excel)
2014-02-21 14:34 UTC, slacka 		no flags Details
Orig file before saved in excel format (13.61 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-02-21 14:35 UTC, slacka 		no flags Details
Result after round trip (14.02 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-02-21 14:45 UTC, slacka 		no flags Details
Sample Document with screenshots (218.96 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-02-24 06:19 UTC, Rainer Bielefeld 		no flags Details
Show Obsolete (2) 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 slacka 2014-02-21 14:34:19 UTC 
Created attachment 82655 [details]
Simple .xls chart missing legend after export

Steps to reproduce:
1. Create a chart in OpenOffice Calc
2. Manually move the chart’s legend anywhere (without using the default positions, top, bot, left right)
3. Save the .xls file
4. Close the file
5. Open with Cal

Note: The legend is missing. Even if you do a print preview, the legend is not displayed. However, if you play with the chart by resizing, you can usually make the legend reappear. 

If you use the predefined positions(Edit->Format Legend->Position), all position settings are lost. The legend is reset to the right center position.
Comment 1 slacka 2014-02-21 14:35:15 UTC 
Created attachment 82656 [details]
Orig file before saved in excel format
Comment 2 slacka 2014-02-21 14:45:31 UTC 
Created attachment 82657 [details]
Result after round trip
Comment 3 Rainer Bielefeld 2014-02-23 09:15:16 UTC 
Probably related ot "Bug 124298 - Chart Legend: Position-Auto-Fit ruined after any manual modification "
Comment 4 Rainer Bielefeld 2014-02-24 06:18:11 UTC 
Legend in Sample 2014-02-21 15:34 CET, slacka invisible, but not lost, as you can see if you open document with "AOO 4.0.1 – German UI / German locale [Rev. 1524958 2013-09-20 11:40:29]" on German WIN7 Home Premium (64bit)", “historic” 4.0 User Profile used for all predecessor versions and do menu #Format -> Legend - Position - right.

Some more tests with own sample document (see new attachment):

1. Open Sample document
2. Save document as .xls (Excel 97)
3. close document, reopen with MS EXCEL Viewer
   > looks fine
4. Close document in Excel Viewer, reopen with AOO
    > Legend in third chart invisible

Additional Info:
(a) Effect is related to very particular circumstances, most of my
    attempts to reproduce the problem failed. For example if the document 
    contains chart titles
(b) In reporter's "2014-02-21 15:34 CET, slacka " you can make reappear the
    legend:
    Click chart (green control points appear)
    Drag and drop bottom middle control point 9 cell heights (or more)
    down: legend reappears
(c) clearly not a "sav-export" problem due to step 3
(d) might be related to Bug 124298, might e not, I am not sure.
Comment 5 Rainer Bielefeld 2014-02-24 06:19:54 UTC 
Created attachment 82675 [details]
Sample Document with screenshots

See comment above how to use.

I removed 2 attachments not necessary to understand problem
Comment 6 Rainer Bielefeld 2014-02-24 06:23:57 UTC 
(e) When open result from Comment 4 Step 3 already with missing with 
    server installation of "AOO 3.4.0 – German UI / German locale 
    [AOO340m1(Build:9590) - Rev.1327774]" on German WIN7 Home Premium (64bit)"
    own separate user profile
(f) was still ok with server installation of "AOO 3.4.0 – German UI 
    / German locale [AOO340m1(Build:9590) - Rev.1327774]" on German WIN7 
    Home Premium (64bit)", own separate user profile
Comment 7 Rainer Bielefeld 2014-02-24 07:39:26 UTC 
(g) I keep OS = All because I assume reporter's OS = Linux Mint 16 Petra
(h) Also reproducible with legend position = left and moved down manually
(i) further investigations shows that legend also reappears when I increase
    width of chart object (after double click) to double size