|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | Legend of chart in saved as .xls in wrong position when reopened in AOO | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Product: | Calc | Reporter: | slacka <lukebenes> | ||||||||||
| Component: | open-import | Assignee: | AOO issues mailing list <issues> | ||||||||||
| Status: | CONFIRMED --- | QA Contact: | |||||||||||
| Severity: | Normal | ||||||||||||
| Priority: | P3 | CC: | issues, rainerbielefeld_ooo_qa | ||||||||||
| Version: | 3.4.0 | Keywords: | regression | ||||||||||
| Target Milestone: | --- | ||||||||||||
| Hardware: | All | ||||||||||||
| OS: | All | ||||||||||||
| See Also: | https://issues.apache.org/ooo/show_bug.cgi?id=124298 | ||||||||||||
| Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||||||
| Developer Difficulty: | --- | ||||||||||||
| Attachments: |
|
||||||||||||
Created attachment 82656 [details]
Orig file before saved in excel format
Created attachment 82657 [details]
Result after round trip
Probably related ot "Bug 124298 - Chart Legend: Position-Auto-Fit ruined after any manual modification " 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.
Created attachment 82675 [details]
Sample Document with screenshots
See comment above how to use.
I removed 2 attachments not necessary to understand problem
(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 (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
|
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.