Re: [libreoffice-users] Re: Calc macro to open tab delimited data file?

On 03/08/2012 07:12 AM, Andreas Säger wrote:
> 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.

> Today's even more blatant example of not using a software tool: 
> http://www.oooforum.org/forum/viewtopic.phtml?t=145216
> Finally he hired a coder because he can not apply simple formulas.
>
> While "fork" is waiting for a lazy person who writes a csv import 
> routine for tab separated files with unknown encoding, unknown text 
> delimiters, suppressing evaluation for an unknown amount of columns, 
> he may try a dedicated csv editor which helped so many spreadsheet 
> non-users: http://csved.sjfrancke.nl/

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted