Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

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

Andrew Pitonyak
My Macro Document:

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.