Free Support Forum - aspose.com

Formula Bar control

Hi,

Does the Aspose.Cells.GridDesktop control use or have a formula bar?

Thanks

Lerato

Hi,

In order to use formula using Aspose.Cells for GridDesktop, you need to use SetValueCell() method.

Below is a sample program that uses a forumla, it is fully commented, so you will not have a trouble understanding it.

For more help, please refer to this document: Adding Formulas to Cells

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



Thanks for your prompt response.

I am looking for the formula bar control similar to the one located beneath the toolbar at the top of the MS Excel worksheet. It's mainly used for entering and editing worksheet data.

Thanks, Lerato

Hi,

Thanks for your clarification.

We found, this feature is not available and this is a new feature. We have added a new feature request for this issue. Once we will get any update we will let you know.

This issue has been logged as CELLSNET-29821.

Hi,

I am just doing a follow up on CELLSNET-29821.

Regards

Staggga

Hi,


We are developing the control, once it is completed, we will let you know.

Thanks for being patient!

Hi,

We have implemented the formula bar control in Aspose.Cells.GridDesktop v.2.6.2.2001. Please add the dll into Toolbox, there will be a FormulaBar control.

The issues you have found earlier (filed as 29821) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by aspose.notifier.