Is there a way to set the Series DataLabel Separator for a pie chart to a custom value? I am trying to get Excel to mimic and existing chart and in this case the separator is " - " (displaying as 6 - 75%).
Thanks for your posting and using Aspose.Cells
Please try chart.NSeries[x].DataLabels.Separator for your needs. If you still find any issue, then please provide us your sample input and expected output xls/xlsx files which you can create manually using MS-Excel and attach them here. It will help us look into your issue more precisely and we will update you asap.
I don’t see access to that in the Java version of Apose Cells. All I see is chart.getNSeries().get(0).getDataLabels().setSeparator(int) that takes a DataLablesSeparatorType…
You are right, in the Java version of the API DataLabels.Separator property has changed into DataLabels.setSeparator method that accepts an int value, and can be selected using the enum DataLablesSeparatorType.
Please note, you have the following possible options,
- New Line
Please feel free to write back in case you have further questions or concerns.
So the answer is No it’s not possible to set a custom separator.
Thanks for using Aspose.Cells.
I have checked in MS-Excel, you cannot specify custom separator for series data labels. There are just 5 built-in options as mentioned by Babar earlier.
I have attached the screenshot for your reference. If you think, custom separator can be specified, then please provide us some sample xls/xlsx file containing custom separator and also let us know the steps you performed to specify it. You can create such file manually in MS-Excel for our reference.
We will look into it and implement this feature if possible.
In reference to your screen shot although it is a combo box you can still type in the separator field. Attached is a sample xls with the separator set to " - ".
Thank you for the sample spreadsheet.
We have logged a ticket (CELLSJAVA-40753) in our bug tracking system to look further into this matter. Please spare us little time to properly analyze the request, and to provide the implementation at earliest. In the meanwhile, we will keep you posted with updates in this regard.
Thanks for your using Aspose.Cells for Java.
Please download and try this fix: Aspose.Cells for Java v220.127.116.11 and use setSeparatorValue(String value) for setting custom separator.
Let us know your feedback.
That method works as expected. Thank you.