Excell charts for clustered 3d bar and 3d cylinder shown correctly by order, and the setting for
chart.getCategoryAxis().setPlotOrderReversed(true/false) works correctly.
If I try to use chart.toImage( pictureBytes, imageOptions ); then I have problem
reversed plot order for category axis is ignored.
Also for chart as OLE object it’s ignored.
Reversed value axis is correct.
Hi,
Hi, excel contain correct reversed chart
Hi,
Thanks, one moment how do I know about fix the bug?
Hi,
When the bug will be fixed. We will update you on this thread by posting. Also, we will set the issue flag as resolved later on and after some time, it will reflect on the top left corner of this thread as resolved.
unfortunately new version doesn’t affect the my problems with the order in bars and the order in legend.
Hi,
The issues you have found earlier (filed as CELLSJAVA-40043) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.
Hi
Amjad, I have problem again. I found that if if open exist excel file and generate new file with different format for example pdf, then it’s ok. Flag reversed category axis is fine works. But if create new file add the same charts with the save settings, the result is failed. toImage ignored the flag “reversed” for category axis.
Hi,
The initial file “prolems bars-3.xlsx” contains two charts with reverted category axis.
Hi,
import java.io.*;
Hi,
import java.io.*;
Hi,
Please try the following code. You must confirm the new Workbook’s file format must be same as Save’s file format.
C#
//The new Workbook’s format must be same as Save’s format.
int fileFormatType = FileFormatType.EXCEL_97_TO_2003;
//or
// int fileFormatType = = FileFormatType.XLSX;
Workbook workbook = new Workbook(fileFormatType);
addConvertedCharts( workbook );
addCustomCharts( workbook.getWorksheets().add( “added worksheet” ) );
workbook.save( path + “myoutput.xls”, fileFormatType);
//or
// workbook.save( path + “myoutput.xlsx”, fileFormatType);
Hi,