[Libreoffice-bugs] [Bug 142868] New: EDITING Not all chart data series should be allowed to be aligned to secondary Y axis

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142868

            Bug ID: 142868
           Summary: EDITING Not all chart data series should be allowed to
                    be aligned to secondary Y axis
           Product: LibreOffice
           Version: 7.2.0.0 alpha1+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nemeth at numbertext.org, varga.balazs3 at nisz.hu
            Blocks: 90486

Created attachment 172895
  --> https://bugs.documentfoundation.org/attachment.cgi?id=172895&action=edit
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


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=90486
[Bug 90486] [META] Chart bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210615/f2acd109/attachment.htm>