Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Excel and Excel Plug In Conflicts

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Excel and Excel Plug In Conflicts
 Login/Join
 
Master
posted
When excel is running in the plug in and I launch ordinary excel or vice versa I sometimes experience unpredictable behaviour such as the screen freezing.

Sometimes this is because a user needs to answer a prompt and if you alt-tab you eventually get to it.

Does anybody have a policy that cures this (other than advising users to use one at a time)?

Does setting excel with /e (existing) or /n (new window launch) resolve any of this.

Does applying later servicepacks of excel (we are on 2003) fix things?

This message has been edited. Last edited by: Kerry,



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
 
Posts: 888 | Location: Airstrip One | Registered: October 06, 2006Report This Post
Master
posted Hide Post
Something that may be of use.

If you kill excel via task manager you kill the plug ins too. So the plug in is not a separate program but uses excel.



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
 
Posts: 888 | Location: Airstrip One | Registered: October 06, 2006Report This Post
Expert
posted Hide Post
Curious to understand what the Excel Pug In is...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Master
posted Hide Post
The 'plug in' is just excel running in the browser.

Within IE a plug in application is defined to be triggered for certain mime types in the HTML message the browser receives.

Similarly PDF is a plug in.



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
 
Posts: 888 | Location: Airstrip One | Registered: October 06, 2006Report This Post
Member
posted Hide Post
hammo1j,
We have experieced some issues when using Excel Templates. When the Excel template file is opened from WebFOCUS and the users Excel 2003 is not at the Service Pack 3 level, there were errors and strange behavior.

We have also instructed our users to not use the Excel browser plug-in but use 'real' Excel. This can be accomplished in Windows Explorer, select Tools, Folder Opetions, File Types. FInd XLS click the Advanced button and de-select "Browse in Same window". This forces Excel to open.

Hope this helps.


Dev- WF 7.68 on Windows Server 2003: DB2, SQL Server 2K, SQL Server 2005, SQL Server Anaysis Services 2005.
Test- WF 7.67 on Windows Server 2003: DB2, SQL Server 2K, SQL Server 2005, SQL Server Anaysis Services 2005.
Prod - Dev- WF 7.65 on Windows Server 2003: DB2, SQL Server 2K, SQL Server 2005, SQL Server Anaysis Services 2005
 
Posts: 10 | Registered: July 22, 2004Report This Post
Silver Member
posted Hide Post
We have also found that Excel 2003 and Excel 2007 have different behaviors under Vista. More salt into the wound!


A message from the darks side, there is!
 
Posts: 39 | Registered: August 28, 2007Report This Post
Master
posted Hide Post
Thanks Nick

Using excel 2003 SP3 cures a host of problems. I would suggest IBI officially lists this as a requirement as the behaviour generally gets blamed on webfocus rather than excel.

Regards

John



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
 
Posts: 888 | Location: Airstrip One | Registered: October 06, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Excel and Excel Plug In Conflicts

Copyright © 1996-2020 Information Builders