Issue 119457 - [From Symphony] Import .xlsx file, chart legend position will be changed from top right to right.
Summary: [From Symphony] Import .xlsx file, chart legend position will be changed fro...
Status: REOPENED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-05-28 09:38 UTC by Shan Zhu
Modified: 2017-05-20 11:27 UTC (History)
5 users (show)

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

Attachments
Chart legend position in MS Excel2007/2010 (90.69 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-05-28 09:38 UTC, Shan Zhu 		no flags Details
support the chart legend positon of top&&left. (2.19 KB, patch)
2012-08-31 03:36 UTC, zhaoshzh 		no flags Details | Diff
update patch (3.53 KB, patch)
2012-09-10 02:21 UTC, zhaoshzh 		zhangjf: review+
Details | Diff
Screenshot before & after fix in AOO and the UI in Excel. (57.25 KB, image/jpeg)
2012-10-08 10:12 UTC, Shan Zhu 		no flags Details
Show Obsolete (1) 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 Shan Zhu 2012-05-28 09:38:46 UTC 
Created attachment 77642 [details]
Chart legend position in MS Excel2007/2010

Build info: r1327774 

Steps:
1. Open the sample file attached in AOO.
(There are 5 chart in it, each chart has different legend position)
2. Check the Legend position of the last chart.

Issue:
OO can not find a mapping value for "Top Right", it changed it to the default position. So you can see the legend position will be changed into Right, and legend will be moved to the middle of right side.
Comment 1 zhaoshzh 2012-08-31 03:34:19 UTC 
support the chart legend positon of top&&left.
just set the Anchor to Alignment_TOP_RIGHT.
Comment 2 zhaoshzh 2012-08-31 03:36:31 UTC 
Created attachment 79252 [details]
support the chart legend positon of top&&left.
Comment 3 zhaoshzh 2012-09-10 02:21:37 UTC 
Created attachment 79363 [details]
update patch
Comment 4 zhang jianfang 2012-09-14 15:01:14 UTC 
Comment on attachment 79363 [details]
update patch

Add support the chart legend positon of top&&left, just set the Anchor to Alignment_TOP_RIGHT
Comment 5 zhang jianfang 2012-09-14 15:03:19 UTC 
committed by revision 1384809.

And change to resolve state.
Comment 6 Shan Zhu 2012-09-19 02:56:33 UTC 
Verified on AOO350m1 r1387022. 
The Legend will be moved to the most top right corner.
But the size of diagram can not be calculated properly in chart is incorrect. It makes a overlap. It is a worse looking.

Can not change status into "Verify".
Comment 7 zhaoshzh 2012-09-21 01:58:04 UTC 
can you create a snapshot picture for the diagram ?
Comment 8 Shan Zhu 2012-10-08 10:12:02 UTC 
Created attachment 79746 [details]
Screenshot before & after fix in AOO and the UI in Excel.

Pls check the screenshot. I've listed the UI before and after your fix. And a UI in Excel for comparison. You can find that the current UI does not resolved the issue on root cause. The chart looks worse than before.
I wanna to reopen this issue for further fix.
Comment 9 Shenfeng Liu 2012-10-09 07:25:42 UTC 
set Target Milestone to AOO 3.5.0 for PM purpose.
Comment 10 binguo 2012-11-16 05:18:24 UTC 
Verified on Aoo_Trunk_20121109.1800 Rev.1407366, there is still issue occurs,please refer to the attached screenshot named "Screenshot before & after fix in AOO and the UI in Excel." listing the UI before and after your fix. And a UI in Excel for comparison. You can find that the current UI does not resolved the issue on root cause. The chart looks worse than before.
So reopen it for further fix. thanks.
Comment 11 Marcus 2017-05-20 11:27:38 UTC 
Reset assigne to the default "issues@openoffice.apache.org".