Focal Point
[SOLVED] Dev Studio seems to freeze up on Excel 2007 spreadsheet

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5387094895

February 10, 2011, 01:34 PM
Stefaans
[SOLVED] Dev Studio seems to freeze up on Excel 2007 spreadsheet
Hi
I have worked with DevStudio and Excel 2007 for years with no problems (until today).
Has anyone picked up the problem that Dev Studio seems to hang up when opening a 2007 spreadsheet with say 250,000 rows and about 5 columns of total width of less than 255 characters. The webserver comes up and seems to be clocking BUT the first of three hold files is never created. WF 7.7.1 with hotfix 3 under windows XP. I thought at first that there might be white characters in the data thus I decided to try to extract the data to a flat pipe delimited file and load the source spreadsheet from there. As mentioned above it never gets to the point where the first hold file (allocated to disk) is created. Any thoughts?
regards Steve

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


WebFOCUS 7.7.01 Windows, TSO 7.0
February 10, 2011, 02:04 PM
Francis Mariani
Not too sure if it's a Dev Studio problem, Dev Studio does not open spreadsheets, the web browser or Excel does...


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
February 10, 2011, 07:01 PM
Stefaans
Hi Francis
Yes Bad terminology. In short, When and if the spreadsheet is accessed it would apprear that no records are being "accessed/processed" as there is no HOLD file produced. As I mentioed before, I have allocated the FTM file to disk to be sure. A million thanks for the reply.
regards Steve


WebFOCUS 7.7.01 Windows, TSO 7.0