Free Support Forum - aspose.com

Cells not diplaying data (Aspose.Cells.GridDesktop control not)

I loaded an Excel file to the Aspose.Cells.GridDesktop control. But whenever I type a formula or reference another cell, the active cell remain blank. Please help.

Example: My excel file has one sheet with the follwing values:

1. A1 = 100

2. A2 = 300

3. A3 =500

The formula I created on B1 is (=A2 * A3)

And its also not showing anything if reference A1 using C1

Hope my illustration is clear enough.

Thanks

Staggga

Hi,

Once you set the forumla using Aspose.Cells for GridDesktop, then you should call gridDesktop1.RunAllFormulas() method.

C#


//Accessing first worksheet of the Grid

Worksheet sheet = gridDesktop1.Worksheets[0];


//Adding numeric values to “B2” & “B3” cells

sheet.Cells[“B2”].SetCellValue(3);


sheet.Cells[“B3”].SetCellValue(4);


//Adding a formula to “B4” cell to get the result after multiplying the values

//of “B2” & “B3” cells

sheet.Cells[“B4”].SetCellValue("=B2 * B3");


//Running all formulas in the Grid

gridDesktop1.RunAllFormulas();



The formulas are not hard coded, I am setting them by typing on the GridDesktop while my application is running.

Hi,

Thanks for elaborating it. Please provide me your C# sample application to replicate the problem and also test your issue with the latest version:
Aspose.Cells.GridDesktop
v2.6.1.2003

Hi,

I found the latest version:
Aspose.Cells.GridDesktop
v2.6.1.2003
is working fine. Please see the screenshot below.

Screenshot:

Hi,

I've attached my C# application (using Aspose.Cells.GridDesktop 2.5.0.1000). Please copy the excel file (TestGridDesktop.xlsx) into your C:\ drive

Please also test referencing cells in another worksheet.

Thanks

Lerato

Thanks. Its working.

<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /> <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Good to know that it is working fine for you now.


Thanks and have a good day!