Referencing cells from different sheets

Aspose.Cells Product Family
1

I have a formula in Sheet2 like this for instance: =Sheet1!A1.

Unfortunately when i load the excel file in the grid i get the #NAME? error!

2

Hi,

Well, I tested your scenario and it works fine. Which formula you are having in Sheet1!A1 cell and did you manually test the formula into MS Excel if MS Excel process it fine. Could you post your sample template excel file here, we will check it soon.

And alway try the latest version of Aspose.Grid (1.9.4).

Thank you.

3

I have a number, not a formula and everything in Excel works fine!

4

Ha, sorry for the wrong definition of the problem. I tried referencing the cell by =Sheet1!A1 for example. But when I give a name for a cell(in the name box in excel) and then I try to access it by that name i get that error.

5

Hi,

I use Aspose.Grid.Web 1.9.4 and it works fine... no problem at all. Which version you are using?

Thank you.

6

same version.

7

I sent you a very simple attachment. When run the grid in sheet2 i get that error message

8

Hi,

We will support to utilize named ranges in formulas soon.

Thank you.