Issue 79469 - insertAtPosition ignores CSV filter options
Summary: insertAtPosition ignores CSV filter options
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:
Depends on:
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: ---

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

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 
("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
could you, please, provide file with macro and sample .csv?

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:
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.

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