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

Aspose.com » Public Forums for Customers an... » Aspose.Cells Product Family » Cells not diplaying data (Aspose.Cells.GridDesktop control not)

Last post 08-12-2011, 12:45 PM by Amjad Sahi. 7 replies.


	Sort Posts: Previous Next

08-12-2011, 7:34 AM 322047

staggga
Joined on 07-17-2011
Posts 28

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

Filed under: Aspose.Grid

08-12-2011, 7:51 AM 322050 in reply to 322047

mshakeel.faiz
Joined on 02-01-2007
Posts 9,002

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

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

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

08-12-2011, 7:59 AM 322051 in reply to 322050

staggga
Joined on 07-17-2011
Posts 28

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

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

08-12-2011, 8:17 AM 322056 in reply to 322051

mshakeel.faiz
Joined on 02-01-2007
Posts 9,002

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

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

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

08-12-2011, 8:21 AM 322058 in reply to 322056

mshakeel.faiz
Joined on 02-01-2007
Posts 9,002

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

Attachment: Present (inaccessible)

Hi,

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

Screenshot:

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

08-12-2011, 11:12 AM 322083 in reply to 322050

staggga
Joined on 07-17-2011
Posts 28

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

Attachment: Present (inaccessible)

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

Filed under: Aspose Grid spreadsheet control

08-12-2011, 11:33 AM 322087 in reply to 322058

staggga
Joined on 07-17-2011
Posts 28

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

Thanks. Its working.

08-12-2011, 12:45 PM 322097 in reply to 322087

Amjad Sahi
Joined on 08-30-2006
Posts 18,411

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

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

Thanks and have a good day!

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us