Workbook.getCell Does Not Return Value, when There Is Value in the Sheet

Aspose.Slides Product Family
,
1

We have code that relies on data stored in Graph’s data sheet. It looks like for some graph types the workbook.getCell api returns nulls instead of values.

We are using aspose slides for java version 24.3

Attached the powerpoint presentation that causes the problem and the java program that tries to read from the slides graph the workbook cell values
Please look at slides 3 and 4, There is clear Data range for these slides, and there is data there when you open the slides with powerpoint, but the API returns nulls instead

GraphDataProblem.zip (83.5 KB)

2

@abelfer,
Thank you for reporting on the issue. I’ve reproduced the problem you described. We apologize for any inconvenience caused.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): SLIDESJAVA-39458

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

Is there a work around? What is the root cause of this?

  1. Is this related to formulas in the sheet?
  2. Is this related to the type of the graph?
  3. Is there a way to do a stacked bar graph with a series that is defined as point graph without invoking this problem?

Please suggest what can be done until this issue resolved.

Thanks.

4

@abelfer,
We expect the issue to be resolved in Aspose.Slides for Java 24.5. This release will be published soon. Unfortunately, I don’t have any additional information. Thank you for your patience.