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

2012-03-08 Thread Andrew Douglas Pitonyak
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

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

2012-03-08 Thread fork
Tom Davies 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 thou

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

2012-03-08 Thread Tom Davies
how would noobs handle the type and level of criticism?  Would they go out and recommend LibreOffice to anyone?  Regards from Tom :) --- On Thu, 8/3/12, Johnny Rosenberg wrote: From: Johnny Rosenberg Subject: Re: [libreoffice-users] Re: Calc macro to open tab delimited data

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

2012-03-08 Thread Johnny Rosenberg
2012/3/8 fork : > Andreas Säger t-online.de> writes: > > >> 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. > > Andreas --

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

2012-03-08 Thread Johnny Rosenberg
2012/3/7 fork : > Johnny Rosenberg gmail.com> writes: > >> >> 2012/3/7 Andreas Säger t-online.de>: >> > Again, it is technically and logically impossible to write a program >> > without >> > knowing anything about the input. >> >> A Tab delimited text file – what more could we want to know? >> S

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

2012-03-08 Thread fork
Andreas Säger t-online.de> writes: > 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. Andreas -- could I ask a favor?

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

2012-03-08 Thread Andreas Säger
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

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

2012-03-07 Thread Andreas Säger
Am 08.03.2012 01:48, fork wrote: Andreas Säger t-online.de> writes: Am 07.03.2012 22:03, Johnny Rosenberg wrote: A Tab delimited text file – what more could we want to know? 4 different lines of tab delimited text each with 4 identical values: 2012/03/08 1,213.59text7-8

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

2012-03-07 Thread fork
Andreas Säger t-online.de> writes: > > Am 07.03.2012 22:03, Johnny Rosenberg wrote: > > > > A Tab delimited text file – what more could we want to know? > > 4 different lines of tab delimited text each with 4 identical values: > > 2012/03/081,213.59text7-8 > "2012-03-08" "1,21

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

2012-03-07 Thread Andreas Säger
Am 07.03.2012 22:03, Johnny Rosenberg wrote: A Tab delimited text file – what more could we want to know? 4 different lines of tab delimited text each with 4 identical values: 2012/03/08 1,213.59text7-8 "2012-03-08" "1,213.59""text""7-8" 8.März1201213,59

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

2012-03-07 Thread fork
MiguelAngel miguelangel.mobi> writes: > Sorry, have you taken a look on internet to find something about. > > http://user.services.openoffice.org/en/forum/viewtopic.php?f=20&t=40585&p=186925&hilit=macro+import+text+file#p186925 I saw this, but I don't need to insert part of a file into my docu

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

2012-03-07 Thread MiguelAngel
El 07/03/12 22:41, fork escribió: Johnny Rosenberg gmail.com> writes: 2012/3/7 Andreas Säger t-online.de>: Again, it is technically and logically impossible to write a program without knowing anything about the input. A Tab delimited text file – what more could we want to know? Some text

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

2012-03-07 Thread fork
Johnny Rosenberg gmail.com> writes: > > 2012/3/7 Andreas Säger t-online.de>: > > Again, it is technically and logically impossible to write a program without > > knowing anything about the input. > > A Tab delimited text file – what more could we want to know? > Some text ↹ More text ↹ More te

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

2012-03-07 Thread Johnny Rosenberg
2012/3/7 Andreas Säger : > Again, it is technically and logically impossible to write a program without > knowing anything about the input. A Tab delimited text file – what more could we want to know? Some text ↹ More text ↹ More text again ↹ Text again, perhaps ↵ Another row with text, ↹ and ↵ an

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

2012-03-07 Thread Andreas Säger
Again, it is technically and logically impossible to write a program without knowing anything about the input. If you can not copy a few lines of text from a text editor, then I will have to explain too many details anyway. End of discussion. Bye. -- For unsubscribe instructions e-mail to:

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

2012-03-07 Thread Andreas Säger
Am 07.03.2012 19:24, fork wrote: Andreas Säger t-online.de> writes: May be you did not notice that LibreOffice remembers the import settings for text files. If you need to open the same type of file repeatedly, you can specify the import options once and next time you simply confirm the dial

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

2012-03-07 Thread fork
Andreas Säger t-online.de> writes: > > May be you did not notice that LibreOffice remembers the import settings > for text files. > If you need to open the same type of file repeatedly, you can specify > the import options once and next time you simply confirm the dialog. Yes, and that is gre

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

2012-03-07 Thread fork
Andreas Säger t-online.de> writes: > > All that "Inelligent Technology" is about data processing. Input > > Processing -> Output. Without knowing anything about the input there is > no way to write any program to process data. > Programmers are lazy because they know how to write routines to s

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

2012-03-07 Thread Andreas Säger
May be you did not notice that LibreOffice remembers the import settings for text files. If you need to open the same type of file repeatedly, you can specify the import options once and next time you simply confirm the dialog. -- For unsubscribe instructions e-mail to: users+h...@global.libre

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

2012-03-07 Thread Andreas Säger
All that "Inelligent Technology" is about data processing. Input > Processing -> Output. Without knowing anything about the input there is no way to write any program to process data. Programmers are lazy because they know how to write routines to solve the same problem once for all times. You a

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

2012-03-07 Thread fork
Andreas Säger t-online.de> writes: > A couple of lines of actual data copied from a text editor tell more than > thousand words. I don't really have any lines to show -- do you want screenshots or something? I am hoping to develop a macro that opens files a certain way. There isn't anything to

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

2012-03-07 Thread Andreas Säger
Am 07.03.2012 00:35, fork wrote: I can provide any more info if anyone would like. A couple of lines of actual data copied from a text editor tell more than thousand words. P.S. -- I don't really want to get good at macro writing, so I am hoping for the very quickest quick hack, rather th