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

Aspose.Cells Product Family
1

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

2

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();



3

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

4

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

5

Hi,

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

Screenshot:

6

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

7

Thanks. Its working.

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

8

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


Thanks and have a good day!