Hi,
Thanks for your posting and using Aspose.Cells.
I understand the following issue. Also if you see the screenshot showing the chart image, it does have problems highlighted in red color.
xValue are double but not datetime.
This chart’s CategoryData is Date.
However, I do not understand this problem. Please give me correct output which you can create manually or clarify it more, how your current console output is wrong? I have shown the console output for your reference.
What this point means? Please clarify it.
2. point’s xValue, yValue, xPx and yPx are wrong, because in chart points sort by first column, not according table data
When chart save to image, MS Excel and Aspose.Cells sort points by CategoryData.
But series.getPoints return points without sort, and they have wrong position!
Thanks for your cooperation in this regard and have a good day.
Console Output
最大折扣
41832.0==>0.0::::59@148
41837.0==>0.2::::81@409
41844.0==>0.0::::98@83
41871.0==>0.2::::106@148
41877.0==>0.0::::108@409
41881.0==>0.0::::117@376
41887.0==>0.0::::122@409
41912.0==>0.0::::136@214
41923.0==>0.2::::139@83
41934.0==>0.2::::141@409
41942.0==>0.2::::163@409
41950.0==>0.15::::174@409
41957.0==>0.0::::196@344
41793.0==>0.15::::201@409
41815.0==>0.25::::212@83
41644.0==>0.2::::231@409
41652.0==>0.0::::234@214
41658.0==>0.25::::294@148
41661.0==>0.2::::308@409
41662.0==>0.0::::310@409
41665.0==>0.025::::327@409
41667.0==>0.0::::330@409
41672.0==>0.15::::332@83
41673.0==>0.25::::338@279
41674.0==>0.0::::346@246
41682.0==>0.0::::351@409
41686.0==>0.0::::357@148
41694.0==>0.05::::387@83
41696.0==>0.0::::390@148
41700.0==>0.25::::466@214
41707.0==>0.0::::526@83
41708.0==>0.15::::572@409
41730.0==>0.2::::586@148
41735.0==>0.0::::605@409
41736.0==>0.0::::679@148
41742.0==>0.0::::695@409
41743.0==>0.0::::706@409
41744.0==>0.25::::723@409
41746.0==>0.1::::791@409
41749.0==>0.125::::821@148
41751.0==>0.0::::851@148
41753.0==>0.2::::873@148
41764.0==>0.25::::895@214
41765.0==>0.2::::914@409
0.0==>0.15::::0@0
0.0==>0.0::::0@0
0.0==>0.11666666666666665::::0@0