GridWeb OnCellSelected server event

Aspose.Cells Product Family
1

Hi,

I have an ASP web application which uses your gridweb control.

To explain simply, I have the gridweb control and a TextBox. For each cell of the gridweb, I stored server side some additional information in a dictionary. What I need to do is to get the cell information each time a cell is selected and to display it in the TextBox.

However, I did not find in your GridWeb documentation a OnCellSelected server event which allows me to access my dictionary using AJAX.

I hope that I have made this point clear now and I’m waiting for your help,
Thank you,
Best regards,
Romain

2
Hi,

Well, there is no such event on Server side, we have only OnCellDoubleClick event. However, if you need to get / set cell value or even select or activate cell on the sheet, please use our client side events and functions, see the demos for reference:


Thank you.

3

Hi,

Thank you for you reply,

I already use GridWeb OnCellSelected client event. However it does not fit for my need because what I need to get now is a server side information which is specific to each cell.

The amount of information can be huge that is why I did not want to cache it in Javascript client side then accessing to them with the Gridweb client functions/events. I hoped a way to workaround that problem but unfortunatly the gridweb control does not handle the event I expected.

Thank you,
Romain.

4

Hi,

Thanks for your posting and using Aspose.Cells for GridWeb.

Please spare us some time to look into your issue. We have logged your requirements in our database. We will investigate your issue and provide you a fix or advice asap.

This issue has been logged as CELLSNET-41385.

5
Hi,

To update you on your issue, we will provide you a new custom attribute:
E.g.
OnCellSelectedAjaxCallBackClientFunction=MyCustomerDoWithCellSelectCallBack,
Example:
<acw:GridWeb ID="GridWeb1" runat="server" OnCellSelectedAjaxCallBackClientFunction="MyCustomerDoWithCellSelectCallBack"

Also, we will provide a new event handler, CellEventStringHandler，once you select a cell, it will invoke ajaxcall and myCellClickOnAjax will be called on server, and you will return some string value, in the client's js, you can use MyCustomerDoWithCellSelectCallBack(cell, return value of server function) to handle client call back event.

E.g.

in .aspx.cs

CellEventStringHandler myhandle = new CellEventStringHandler(this.myCellClickOnAjax);

GridWeb1.CellClickOnAjax += myhandle;
}
}

private String myCellClickOnAjax(object sender, CellEventArgs e)
{
return "hello" + e.Cell.StringValue;
}

in the client js:
function MyCustomerDoWithCellSelectCallBack(cell, ret)

{alert(ret);
}

We will soon provide a fix (supported version) to include the functionality for your needs here.

Thank you.
6

Hi,

Thank you for the improvement you will make for me. I wait for it.

Romain

7

Hi,


“CELLSNET-41385”:
Please try the attached version/fix: Aspose.Cells.GridWeb v2.7.15.2001, we have included the enhancements in it.

Thank you.
8

Hi,

Thank you for the new version. I tried to use this new event however I have noticed that it works only if you set the EnableAjax GridWeb attribute to true.

The problem is that my application does not handle the GridWeb Ajax communication because when I set it to true I have some issue on tab click. Indeed, when I click on tab button, it happens absolutly nothing I just have the “Loading, please wait…” message for an undetermined time. Moreover, when I look at the network exchanges, I don’t see any url/postback at all and when I put a breakpoint to debug it, on the first line of my page_init event, it is never reached. It is as if the tab buttons were disabled.

However I cannot send you my project because it is too big and it is binded with a lot of different projects/databases. Unfortunatly, I never managed to create a sample project that reproduces the issue.

Thanks,
Romain

9

Hi,


Thanks for your feedback.

I have logged your concerns into our database against your issue “CELLSNET-41385”. Our concerned developer will look into it soon.

For your other issue (tab click issue), We also appreciate if you could create a simpler and runnable project to share it here with us, so that we could investigate and trace the issue to figure it out.

Thank you.
10

Hi,

Well for the tab click issue I tried to create a simpler project which reproduces the bug however I did not managed to do it. I made some investigations by debugging your acwmain.js file. I have noticed that the execution were blocked into the gridajaxupdate(ajxpath) function. In fact this function seems to call itself until the ajaxXmlHttp attribute becomes null. However, that attribute is never set to null that’s why the execution stays here for an undetermined time and no postback is sent.

I really don’t know what to do because of this issue I cannot use the new Event Handler… When I set the EnableAJAX attrubute to false, everything works fine…

Thanks,

11

Hi,


Thanks for providing us more details.

We have logged your concerns and comments into our database against your existing issue. Please spare us some time as our relevant developer will look into it.

Once we have any update on it, we will let you know here.

Thank you.
12

Hi,


To update you, the problem has been fixed, hopefully, we will release the new fix in (1-2) days. You may set EnableAJAX to true, The GridWeb will work fine.

Thank you.
13

Hi,

Thanks for using Aspose.Cells for GridWeb.

We have fixed this issue. Please download and try the latest fix: Aspose.Cells
for GridWeb v2.7.15.2002

14

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

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

Hi,

Sorry for my late answer.

I updated the Gridweb to its latest version (2.7.16.2000) however I have a Javascript issue…

Here is the call stack :

initContent, acwmain.js, Line 68
acwmain, acwmain.js, Line 55
Global code, WebReportGeneratorView.aspx, Line 436
The error happend on root.appendChild(this.xmlDoc.createElement(“SELECT”)); because root is null. I use IE10 with a HTML5 doctype if it could help…

I cannot understand why, maybe you will help me.
Thanks,
Romain.
16

Hi Romain,


Please try our latest attached latest version/fix:Aspose.Cells.GridWeb.2.7.17.2001.zip
If you still find the issue, kindly create a sample project(runnable), zip it and post it here to reproduce the issue on our end. We will check it soon.

Thank you.

17

Hi,

I just tried with the latest version Aspose.Cells.GridWeb.2.7.17.2001.zip however I still have the issue.

I’ve attached you a sample project witch reproduces the problem. You just have to execute it on IE10.

I wait for any update from you.
Thanks

18

Hi,


Thanks for the sample project.

I tested your attached sample project but could not reproduce the issue/error on IE10, Google chrome etc. Could you give us more details and steps involved to reproduce the issue on our end. Also provide some screen shots to highlight the issue when running onto the browser. It will help us to look into your issue more accurately and consequently to fix it.

Thank you.
19

Hi Amjad,

I have recorded a short video which shows the issue.

I attach it to this post.

In fact the problem happens only on IE10. On Google chrome and Firefox, it works fine.

Thanks,

20

Hi,


Thanks for sharing the sample movie to demonstrate the issue.

I have tested your issue in IE 10 but still could not find the javascript error issue. Please find attached the movie taken on my system. However, I noticed one issue i.e. After loading the file into GridWeb, I cannot edit or update any cell value. Do you find this issue (" i.e. After loading the file into GridWeb, I cannot edit or update any cell value"), could you confirm this?

Thank you.