Issue 79469 - insertAtPosition ignores CSV filter options
Summary: insertAtPosition ignores CSV filter options
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.2
Hardware: All Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-07-11 11:29 UTC by dindy
Modified: 2013-02-07 21:51 UTC (History)
4 users (show)

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

Attachments
Document with macros importing a CSV (12.16 KB, application/vnd.oasis.opendocument.text)
2008-05-14 18:14 UTC, bmarcelly 		no flags Details
Sample of simple CSV file (188 bytes, text/plain)
2008-05-14 18:15 UTC, bmarcelly 		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 dindy 2007-07-11 11:29:23 UTC 
Using the insertAtPosition methods in a VB macro seems to ignore the CSV filter 
options. A call like this:

Document.AreaLinks.insertAtPosition(Position, SURL, STab, "Text - txt - csv 
(StarCalc)", "44,34,SYSTEM,1,1/1/2/10/3/10/4/10/5/10/6/10/7/10")

always use the default filter options, no matter how the filter options are 
set. A similar call made using the loadComponentFromURL:

NDocument = StarDesktop.loadComponentFromURL(SURL, "_blank", 0,Array
(MakePropertyValue("FilterName", "Text - txt - csv 
(StarCalc)"),MakePropertyValue
("FilterOptions", "44,34,SYSTEM,1,1/1/2/10/3/10/4/10/5/10/6/10/7/10"),MakeProper
tyValue("Hidden", False)))

applies the correct filter options, so I'm pretty sure that it isn't a problem 
in the filter options specifications.
Comment 1 dindy 2007-08-01 09:24:25 UTC 
I tried also with the Link function of the sheet object. With it the filter 
options work properly, so I've been able to create a work around for the 
insertAtPosition function by linking a temporary sheet and then copying to the 
final position.
Comment 2 kpalagin 2007-12-16 17:14:09 UTC 
dindy,
could you, please, provide file with macro and sample .csv?

Thanks.
Comment 3 dindy 2007-12-17 11:13:21 UTC 
I'll do it as soon as possible, I'm a bit busy now. BTW I was simply 
downloading Yahoo Stock Quotes. See for example:

http://ichart.yahoo.com/table.csv?s=%
5ESTOXX50E&a=05&b=6&c=2006&d=11&e=17&f=2007&g=d&ignore=.csv
Comment 4 bmarcelly 2008-05-14 18:12:06 UTC 
The bug is present in 1.1.5 and 2.4.0.
I will attach a CSV file and a document with macros showing the problem.
Comment 5 bmarcelly 2008-05-14 18:14:22 UTC 
Created attachment 53630 [details]
Document with macros importing a CSV
Comment 6 bmarcelly 2008-05-14 18:15:53 UTC 
Created attachment 53631 [details]
Sample of simple CSV file
Comment 7 kpalagin 2008-05-15 17:47:41 UTC 
Confirming with 2.4 on WinXP - as described.
P.S. You need to put CSVexample.txt in "C:\Docs OpenOffice" or adjust path in 
macro accordingly.

bmarcelly,
thanks a ton for this clear example!
Comment 8 pmike 2009-12-30 11:58:17 UTC 
same on OOo 3.2 m68