Hi.
When importing the data from Excel(grid.WebWorksheets.ImportExcelFile(@"C:\test\Analiza ryzyka.xls.xls");) I see that "named cells" are imported as "normal cells" named by column+row qualifier (I have B2 cell with name "testowe" and in GridWeb after import it is still B2).
When any formulas contains named cells' values, they are treated as invalid.
Is it possible to implement named cells handling for GridWeb?
Greetings:
Pawel

Hi Pawel,

I have logged your feature request into our tacking system with an id: CELLSNET-19719. We will check if we can support it.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi Pawel,

Named Range feature has now been supported. Please use the updated version of  Aspose.Cells.GridWeb v2.3.1.2009. Two new classes (Name and NameCollectioin) have been introduced. Following code snippet will help you.

GridWeb1.WebWorksheets.Clear();
GridWeb1.WebWorksheets.ImportExcelFile(@"c:\excel\test.xls");
GridWeb1.WebWorksheets[0].Cells["g6"].Formula = "=sum(hh)";
 
int index = GridWeb1.WebWorksheets.Names.Add("zz", "sheet1!a2:b5");
Name name = GridWeb1.WebWorksheets.Names[index];
GridWeb1.WebWorksheets[0].Cells["g7"].Formula = "=sum(zz)";
GridWeb1.WebWorksheets.RunAllFormulas();
GridWeb1.WebWorksheets.SaveToExcelFile(@"c:\excel\test1.xls");

Thanks,

---

Sincere Regards,

Salman Shakeel
Support Developer,
Aspose Sialkot Team
Contact Us

Hi.
Could you please try to check the following code with my file on your side?
I think, there are still some bugs in a library.

GridWeb g;
    protected void Page_Load(object sender, EventArgs e)
    {
        g = new GridWeb();
        g.EnableAJAX = true;
        g.WebWorksheets.ImportExcelFile(@"C:\test\Analiza ryzyka.xls.xls");
        g.WebWorksheets["Podsumowanie"].Cells["C2"].Formula = "=testowe";
        g.WebWorksheets["Podsumowanie"].Cells["B3"].PutValue(10);
        int index = g.WebWorksheets.Names.Add("zz", "Podsumowanie!B3");
        Name name = g.WebWorksheets.Names[index];
        g.WebWorksheets["Podsumowanie"].Cells["A3"].Formula = "=zz";
        g.WebWorksheets.RunAllFormulas();
        form1.Controls.Add(g);
    }

All cells containing references to a named cell "testowe" have #VALUE? errors.
I attached my Excel file for import.
By the way - is really RunAllFormulas() execution absolutely required in EnableAJAX=true?
This is not consistent with normal AJAX concept, that works normally in other situations for your control in this mode.
Greetings:
Pawel

Hi Pawel,

Please use the updated version Aspose.Cells.GridWeb v2.3.1.2010 attached. The issue you mentioned have been resolved.

Thanks, 

---

Sincere Regards,

Salman Shakeel
Support Developer,
Aspose Sialkot Team
Contact Us

Hi.
Many thanks for your help.
I have one more question concerning the implemented functionality.
How to present the name of the named cell on tooltip or gain it in the function?
Normally, when the names are default, such as A1, B3, etc. this is easy to identify the cell, as a position of the cell determines the name client side, so when the client eneters formula on web page, he/she has no problem with referencing a particular cell. When a cell is named, a position (e.g. column B and row 1) does not represent the cell name, as wel as the name is not presented in tooltip. So how to gain such name clientside. Is it a way to identify the name of the cell or range client side (by javascript function and tooltip)?
Without such information and JavaScript API, it is almost impossible to reference to such named field/range client side (because e.g. "=B1" will not work, as the real name of "B1" will be "test").
Greetings:
Pawel

Hi Pawel,

This functionality is not currently supported. We are working on it. But it need more time to implement. We will update you about this update accordingly.

Thanks,

---

Sincere Regards,

Salman Shakeel
Support Developer,
Aspose Sialkot Team
Contact Us

Hi,
  
Please download Aspose.Cells.GridWeb v2.5.3.2001.

We have now supported calculating formula with named range.   

---

Many Thanks and Kind Regards,

Shakeel Faiz
Support Developer
Aspose Sialkot Team
Contact Us
Aspose - The .NET and Java Component Publisher

Keep in touch! We're on Twitter and Facebook