To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104142 Issue #|104142 Summary|LoadComponentFromURL w/scalc: filter opens CSV as Writ |er doc 1st time (works thereafter) Component|Spreadsheet Version|OOO310m11 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|jimavera
------- Additional comments from jimav...@openoffice.org Mon Aug 10 23:07:48 +0000 2009 ------- (Using oo3.1.0 OOO310m11 Build 9399 as distributed with Ubuntu Linux 9.04). In Basic code, LoadComponentFromURL using the input filter "scalc: Text - txt - csv (StarCalc)" opens a .CSV file as a Writer doc (not spreadsheet) the first time it is attempted. Subsequent executions in the same session open the .CSV as a spreadsheet as expected. I will attach a small test which demos the problem. It is a .ods spreadsheet containing a button which runs a macro. The macro opens a .CSV file and displays the Identifier of the resulting object ("com.sun.star.sheet.SpreadsheetDocument" is expected). To use the demo, download the .ods file and the "tickers.csv" file. Open the .ods file and edit A1 to contain the path to where you stored tickers.csv and then press the button. On my system, it fails the first time the button is pressed, and works on subsequent presses. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org