[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