Calc macro to open tab delimited data file?

users
#21

Well, he could always filter your posts out with his email client… :stuck_out_tongue:

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

#22

Hi :slight_smile:
I have just been watching "Black Hawk Down" again, 2nd time in as many decades.  One of the Delta-Force guys got told off for leaving his safety catch off but he responded by wiggling his finger and saying that his finger was his safety catch.  Basically stating that his training was so far in advance of the raw recruits that he was on a different plateau.

All the filtering is a bit like a safety catch.  It's vital for people that are not yet able to guarantee their own good behaviour in a civilised society.  I think fork has handled himself admirably but how would noobs handle the type and level of criticism?  Would they go out and recommend LibreOffice to anyone? 
Regards from
Tom :slight_smile:

#23

Tom Davies <tomdavies04 <at> yahoo.co.uk> writes:

I think fork has handled himself admirably

Thanks!

but how
would noobs handle the type and level of criticism?  Would they go out and

recommend LibreOffice to

anyone?

I have been the person who unnecessarily chewed out listserv posters for what I
thought were stupid questions, and probably drove them away from excellent
projects unnecessarily. I have since seen the error of my ways -- if a post or
a person annoys me, I just don't answer or I suggest an approach that might get
a better answer -- everyone is much happier.

I guess I used to think that I was sort of a policeman keeping the listserv
better quality, but I don't think it actually works that way.

It's all good.

#24

Am 08.03.2012 06:54, Andrew Douglas Pitonyak wrote:

I believe that a sample solution can be found in AndrewBase.odt, search
for the macro listing "Prompt for a CSV file, and then display the data."

Right, your AndrewBase.odt demonstrates how to load plain text database data into the database component, with or without macros.
In the Base tutorials of http://user.services.openoffice.org/en/forum.php we find tutorials and examples about loading plain text database data into 2 different types of databases without any macro code and this is what I suggested in the first place.
With the help of the built-in HSQLDB we can design your own csv editors for specific types of csv files. Once you have these data in Base, a drag&drop dumps them into any other component.

Your latest draft of your macro document http://www.pitonyak.org/OOME_3_0.odt deals with MediaDescriptor and FilterOptions providing a routine to display all arguments that had been used to load a file.

But the issue here is that "fork" insists in using one particular calculating tool called "spreadsheet" but in fact he hates using any tool at all which is why he nags people to write him a tool on top of the tool.

The referenced macro opens a CSV into a Calc document. That said, I do not disagree with your assessment and it will likely only be useful if it works out of the box for his needs. Something about which I cannot comment.