<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - EDITING Not all chart data series should be allowed to be aligned to secondary Y axis"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142868">142868</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>EDITING Not all chart data series should be allowed to be aligned to secondary Y axis
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.2.0.0 alpha1+ Master
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Chart
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>libreoffice@nisz.hu
</td>
</tr>
<tr>
<th>CC</th>
<td>nemeth@numbertext.org, varga.balazs3@nisz.hu
</td>
</tr>
<tr>
<th>Blocks</th>
<td>90486
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=172895" name="attach_172895" title="Example file from Excel">attachment 172895</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=172895&action=edit" title="Example file from Excel">[details]</a></span>
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</pre>
</div>
</p>
<div id="referenced">
<hr style="border: 1px dashed #969696">
<b>Referenced Bugs:</b>
<ul>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] Chart bugs and enhancements"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=90486">Bug 90486</a>] [META] Chart bugs and enhancements
</li>
</ul>
</div>
<br>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>