Status of Undo and Redo in desktop grid

info_mediatrendit_co · November 3, 2008, 5:03am

Hi,

First of all I would like to know the status of Undo and Redo in desktop grid. Secondly, following are my new requests.

Column and Row locking : At the moment we can lock it cell by cell but there is no way to lock a column or row directly.

Hide/Show columns menu in existing Context Menu: How to hide/show columns from front end? I mean is there a way with which user could select a menu and mark a column hidden?
Customize Context Menu : Can we add/remove menus from context menu.
RowFilter: It’s available in web grid, but missing in desktop version**:**

GridWeb1.WebWorksheets[0].RowFilter.Criteria = "CELL0=\"Revenue\"";
GridWeb1.WebWorksheets[0].RowFilter.FilterRows();

Drag a cell to copy it’s value in following cells : Can I drag a cell downward to get its values in the following cells as we do in Excel?

Kindly provide me an estimated time that will take to implement them. I mean when can we have those features implemented in desktop grid? Also, I can have more requests as I’ll get into more details.

Aspose.Chart and Aspose.Cells are the new products that I would like to go with; but firstly I would like to wrap up Aspose.Grid work. Request you to revert back soon.

thx.

M.Irfan.

amjad.sahi · November 3, 2008, 9:13am

Hi Irfan,

We will check if we can provide you an eta for the features, it’s really hard at the moment. Actually we got a very busy schedule, we have a long list of features (on hand) to be implemented first. But anyways, for your requests, I would like to share some details:

Column and Row locking: At the moment we can lock it cell by cell but there is no way to lock a column or row directly.

Hopefully we can provide this feature before the end of next week.

Hide/Show columns menu in existing Context Menu: How to hide/show columns from front end? I mean is there a way with which user could select a menu and mark a column hidden?
Customize Context Menu: Can we add/remove menus from context menu.
RowFilter: It’s available in web grid, but missing in desktop version:

GridWeb1.WebWorksheets[0].RowFilter.Criteria = "CELL0=\"Revenue\"";
GridWeb1.WebWorksheets[0].RowFilter.FilterRows();

Drag a cell to copy it’s value in following cells: Can I drag a cell downward to get its values in the following cells as we do in Excel?

Well, we will analyze these features and will get back to you soon.

Thanks for your time and understanding.

amjad.sahi · November 4, 2008, 2:17am

Hi Irfan,

We did some work on Undo/Redo and row/column locking features. Hopefully we can provide a version which will support these two features before the end of next week. For Undo/Redo feature, we will provide it in a simple way at the start, it means the Undo/Redo operation refers to the change in a cell’s value only. Other operations i.e.., Change in a cell’s style, cell/row/column removing and other complex operations will not be supported in this version, we will look into them later.

For all other features, we have not planned yet, we may consider them after completing some important tasks (on hand).

Thanks for your time and understanding.

amjad.sahi · November 11, 2008, 3:43am

Hi Ifran,

Please try the attached version for Aspose.Grid.Desktop. We have supported the following features for your need.

1) Undo/Redo feature.

The following APIs are incorporated. The descriptions are also given with them, please check.

GridDesktop.EnableUndo attribute ..............indicates whether the Undo function is enabled, the default value is “false”.

UndoManager class ........... is used to manage the undo/redo operations.

GridDesktop.UndoManager attribute..................gets the instance of UndoManager object.

UndoManager.Undo() method ...................performs an undo operation.

UndoManager.Redo() method................. performs the redo operation.

UndoManager.ClearStack() method........... clears the undo and redo stack.

UndoManager.UndoStepsCount attribute ................. gets the count for current available undo steps.

UndoManager.RedoStepsCount attribute...... gets the count for current available redo steps.

UndoManager.UndoStackSize attribute............. gets/sets the undo stack size.

Note: Currently, undo/redo operation refers to the change in a cell value.

2) Row/Column locking

The following code will lock all cells of row 4.

Style s = sheet.Rows[3].GetStyle();

s.CellLocked = true;

sheet.Rows[3].SetStyle(s);

3) Support for Hide/Show columns/rows from Grid's Context Menu.

Thank you.

