Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Peculiar problem facing in web application due to microsoft excel

 
Periakaruppan Thiagarajan
Ranch Hand
Posts: 65
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
We have devoloped a very huge web application for General Motors. The problem we are facing here, whenever we tried to copy either the label or value from the screen (struts with jsp) and paste it in microsoft excel, then try to access the application, the session is getting expired.
This happens only when we copy and paste the content in microsoft excel and not in any other editor like notepad etc.


Thanks,
Pk
 
Jan Groth
Ranch Hand
Posts: 456
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
are you saying:

- you have a webapplication with a user session.
- if you select and copy text in your browser, everything is okay
- if you paste it into notepad, you can continue surfing
- if you paste it into excel, your session expires

???

which browser? which os?

jan.
 
Periakaruppan Thiagarajan
Ranch Hand
Posts: 65
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
jan,

Whatever you have pointed out is correct. We are using Internet Explorer 6.0.2800.1106CO and the client side OS is Windows (any release)

Thanks,
PK
 
Peter Chase
Ranch Hand
Posts: 1970
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Note: this is neither a Java question nor a beginner question. The Web pages may be generated by Java, but that's almost certainly got nothing to do with it.

If your stated observations are indeed correct, then what is happening might be due to the different types of data being posted to different applications.

When you Copy something onto the clipboard, the application from which you are copying (IE in your case) can decide to put more than one version of the data onto the clipboard. For instance, it could put plain text and HTML. More importantly, it could put some Microsoft special linking object (OLE or whatever's the current thing - I'm out of date on MS) on the clipboard that would call back to the originating application when pasted.

When you paste into Notepad, which is a dumb application, it can probably only accept the plain text version.

When you paste into Excel, which is a Microsoft application with all associated bells, whistles (and bugs?), it can probably accept all the different data types, including the special linking object perhaps. Therefore, pasting the data into Excel might cause calls to be made from Excel to IE, to get data or metadata. Maybe there's a bug in this process that causes the session to be expired.

If that's the case, you could work around it by using Paste Special, instead of Paste. When you do Paste Special, it gives you a menu of all the types of data on the clipboard. If you choose something simple like plain text or HTML, the problem might go away.
[ June 08, 2006: Message edited by: Peter Chase ]
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Cutting and pasting anything from IE shouldn't have any effect on your session. Why should it? You are not making a request nor closing IE. Is this all you are doing? How do you open Excel - from inside the browser, or as a completely seperate application? When you say "then try to access the application" do you mean just by going back to the screen you have copied, or clicking a link in the content you have just pasted Excel? Tell us more detail, because what you have so far just doesn make sense.
 
Periakaruppan Thiagarajan
Ranch Hand
Posts: 65
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Peter,

Many thanks.

I tried to paste the content using the option Paste Special by selecting plain text and it was working fine without any session expiry problem.

But, how to solve the issue by using paste option instead of paste special?. Why this is not happening in other web application like yahoo, google and etc.

Thanks,
Pk
 
Periakaruppan Thiagarajan
Ranch Hand
Posts: 65
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Paul,

As per peter comments, it was working fine when we select paste special option instead of paste option.

for your question, we have open a excel as a seperate application and the only link to the web application is the content we have copied. Once pasted in excel, we went back to the screen we have copied and did some other operations like saving the details etc.

Thanks,
Pk
 
Periakaruppan Thiagarajan
Ranch Hand
Posts: 65
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please, can anybody help me on this.
 
Joanne Neal
Rancher
Posts: 3742
16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
As Peter said, this is unlikely to be a Java problem. You might have better luck on an Excel or IE forum.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic