I have to create a custom formula bar. So far, entering data in the formula bar and apply to GridDesktop ActiveWorksheet is not a problem.
However, entering characters directly into a focused cell with the keyboard is. How do I capture the key event occurring in the cell and mirror that in my custom formula bar? The GridDesktop_KeyDown and GridDesktop_CellKeyPressed and GridDesktop_CellDataChanged do not work for this.
I need to mirror in my custom formulabar exactly what the user is typing in a focused cell before the value is assigned to the cell (which then would be cell.Value and easy).
Aspose.Cells.GridDesktop also provides FormulaBar control which is included in the Aspose.Cells.GridDesktop library that you may add it from the Toolbox in VS.NET. You may select Choose Items to add the control in the ToolBox with Aspose.Cells.GridDesktop control. You may bind it by using FormulaBar’s “GridDesktop” property at design time for your needs.
If you still find any issue, kindly create a sample WinForm application (runnable) with Aspose.Cells.GridDesktop v8.4.1, zip it and post us here to show the issue, we will check it soon.