Hyperlink and SessionMode

Aspose.Cells Product Family
1

Hi,

I have a report with Hyperlink and image.

When I click in hyperlink, I open same WebForm with other excel. When I back for first WebForm, the excel is incorrect.
GridWeb is using same Session for two WebForms.
I tried using SessionMode = ViewState or Custom but occurs error with image.
System.Runtime.Serialization.SerializationException: O tipo 'System.Drawing.Imaging.ImageFormat' no assembly 'System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' não está marcado como serializável.

steps for simulate:
1 - Session
a - select SessionMode = Session
b - select Add Image = true
c - click "Open Report"
d - click "Level 1.1.1"
e - click "Sheet 2"
f - close webform
g - click "Evaluation Warning"
h - click "Sheet 2"

2 - Image
a - select SessionMode = ViewState or Custom
b - select Add Image = true
c - click "Open Report"

Thank you

2

Hi,


Thank you for your posting.

I was able to observe the issues that you have mentioned. I have forwarded these details to our development team to look into it further. We will let you know here about the status once we get an update from our development team.

The issue has been logged as: CELLSNET-40764.
3

Hi,

Any workaround?

Thank you.

4

Hi,

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

I have logged your comments against the issue id: CELLSNET-40764

We will investigate and if there is some workaround for this issue, we will let you know asap.

5

Hi,

Thanks for using Aspose.Cells for GridWeb.

We have checked your mentioned bug and we find that when we will serialize a picture, there will be an error, so if you want to use SessionMode = ViewState or Custom, the worksheet should not contain any pictures

We will fix this bug in future, but currently we have no plans for it.

6

Hi,

ok, no problem. I can use SessionMode = Session and put images in my worksheets.

But I need to resolve the first problem.

"1 - Session
a - select SessionMode = Session
b - select Add Image = true
c - click "Open Report"
d - click "Level 1.1.1"
e - click "Sheet 2"
f - close webform
g - click "Evaluation Warning"
h - click "Sheet 2"

Help me, please.

7

Hi,

Thanks for your input.

I have logged your comments against the issue id: CELLSNET-40764

We will look into your mentioned issue and try to resolve it and update you asap.

If we need any further information at your end, we will ask you to provide.

8
suzukinishi:

Hi,

ok, no problem. I can use SessionMode = Session and put images in my worksheets.

But I need to resolve the first problem.

"1 - Session
a - select SessionMode = Session
b - select Add Image = true
c - click "Open Report"
d - click "Level 1.1.1"
e - click "Sheet 2"
f - close webform
g - click "Evaluation Warning"
h - click "Sheet 2"

Help me, please.

Hi,

Thanks for using Aspose.Cells for GridWeb.

We have looked into your issue but we need your further help to elaborate this problem more. Please provide us screenshots and sample project replicating your issue with the latest version: Aspose.Cells for GridWeb v2.7.8.2010

It will help us resolve your issue quickly.
9

Hi,

The sample project is in first post.

I created a video: untitled.zip.

Thank you.

10

Hi,


Thanks for sharing the video tutorial.

After an initial test, I can find the issue as you mentioned via your video: Hyperlink and SessionMode

I followed the steps involved as described:
1 - Session
a - select SessionMode = Session
b - select Add Image = true
c - click “Open Report”
d - click “Level 1.1.1”
e - click “Sheet 2”
f - close webform
g - click “Evaluation Warning”
h - click “Sheet 2”

The issue is when performing the above steps, almost all the contents/data are gone/invalid on the web page.

We have already reopened your issue and we will look into it soon.
Once we have any update on it, we will let you know here.

Thank you.


11
Hi,

We have analyzed your first problem thoroughly. For the first time, you load the page "frmFRW317.aspx", and the second time you also load the page, so, it will use the same session for you. On the server side, one session and one instance is implemented, so, when the second time you load the page "frmFRW317.aspx", the initial value (for GridWeb) changed.

We advise you should use two pages, e.g., one may be "frmFRW317.aspx", another may be "frmFRW317-2.aspx", the function will be ok.


Thank you.
12

Hi,

I can't use multiple "frmFRW317-X.aspx" because the level is infinite.
The user can open multiple pages and I dont' have how to know if it's two, three or four, ... pages.

Can I customize the Session ID?

13

Hi,


I think it is the behavior/limitation of Session object and I am not sure if anything can be done as you do not want to use multiple pages.

I have logged a comment with your issue and our concerned developer will check it. Once we have any update on it, we will let you know.

thanks,
14

Hi,

From your requirements, we suggest that you can custom the function as follows.

Copy frmFRW317.aspx and rename it to frmFRW3172.aspx

Change the GridWeb1_CellCommand method of frmFRW317 page.

protected void GridWeb1_CellCommand(object sender, Aspose.Cells.GridWeb.CellEventArgs e)
{
if (e.Argument.ToString() == “LINK”)
{
this.OpenUrlModalFixed(“frmFRW317-2.aspx?cell=” + e.Cell.StringValue + “&sessionmode=” + this.SessionMode + “&addimage=” + this.AddImage);
}
}

Then when you click “Level 1.1.1”, there will show “Details Level 1.1.1”

Then when you click “Level 1.2.1”, there will show “Details Level 1.2.1”

Then when you click “Level 1.2.2”, there will show “Details Level 1.2.2”

By the way, there is no way custom session id , even if it can custom , but for one page , one session id , it is the same as each other .

15

I don't like this solution but it worked.

Thank you.

16

Hi,

Thanks for your feedback.

It’s good to know that solution is workable, please let us know what sort of problems you are facing with the above solutions, we will further look into it and try to provide you more viable solution.