Qt Xlsx Two Dimensional Chart Generation issue

[kathcool]

I'm exploring the features and functionality of Qt Xlsx 0.3 library. I have modified the existing chart example code and found an issue while generating two dimensional chart with X and Y-axis.

Modified code :

for (int i=1; i<10; ++i)
    xlsx.write(i, 1, i*i);

for (int i=1; i<10; ++i)
    xlsx.write(i, 2, i*i);

Chart *lineChart = xlsx.insertChart(3, 3, QSize(300, 300));
lineChart->setChartType(Chart::CT_Scatter);
lineChart->addSeries(CellRange("A1:B9"));

Instead of CellRange "A1:B9", i have tried with alternate options ("1,1,9,2") / ("A1:A9", "B1:B9") but not generating the expected graph.

I have manually created the Expected chart (Created-Chart-on-MSExcel.png) and attached here for your reference.

Please find the attached graph images

"QtXlsx-Generated-Chart"

"Created-Chart-on-MSExcel.png" - Manually created using MSExcel with same data range

[kathcool]

Thank you

Do you have any work around or when can i expect solution for this issue

[dbzhang800]

Hi, the Issue should be fixed now, you can give a try to the master branch and play with the chart example again.

[kathcool]

Hi

I have tried with latest master branch, but make fails while building "xlsxworksheet.cpp" file

make[2]: Entering directory ../QtXlsxWriter-master/src/xlsx' g++ -c -g -O2 -fstack-protector --param=ssp-buffer-size=4 -Wformat -Werror=format-security -D_FORTIFY_SOURCE=2 -O2 -std=c++0x -fvisibility=hidden -fvisibility-inlines-hidden -fno-exceptions -Wall -W -D_REENTRANT -fPIC -DQ_USE_APPMENU -DQT_BUILD_XLSX_LIB -DQT_BUILDING_QT -DQT_NO_CAST_TO_ASCII -DQT_ASCII_CAST_WARNINGS -DQT_MOC_COMPAT -DQT_USE_QSTRINGBUILDER -DQT_DEPRECATED_WARNINGS -DQT_DISABLE_DEPRECATED_BEFORE=0x050000 -DQT_NO_EXCEPTIONS -D_LARGEFILE64_SOURCE -D_LARGEFILE_SOURCE -DQT_NO_DEBUG -DQT_GUI_LIB -DQT_CORE_LIB -I/usr/share/qt5/mkspecs/linux-g++ -I. -I../../include -I../../include/QtXlsx -I../../include/QtXlsx/0.3.0 -I../../include/QtXlsx/0.3.0/QtXlsx -I. -I/usr/include/qt5 -I/usr/include/qt5/QtGui -I/usr/include/qt5/QtGui/5.0.2 -I/usr/include/qt5/QtGui/5.0.2/QtGui -I/usr/include/qt5/QtCore -I.moc/release-shared -o .obj/release-shared/xlsxworksheet.o xlsxworksheet.cpp xlsxworksheet.cpp: In member function ‘void QXlsx::Worksheet::validateDimension()’: xlsxworksheet.cpp:2311:33: error: ‘class QMap<int, QMap<int, QSharedPointer<QXlsx::Cell> > >’ has no member named ‘firstKey’ int firstRow = d->cellTable.firstKey(); ^ xlsxworksheet.cpp:2312:32: error: ‘class QMap<int, QMap<int, QSharedPointer<QXlsx::Cell> > >’ has no member named ‘lastKey’ int lastRow = d->cellTable.lastKey(); ^ xlsxworksheet.cpp:2322:43: error: ‘const class QMap<int, QSharedPointer<QXlsx::Cell> >’ has no member named ‘firstKey’ if (firstCell == -1 || it.value().firstKey() < firstCell) ^ xlsxworksheet.cpp:2323:36: error: ‘const class QMap<int, QSharedPointer<QXlsx::Cell> >’ has no member named ‘firstKey’ firstCell = it.value().firstKey(); ^ xlsxworksheet.cpp:2325:42: error: ‘const class QMap<int, QSharedPointer<QXlsx::Cell> >’ has no member named ‘lastKey’ if (lastCell == -1 || it.value().lastKey() > lastCell) ^ xlsxworksheet.cpp:2326:35: error: ‘const class QMap<int, QSharedPointer<QXlsx::Cell> >’ has no member named ‘lastKey’ lastCell = it.value().lastKey(); ^ make[2]: *** [.obj/release-shared/xlsxworksheet.o] Error 1 make[2]: Leaving directory../QtXlsxWriter-master/src/xlsx' make[1]: * [sub-xlsx-make_first] Error 2 make[1]: Leaving directory `../QtXlsxWriter-master/src' make: * [sub-src-make_first] Error 2

[dbzhang800]

Hi, seems the issue is caused by #43. As a workaround, your can make Worksheet::validateDimension() as an empty function.

void Worksheet::validateDimension()
{
}

[dbzhang800]

HI, FYI, the issue should be fixed now. You can give a try to the latest master branch

[kathcool]

Thanks for your prompt response. 2D chart generation works fine now.