Is it possible to enter cell reference "formulas" in graph labels and textboxes?

I can enter text like ='Sheet Reference'!A2 into the text of the label or textbox but it only shows as that text. It appears it has to be a special formula type and can only be a single reference and not any other formula types. (In Excel I tried to use Concatenate to string together several references and it gives an error)

Thanks, Steve

Hi Steve,

We will figure it out.

Could you try in the mean time:

Workbook wb = new Workbook();
Worksheet sheet = wb.getSheet(0);
Cell cell = sheet.getCell("A2"); 

..... = cell.getValue();

Thank you.

Hi Amjad,

I just get back a null since the formula I want is not in a cell.

What I want to do is to link a text box in my chart to a cell in my sheet.

Do a search in the Excel help for "Link a title, label, or text box in a chart to a worksheet cell". This is what I want to be able to do from Aspose Cells for Java.

Steve

Hi Steve,

Please try this version.

Please use TextBox.setLinkedCell() method to make the text box linked to cell. See following code:

 index = chart.getTextBoxes().addInChart(0,0,200,200);
   TextBox textBox = chart.getTextBoxes().get(0);
   //textBox.setContent("dddd");
   textBox.setLinkedCell("Sheet1!C1");

Thanks Warren,

That worked great!!!

When will this be available in a released version?

Steve

Hi Steve,

Thanks for considering Aspose.

We will try to release our next official version (for Java) at the end of this week or so.

Thank you.