Created attachment 172895 [details] Example file from Excel Current Chart UI allows the user to align all chart data series to the secondary Y axis. This does not make much sense logically – even if ODF allows it – since it results in the same visual appearance as aligning the data to the primary Y axis and disabling the primary and enabling the secondary Y axis. Changing this behavior would match what the MSO UI allows, and it would allow better interoperability. Another aspect would be to not allow all data series to be aligned to the secondary Y axis. This also results the same visual appearance as aligning all data series to the primary Y axis while disabling the primary and enabling the secondary Y axis. MSO in this case changes the alignment of all data series to the primary Y axis instantly. LO changes this alignment on OOXML export, which can cause interoperability problems. Preventing users from aligning all data series to the secondary Y axis would create a more logical, less confusing streamlined UX, similar to what MSO has. Steps to reproduce: 1. Open attached file a) Open the left chart for editing b) Highlight the data series line, right click, select Format Data Series c) Under Options – “Align Data Series to” you can select between Primary and Secondary Y axis 2. Open the right side chart for editing a) Highlight each data series line, right click, select Format Data Series b) Under Options – “Align Data Series to” select the “Secondary Y axis” option for all three data series Actual results: 1 c) – The two options are selectable 2 b) – Upon reopening the Data series dialog the Secondary Y axis option is selected. Expected results: 1 c) – The two options should be greyed out 2 b) – Upon reopening the Data Series dialog the Primary Y axis option should be automatically restored after setting all three series to Secondary Y axis. LibreOffice details: Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community Build ID: 93a3e2f86c27b06062708fe788963a0e49f3a90b CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win Locale: en-US (hu_HU); UI: en-US Calc: CL
Created attachment 172896 [details] Screenshot of the first chart side by side in Excel and Calc with data series alignment options
Created attachment 172897 [details] The second chart in Excel before changing all data series alignment to secondary Y axis
Created attachment 172898 [details] The second chart in Excel after changing all data series alignment to secondary Y axis The secondary axis became visible, but alignment was reset to primary.
Created attachment 172899 [details] The second chart in Calc after changing all data series alignment to secondary Y axis The secondary axis became visible and the alignment stays to secondary Y axis. This makes no sense; you would need to have some data series set for the primary and some set for the secondary.
> This does not make much sense logically Primary and Secondary axes are for showing different scale data on the same chart, e.g. temperature and precipitation of the same area. In my opinion, if we have multiple charts, but some of them incomplete (typical in scientific data collected by different researches), e.g. there are only temperate data on chart 10 and precipitation data on chart 11, we don't want to change the appearance of these charts, losing better comparability of the full data set. In this case, "Primary" and "Secondary" are only labels without any preference, i.e. "Primary" is not the preferred scale. So I think, there is no reason to limit the users to use "Secondary" only with "Primary". I've attached some examples.
Created attachment 172906 [details] complete weather data
Created attachment 172907 [details] incomplete weather data
Created attachment 172908 [details] incomplete data with removed empty data series
Created attachment 172909 [details] removed empty data series resulted double scale
Removing the empty data series resulted a duplicate of the axis used by the not empty data series. This seems to be a bug for me, but it's very easy to fix it by deleting the unnecessary axis. See the attached test files and screenshots.
Created attachment 172911 [details] Duplicates removed by "Delete Axis"
Dear NISZ LibreOffice Team, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Dear NISZ LibreOffice Team, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp