We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Dynamic Chart titles

Hi there,

I've come across an issue when changing a chart title before saving it 'toimage()'.

I have an excel template containing a number of charts. The chart titles reference a cell.

When that cell remains unchanged, the chart title is correct.

However if the cell contents are updated by an aspose 'putvalue', and then the chart image created by 'toimage()', the title is not updated.

This happens even if I run a chart(x).calculate().

Is this a bug, or a limitation, or is there a work-around?

Cheers,

Steve

Hi Steve,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

We have found your mentioned issue after an initial test. We will look into it and get back to you soon. Your issue has been registered in our internal issue tracking system with issue id CELLSNET-14934.

Thank You & Best Regards,

Hi,

Please try the attached version, we have fixed your issue.

Thank you.

Hi,

thanks for that, but unfortunately it causes an issue, that means that we are unable to get to the code that tests the chart titles.

It fails on :

_appExcel.CalculateFormula()

with the error:

Object reference not set to an instance of an object.
Error in calculating cell X15 in Worksheet Control

In cell X15, it has the formula:

=IF(W15>0,VLOOKUP(W15,text_table,2,FALSE),"")

Hopefully this gives you enough information to sort it out :)

Cheers,

Steve

Hi Steve,

Could you provide us the sample console application, zip it and post it here to reproduce the issue. We will check it soon.

Thank you.