Apache OpenOffice (AOO) Bugzilla – Issue 1163
title for secondary y axis
Last modified: 2017-04-07 08:06:52 UTC
it isn't possible to set the title on the second axis (i need a true second axis that is independent of the first y axis , to represent different data)
.
what do you think of that? eg: -on x axis,i've the time -on first y axis i've the price of the oil -on the second y axis , i've the price of the wood So i need two y axis because the range of the price is very different.
I will get back to this issue asap
changing QA contact from bugs@ to issues@
I was going to start my own issue, but I think that the comments here and my need are closely related. It would be nice to plot two columns with respect to each other. For example, I want point 1 to be (A:1,B:1) point 2 to be (A:2,B:2) all the way down. Now all I can get is (1,A:1),(2,A:2), etc.
Re-assigned to Matthia Müller-Prove for further evaluation.
to Bettina, our central dispatcher for RFEs
Hello Matthias, please consider this Chart-RFE also for the Q (OO.o 2.0). BTW this miising feature has been experienced also internally.
changed summary
set target to OOo Later
*** Issue 56682 has been marked as a duplicate of this issue. ***
changed summary, added keywords, added me to CC
*** Issue 71730 has been marked as a duplicate of this issue. ***
I confirm this problem with OOo 2.3 m213
*** Issue 77633 has been marked as a duplicate of this issue. ***
Hi bm, The attached is the patch for this issue. I make the patch as a package, because it contains a new idl file. If you have any suggestion for the patch, please let me know. Thanks a lot. Best Regards, Weizhao
Created attachment 48352 [details] patch
Hi bm, The new patch of this issue is completed, and the final attachment is the specification. Please let me know your suggestion. Thank you very much.
Created attachment 48795 [details] new patch
Created attachment 48796 [details] specification
Hi bm, The attached file is the specification of menu structure. Thanks for your suggestion and other useful information in your last email. I'll do it better. Thank you very much.
Created attachment 48886 [details] specification
Thanks for the patch and the specification. There are still a couple of issues to solve. 1) Regarding the UI strings: In the menu we already use 'Secondary X Axis' so I think the according title should be called 'Secondary X Axis Title'. You have done this in the string STR_OBJECT_TITLE_SECONDARY_X_AXIS, but the menu and the title dialog is inconsistent. At least the menu should be changed to become consistent. Hm, with the title dialog there will probably be a space/layout problem, when using the lengthy wording 'secondary'. I would suggest to use a heading 'Secondary axes title' for the both additional edit fields and then skip '2nd'. I will ask MMP for input on this but he is on vacation this week. 2) The patch has a compilation conflict with a more up to date master (231) with the ResourceIds. You can avoid this by using the IDs 87 and 88 for STR_OBJECT_TITLE_SECONDARY_X_AXIS and STR_OBJECT_TITLE_SECONDARY_Y_AXIS. 3) The patch has a conflict during applying it on a more up to date master because one of the changed files was renamed: chart2/source/controller/dialogs/res_Titles.src is renamed to res_Titlesx_tmpl.hrc 4) We will get duplicate used HelpIds for HID_SCH_TITLE_SECONDARY_X and HID_SCH_TITLE_SECONDARY_Y when CWS chart14 gets integrated. This needs to be checked manually again before commiting. 5) Regarding the title dialog specification: For the new controls it says 'Enabled, If the current chart supports a secondary x axis' .But I think the implementation is like: 'Enabled, if the current chart has a secondary x axis'. This inconsistency should be resolved. 6) Formatting issue: All the date formats in the specifiction documents are corrupted somehow. Please keep in mind that the documents are english. 7) Pixel issue: The space at the bottom of the title dialog is to small. 8) Variable naming issue: The new parameter 'bShow' at the title resources should state more precisely what it is supposed to influence. Please call it bShowSecondaryAxisTitles or similar. ...more next time But you are on the right way!
->weiz: I talked to MMP and the final strings should be 'Secondary X Axis Title' for the menu and 'Secondary x axis' for the fixed text in the dialog (without heading). I already did the according changes to the resources (see attached patch), but the specifications needs to be updated still. I put some more intelligence into the positioning of the dialogs fixed texts and edit fields thus they now use the given space optimal depending on the local dependent strings. I also did correct all the above mentioned issues except point 5 and 6. And I found another problem with your patch: In the chart view you removed the titles from the model, that are currently not supported by the chart type. This is strictly forbidden! The view is for creating a visual representation only, the view is absolutely not allowed to change the model! I removed the wrong code and corrected it for the x axes title as an example. Please correct it for the y and z axis title also. The new patch is for a more recent version >= SRC680m226. weiz, the following issues have still to be done: 1) Don't create shapes for unsupported y and z titles in the chart view 2) Allow to insert titles for the secondary axes when they are supported by the chart type (so far the axis need to exist, but that criteria is to restrictive) 3) Change the specifications according to the final strings and correct the wrong formatting 4) Thoroughly test the new feature
Created attachment 49079 [details] patch 3 with further corrections and still open issues
adjusting target
->iha, bm: The new patch for this issue is submitted. Please find the final attachment. Please let me know if I miss anything.
Created attachment 49665 [details] patch_issue1163_1115
->weiz: Thanks for the patch. I will integrate it into CWS chart19. One thing of common interest may be: When introducing new menu items it is not necessary to set extra help ids anymore. This feature is deprecated. For some of the old menu entries the help id numbers are still in use especially in the test tool environment but in future only the UNO commands itself will be used for help or test tool access. So I removed menu:helpid=... from the both new menu items: <menu:menuitem menu:id=".uno:SecondaryXTitle" menu:label="" /> <menu:menuitem menu:id=".uno:SecondaryYTitle" menu:label="" />. There were some other minor issues I will send you separate mail for.
Fixed in CWS chart19. The changes for the specifications are online: http://specs.openoffice.org/chart/ChartInsertTitleDialog.odt http://specs.openoffice.org/chart/menus/MenuStructure.odt
*** Issue 84855 has been marked as a duplicate of this issue. ***
->Thomas, please verify in CWS chart19. The im- and export to xcel will be addressed with a separate issue 85164.
Created attachment 51470 [details] TCS_Title_for_secondary_axes
Verified in CWS chart19
Seen ok in current master -> closed
Although there is a menu item for the editing of the secondary axes title, there is no way to have a secondary axes title to edit, so the menu item is not available. There are two ways to create a secondary axis: - edit a data series and in "options" align it to the secondary axis, or, - insert a secondary axis Neither way a title for the secondary axis is created. Ooo 3.0 Windows Vista.
Sorry for the last report. I have found that i can insert a secondary axes title under the insert title menu. It is obious... :(