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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Oct 25 14:26:55 UTC 2020


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

            Bug ID: 137734
           Summary: chart in xlsx document created by openpyxl (python) is
                    displayed wrong
           Product: LibreOffice
           Version: 6.1.5.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: h5sk2n at magenta.de

Description:
Charts in .xlsx files created with python via openpyxl
(https://openpyxl.readthedocs.io/en/stable/) are displayed wrong.

Steps to Reproduce:
1. Create .xlsx file using python. for example:

from openpyxl import Workbook
from openpyxl.chart import BarChart, Reference

wb = Workbook()
ws = wb.active
for i in range(10):
    ws.append([i])

# drawing a graph
values = Reference(ws, min_col=1, min_row=1, max_col=1, max_row=10)
chart = BarChart()
ws.add_chart(chart, "A15")
chart.title = "Chart"
chart.y_axis.title = 'Size'
chart.x_axis.title = 'Test Number'
chart.add_data(values)

wb.save("Barchart.xlsx")

2. open "Barchart.xlsx" with Microsoft Excel
3. open "Barchart.xlsx" with LibreOffice Calc and see what's wrong

Actual Results:
The representation of the chart is wrong in LO Calc

Expected Results:
It should look like opened with MS Excel


Reproducible: Always


User Profile Reset: No



Additional Info:
I tested this with different Versions up to 7.0.2

-- 
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/20201025/25d2503f/attachment.htm>


More information about the Libreoffice-bugs mailing list