To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=113956
------- Additional comments from f...@openoffice.org Thu Aug 19 08:03:03 +0000
2010 -------
Got a mail from Paul describing the Issue.
@Paul: Please write such comments not as a personal Mail but into the Issue
itself so other people can have a look too.
Purpose is to make a macro for retrieving data from a file from Euronext (as an
example)
1. I have loaded the list of shares from Euronext, that is automatically put
in a Excel-file
2. I made a spreadsheet in Calc and copied that file into Calc.
3. I made a additional sheet in the file of item 2.
4. I have listed the preferred shares with the codes as these are listed in
the Euronext-file.
5. To find the apropriate data of those shares I used the function: Vlookup
(in Dutch is is called Vert.zoeken)
The formula looks like:
Vlookup($A5;Euronext.$A$5:$M$1152;c$3)
where A5 is the code for whicht the function is looking for
where Euronext.A5:M1152 is the table in which the function has to search
where C3 is cell wherein the number of the colunm is located.
6. Using th function with the code, it is not working.
However, I have found a work-around solution using a indexnumbeer in the
Euronext-file and provied each preferred share its own indexnumber.
7. To use the function on a regular base, I would like to use this function
in a macro avoiding the repeat the composing of the function each time I
use it.
8. When I make a macro, the function does not work at all, moreover looking
into the Basic code, there is not a line where the function is called.
---------------------------------------------------------------------
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
