Reference not updated or formula not evaluated in a textbox

Aspose.Cells Product Family
1

Hi,

I’m having a reference not updated problem. I have a formula in a cell, then I have a textbox referencing that cell, when I called calculateFormula() on the Workbook level, all the cells have been correctly updated, but the textboxes are left as blank.

Does Aspose support references in graphical elements? Is there any method I should explicitly call to update the value of the textbox?

Please kindly see my attached Excel file. After I updated data values and called calculateFormula(), the textboxes under the graph disappeared. Below is how I updated data values

private static void populateIS (Worksheet ws){
Cell c = ws.getCells().getCell(11, 1);
// System.out.println("old value: " + c.getValue());
c.setValue(40000.018);
c = ws.getCells().getCell(11, 2);
c.setValue(4.018);

c = ws.getCells().getCell(13, 1);
c.setValue(3410.018);
c = ws.getCells().getCell(13, 2);
c.setValue(6.8);

c = ws.getCells().getCell(16, 1);
c.setValue(66710.2);
c = ws.getCells().getCell(16, 2);
c.setValue(60.02);
}


Thank you,


Cathy

2

Hi,

Thanks for the sample code with file to point out the issue.

We already found the issue and logged it as an id: CELLSJAVA-26508 (for your other thread). Once we have any update we will let you know about it.

Thanks for being patient!

3

Hello,

Has there been any updates on this issue?

Thank you,

Cathy

4

Hi,

I am afraid your issue is not resolved yet, once we have any update, we will let you know here.

thank you.

5

Hi,


We have fixed the issue of
textbox and border from V2.5.3.2. But the issue of chart title position
is complicated and we cannot support it very soon.

Are you sure you want to delete ?
                                    <br><br>Please download the latest <a href="">Aspose Cells for Java
    v2.5.3.2</a>