Issue 104142 - LoadComponentFromURL w/scalc: filter opens CSV as Writer doc 1st time (works thereafter)
Summary: LoadComponentFromURL w/scalc: filter opens CSV as Writer doc 1st time (works ...
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOO310m11
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2009-08-11 00:07 UTC by jimavera
Modified: 2017-05-20 09:57 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
.ods with macro demonstrating the problem (12.22 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-08-11 00:08 UTC, jimavera 		no flags Details
Test data used by the previously-attached demo (404 bytes, text/plain)
2009-08-11 00:09 UTC, jimavera 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description jimavera 2009-08-11 00:07:48 UTC 
(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.
Comment 1 jimavera 2009-08-11 00:08:40 UTC 
Created attachment 64051 [details]
.ods with macro demonstrating the problem
Comment 2 jimavera 2009-08-11 00:09:11 UTC 
Created attachment 64052 [details]
Test data used by the previously-attached demo
Comment 3 amy2008 2009-08-11 04:22:46 UTC 
Can't open CSV file by pressing the button, I can confirm that the path is 
right.
Comment 4 jimavera 2009-08-11 05:20:38 UTC 
Here is the macro code from the demo, in case it triggers any ideas:

  Dim tickers_oDoc as Object
  clrargs()
  pusharg("FilterName", "scalc: Text - txt - csv (StarCalc)")
  pusharg("FilterFlags", "44,34,SYSTEM,1,1/1/1/1/1/1/1/1/1/1")
  pusharg("ReadOnly", True)
  ' pusharg("Hidden", True)
  tickers_oDoc = StarDesktop.LoadComponentFromURL(Url, "_blank", 0, args() )
Comment 5 Rob Weir 2013-02-02 02:55:20 UTC 
This Issue requires more information ('needmoreinfo'), but has not been updated
within the last year. Please provide feedback as requested and re-test with the the latest version of OpenOffice - the problem(s) may already be addressed. 

You can download Apache OpenOffice 3.4.1 from http://www.openoffice.org/download

Please report back the outcome of your testing, so this Issue may be closed or
progressed as necessary - otherwise the issue may be Resolved as Invalid in the
future.
Comment 6 Edwin Sharp 2014-01-16 11:26:57 UTC 
First open in Calc.

AOO410m1(Build:9750)  -  Rev. 1558424
Rev.1558424
Win 7