info_mediatrendit_co · November 12, 2008, 11:25pm

Hi,

There is another request for the same customer who is looking to Customize Context Menu:(Add/Remove menus from context menu): Can you provide me this feature as well because I need it badly.
thx,
Irfan.

amjad.sahi · November 13, 2008, 1:39am

Hi Irfan,

OK, we will look into the feature i.e.., Customize Context Menu

and try to support it before the end of next week or so for your requirements. If we complete the feature we will provide you the supported version.

Thank you.

info_mediatrendit_co · November 13, 2008, 4:04am

Hi,

This code locks all cells of a row. What I also need is to lock all cells of a Column. Could you please provide this feature as this also is a very important feature along with Undo/Redo and Custom Menus.

thx.

M.Irfan.

amjad.sahi · November 13, 2008, 5:32am

Hi Irfan,

Well, the fix I provided you also supports to lock a complete column.

e.g...,

The following code will lock all the cells of column A.

Style s = sheet.Columns[0].GetStyle();

s.CellLocked = true;

sheet.Columns[0].SetStyle(s);

Thank you.

info_mediatrendit_co · November 17, 2008, 10:36am

Hi Amjad,

Any update on redo and undo feature kindly keep us posted soon.

Thanks.

M.Irfan.

amjad.sahi · November 17, 2008, 11:34am

Hi Irfan,

We got a very busy schedule these days, we can look into your desired features but after completing some other important tasks on hand. We will keep you updated when you start working on it.

Keep in touch and have a good day!

amjad.sahi · November 21, 2008, 1:41am

Hi,

We have incorporated the following new features in the attached Aspose.Grid.Desktop version (2.0.0.13). Please try it.

Customize Context Menu.

ContextMenuManager class is used to manage the context menu item.

“GridDesktop.ContextMenuManager” attribute gets the instance of ContextMenuManager.

e.g…, “ContextMenuManager.MenuItemAvailable_AddRow” attribute gets or sets a value indicating whether the context menu item “AddRow” is available.

Note: All context menu items have their corresponding “available attributes” in this class.

Sample code:

_gridDesktop.ContextMenuManager.MenuItemAvailable_Paste = false; // disable context menu item “Paste”;

_gridDesktop.ContextMenuManager.MenuItemAvailable_Paste = true; // enable context menu item “Paste”;

By default all the context menu item are all available.

Event(s) for Row/column hide/unhide Operations

We have incorporated GridDesktop.RowColumnHiddenChanged event that occurs when the row/column hide status changed.

Sample code:

.............

gridDesktop1.RowColumnHiddenChanged +=

new WorksheetEventHandler(this.hiddenChangeInvokeMethod);

...............

private void hiddenChangeInvokeMethod(object sender, Aspose.Grid.Desktop.WorksheetEventArgs e)

{

string type;

switch(e.SheetEvents)

{

case WorksheetEvents.RowsHide:

type = "rows hide";

break;

case WorksheetEvents.RowsUnHide:

type = "rows Unhide";

break;

case WorksheetEvents.ColumnsHide:

type = "columns hide";

break;

case WorksheetEvents.ColumnsUnHide:

type = "columns Unhide";

break;

default:

return;

}


StringBuilder buf = new StringBuilder();

for(int i=0; i<e.IndexArray.Length; i++)

{

if(i== 0)

buf.Append(e.IndexArray[i]);

else

{

buf.Append(",");

buf.Append(e.IndexArray[i]);

}

}

Console.WriteLine(type);

Console.WriteLine(buf.ToString()); // write out the affected row/column idexes

}

The performance of Sort() method (for data sorting feature) has been fixed / enhanced in this version.

Thank you.

sukhminders · November 21, 2008, 7:07am

Thanks a lot Amjad.

I’ll use/implement them and will get back to you soon with my feedback.

sukhminders · December 12, 2008, 5:54am

Hi

Could you give me sample code for using Undo and Redo?? Also, is this available in 2.0.13 version?

amjad.sahi · December 12, 2008, 6:13am

Hi,

Yes, the feature is incorporated in 2.0.0.13. Please check the description notes for Undo/Redo feature.

The following APIs are incorporated, please check.