Formula across multiple workbooks

Aspose.Cells Product Family
1

Hi,

Does Aspose.Cells for java provides formula across the multiple workbooks?

If YES please update me with the sample code and if NO please let me know if Aspose.Cells can provide additional code to support it.

Thank You.
Kailas

2

Hi Kailas,

"Formula across multiple workbooks".... could you elaborate and explain it more how it can be done in MS Excel. We appreciate if you could create sample test excel files handling such formulas, zip them to make a single file and post it here, We will check it soon.

Thank you.

3

Hi,

Please find the attached zip. It contains two excel files A.xlsx and B.xlsx.

I have formula cell (A2) in B.xlsx excel workbook which actually refers to cell A!A1 of workbook A.xlsx.

How this can be achieved in Aspose.

Thanks.
Kailas

4

Hi Kailas,

Currently Aspose.Cells for Java only support formula accross multiple sheets in same workbook. We will look into the feature of formula accross multiple workbooks after completing some other important tasks on hand, thank you.

5

Hi,

This feature has been supported. Please download the latest version: Aspose.Cells for Java 7.0.1