Free Support Forum - aspose.com

Charts in percentages

Aspose.Slides Product Family
#1

Is it possible to change the data types yet in the Excel worksheet? If my data is percentages and I want to set the cell data type to be “Percentage” is this possible?


I have noticed that a chart with percentages reverts to non percentages just by resaving the file using the latest version.
#2

Hi Shaun,


I have tried to understand the requirement shared by you. Do you want to change the cell format of excel sheet that is added as Ole frame? If you wish to change the format of excel sheet cell that is added as Ole frame then you need to extract the Ole frame contents in excel object using Aspose.Cells then you can make necessary changes to cells by changing their formats. Then loading the excel sheet again as Ole frame using Aspose.Slides. Please visit this documentation link for your kind reference.

Many Thanks,
#3

Create a PresentationEx from the attached file as a template and resave:


PresentationEx p = new PresentationEx(“Percentages.pptx”);
p.Save(“Percentages1.pptx”, Aspose.Slides.Export.SaveFormat.Pptx);

Notice that the percentage cell format has been lost in the chart data. Why is this?
#4

Hi Shaun,


Thanks for sharing the detailed information.

I have worked with the presentation file shared by you and have been able to observe the issue specified. An issue with ID SLIDESNET-33693 has been created in our issue tracking system to further investigate and resolve the issue. This thread has been linked with the issue so that you may be automatically notified once the issue will be resolved.

We are sorry for your inconvenience,
#5

Thanks. Please also don’t overlook the other part of my first post which was a feature request: the ability to set cell data types in the chart data. Right now it looks like the only option is “General”.

#6

Hi Shaun,


I like to share that you can set the format of values in axis using Aspose.Slides. Please visit this thread link for your kind reference.

Many Thanks,
#7

The linked code is this:


chart.ValueAxis.DisplayUnit = Aspose.Slides .Pptx .Charts.DisplayUnitType.None;
chart.ValueAxis.NumberFormat = “0.0%”;
chart.ValueAxis.SourceLinked = false;

Can you please explain what SourceLinked = false does.

If this de-links the axis from the source data then it’s not really an acceptable solution. The correct place to specify chart data type is in datasheet (Excel), and then be able to override the display on the axis and data labels.
#8

Hi Shaun,


I like to share that the SourceLinked property is actually used for the number format of value axis. If the SourceLinked property is set to true then value axis gets the actual values as given in the chart data and sets the number format to General. However, when you set any other number format other than General then SourceLinked property has to be set false as other formats represents calculated values and General format represents actual values. Hope this will clear the concept to you. For further explanation of concept, I would suggest you to create a sample chart in PowerPoint and change the number format using PowerPoint.

Many Thanks,
#9

The issues you have found earlier (filed as SLIDESNET-33693) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.
#10

This is not fixed, at least in the latest Java release (6.9.1). Running my previous example opening Percentages.pptx and saving again loses all the percentage formatting in the chart and the Excel worksheet when you view the data.

#11

Hi Shaun,


I like to share that the issue created for this thread was related to Aspsoe.Slides for .NET. However, I have tested the Percentages.pptx with Aspose.Slides for Java 6.9.1 and the saved presentation preserved the percentages values. For your kind reference, I have attached the generated presentation as well. Please share, if I may help you further in this regard.

Many Thanks,
#12

Right click on that chart and select “Edit Data”. Note that all percentages are immediately lost, in the data and on the chart.

#13

Hi Shaun,


Thanks for sharing the additional details. I have been able to observe the issue shared by you and have been able to observe the issue. An issue with ID SLIDESJAVA-33705 has been created to further investigate and resolve the issue. this thread has been linked with the issue so that you may be automatically notified once the issue will be resolved.

We are sorry for your inconvenience,
#14

The issues you have found earlier (filed as SLIDESJAVA-33705) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.