Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Problem w/ Line Charts, MS Excel 2016 32-bit #29

Open
ggodbold2 opened this issue Sep 14, 2018 · 2 comments
Open

Problem w/ Line Charts, MS Excel 2016 32-bit #29

ggodbold2 opened this issue Sep 14, 2018 · 2 comments

Comments

@ggodbold2
Copy link

Greetings - I'm trying to automate the creation of a chart. I can Bar Charts, Scatter, Pie charts with no problem. However, any Line chart cause and error upon loading the spreadsheet reported as "We found a problem with some content in SPREADSHEET_NAME. Do you want us to recover? YES/NO". There appears to be a mal-configuration in the underlying XML file.

This works fine -->
QXlsx::Chart *bar3DChart = xlsxDoc.insertChart(65, 4, QSize(300, 300));
bar3DChart->setChartType(QXlsx::Chart::CT_Bar3D);
bar3DChart->addSeries(QXlsx::CellRange("A50:C59"));

This causes some sort of corruption -->
QXlsx::Chart *line3DChart = xlsxDoc.insertChart(85, 4, QSize(300, 300));
line3DChart->setChartType(QXlsx::Chart::CT_Line);
line3DChart->addSeries(QXlsx::CellRange("A50:C59"));

Does anyone have any suggestions?

Thanks much!

@S5642
Copy link

S5642 commented Sep 25, 2018

I have met this issue, did you find out the problem or any solutions?

@ggodbold2
Copy link
Author

No, I never did. I think it could be solved be diving into the XML output. Unfortunately, I have no time to do this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants