We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to Save Formulas

Thread ID:

Created:

Updated:

Platform:

Replies:

28900 May 12,2005 09:25 AM UTC May 13,2005 01:16 PM UTC WinForms 8
loading
Tags: GridControl
Jitendra
Asked On May 12, 2005 09:25 AM UTC

Hi I am using gridControl to act as Ms-Excel.I have define GridFormulaCellModel for the grid.The Formulas are working fine.But When i save and close the document and reopen the same document,the formulas defined are not working properly.Its showing the formula correctly but its not giving the results.So How to get activate the formulas after closing the document. I am using SaveBinary and LoadBinary Methods to save and load the Grid data. Please help. Regards, Jitendra.

Administrator [Syncfusion]
Replied On May 12, 2005 10:04 AM UTC

After doing LoadBinary to read teh grid back in, try calling engine.RecalculateRange, passing in GridRangeInfo.table() and also setting the other parameters to force the recalculations.

Jitendra
Replied On May 12, 2005 11:55 AM UTC

Hi Clay, Thanks for the support.Its working fine now.I have another issue to discuss.In this application I have Insert Menu like in Excel.I have done "Insering Rows" by gridControl.Model.Rows.InsertRange() and "Inserting Columns" by gridControl.Model.Cols.InsertRange() methods. But how to implement "Insert Cells" functionality.Is it possible to do that? Regards, Jitendra.

Administrator [Syncfusion]
Replied On May 13, 2005 11:07 AM UTC

You could try to do this. For example, if you want to shift the cells down, you would have to copy the cells in the current column from the row you are on to the botton of the grid. You can use the this.gridControl1.CutPaste.CopyCellsToClipboard method to do this. Then you would blank out the current cell, move the currentcell down one cell, and use this.gridControl1.CutPaste.Paste to paste the copied range 1 cell lower.

Jitendra
Replied On May 13, 2005 11:46 AM UTC

Hi Caly, this.gridControl1.CutPaste.CopyCellsToClipboard method expects GridRangeInfoList as arguement.How to give that GridRangeInfoList.In my case the range is from current column data from current row. shall i give like: this.gridControl1.Selections.GetSelectedCols(true, true); Please help Regards, Jitendra.

Jitendra
Replied On May 13, 2005 11:59 AM UTC

I am not able to get the cells in the current column from the current row to the bottom of the grid.How to get that range? Thanks, Jitendra

Administrator [Syncfusion]
Replied On May 13, 2005 12:45 PM UTC

Try this code: int currentRowIndex = grid.CurrentCell.RowIndex; int currentColIndex = grid.Currentcell.ColIndex; int bottomRowIndex = grid.RowCount; GridRangeInfo range = GridRangeInfo.Cells(currentRowIndex, currentColIndex, bottomRowIndex, currentColIndex);

Administrator [Syncfusion]
Replied On May 13, 2005 12:47 PM UTC

Then create a GridRangeInfoList using: GridRangeInfoList list = new GridrangeInforList(); list.Add(range);

Jitendra
Replied On May 13, 2005 01:16 PM UTC

This Works fine. Thanks Clay.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;