[Libreoffice-bugs] [Bug 137734] FILEOPEN: Bar Chart in xlsx document created by openpyxl (python) is displayed wrong

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Oct 26 15:23:56 UTC 2020


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

NISZ LibreOffice Team <libreoffice at nisz.hu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|                            |75057
           See Also|                            |https://bugs.documentfounda
                   |                            |tion.org/show_bug.cgi?id=12
                   |                            |6133
                 CC|                            |libreoffice at nisz.hu

--- Comment #4 from NISZ LibreOffice Team <libreoffice at nisz.hu> ---
The differently colored data points happen because of the c:varyColors property
is missing from the generated file.

Opening this in Excel 2013 and saving it saves the tag as <c:varyColors
val="0"/>
so the default value - if omitted - must be 0.

Calc opens the Excel-saved version without differently colored data points.

So the default value - if omitted - must be changed to 0, since currently Calc
assumes a value of 1.

Another problem with the example file is the horizontal (category) axis label
being incorrectly rotated; we already have bug #126133 about that.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=75057
[Bug 75057] [META] OOXML Chart object issues
-- 
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/20201026/833f4104/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list