i also need to know how to get the 3D format option (bevel , Material) i tried to this but it didn’t work.
Please download and try the latest version:
for Java v220.127.116.11
and see if it resolves your problem.
Please try saving it in xlsx format. I have check it, transparency issue does not occur when you save in xlsx format.
Please also see this thread for more help.
Neither FormatSetType.None nor Transparency Working
If the problem still occurs with xls or xlsx format, then provide me a sample application replicating the problem, we will look into it and fix the problems.
i tried to do the same code in the topic that u gave me but it didn’t work netheir when saving xlsx or xls.
Thanks for your feedback and using the latest version.
We have logged this issue in our database. We will look into and get back to you asap.
This issue has been logged as CELLSJAVA-40160.
We have evaluated your feature/issue a bit. Since the Transparency and 3D fill are advanced features since the release of Office 2007 and at the moment, we only support them in XLSX file format, not support them in XLS file format, so it will take some time to support it in XLS file format for your needs.
We hope we can support them in XLS file format in Q3 2012.
thanks for your quik response and for the great work that u do.
Firstly, we cannot find the issue of black color. After running your code we can get the chart series filled with red color. Please see attached xlsx file generated with your code.
Secondly, the transparency also has been set to the chart series’ area. It is Ms Excel’s behavior that the area is not transparent even with transparency value 100% when format3D was set.
To get the transparency take effect, please do not set the format3d.
For your code, please remove the part:
thanks for the big help that u give for your client that i’m one of them.
Please download and use the latest fix: Aspose.Cells for Java v18.104.22.168
We have fixed the issue of transparency for saved xlsx file.