Re: [libreoffice-users] Do Macros run serially or in parallel?
Hi Noel So are you trigering these events and running the macros to populate a form from two separate tables? Alex On Sunday 06 Apr 2014 00:13:31 Marion Noel Lodge wrote: Hi, Sorry I've been slow to respond to all your posts. It has taken me a while to sort out what I think is happening. Fernand, thanks for your code suggestion. I pasted it into the start of my macros and the Wait() statement worked perfectly. Then I incorporated it into my Init macro and discovered that none of my Wait() statements worked. The same applied to the AccName macro. I was really puzzled and probably spent longer than I should have on the problem, but I felt I really needed an answer. Finally, through much trial and error I found which macros Wait() worked in and which it didn't. My testing was not exhaustive, but it seems that Wait() doesn't work in any macro that is called from one of the Form's events. When I got back to reading my emails, I discovered that Andrew was predicting that this might be the case! Then it occurred to me that, rather than use separate text files for printing out the Now() values, if I used just one file, it would give me the order of processing, and the exact times would not be so important. So I did that and also added System Ticks / 1000. The result was as follows - Init 1. 05/04/2014 23:20:37 43421.801 Init 2. 05/04/2014 23:20:37 43421.801 Init 3. 05/04/2014 23:20:37 43421.817 Init 4. 05/04/2014 23:20:37 43421.833 Init 5. 05/04/2014 23:20:37 43421.848 Init 6. 05/04/2014 23:20:40 43424.36 Init 7. 05/04/2014 23:20:40 43424.375 Name 1. 05/04/2014 23:20:40 43424.625 Name 2. 05/04/2014 23:20:40 43424.625 Name 3. 05/04/2014 23:20:40 43424.625 This demonstrates that macro Init ran before macro Name. From this, and a number of other tests I ran, I believe that - 1. Macros are always processed serially on a first come first served basis. 2. If macro A calls macro B, then Macro A waits until macro B has completed before the remaining code of macro A is processed. These were the conclusions that I was hoping for. As well, I now have a mechanism for checking out other timing situations where I'm not sure what is going on. So thank you all for your input - it has been an interesting journey! Noel -- Noel Lodge lodg...@gmail.com PS Alex, Yes you are right - the account name needs to be fetched from another table. -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: Microsoft Revisits the '80s With MS-DOS, Word for Windows Source Code,
Il 04/04/2014 23:56, CVAlkan ha scritto: Sorry for the trip down memory lane, but I agree that this is undoubtedly some sort of publicity stunt. Call me cynical, but I can't help wondering what's up their sleeve with this. No need to apologise. FWIW, I really enjoyed reading your post. :) Marcello -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: Microsoft Revisits the '80s With MS-DOS, Word for Windows Source Code,
Kracked_P_P---webmaster wrote: Maybe I got confused. I thought my 10 inch was from a DEC system. It was sure big. Maybe they used a different type. I donated it to a college teaching staff for demoing old tech, along with my samples of a punched card program, and some paper tape. No, DEC floppies were 8 too. Back when I was a computer tech, I used to maintain some VAX 11/780 systems. On them, the CPU needed to have the microcode loaded, before it could do anything. This was done by an LSI-11 (microprocessor version of the PDP-11), which loaded the microcode from a floppy and loaded it into the CPU. I hated CP/M and had to deal with an early college computer center that had IBM [brand and not clones] PC-XTs and a few of them actually had a graphics card and not the original 80x40 characters type of display. They all were double single-sided floppy 5.25 inch. The other rooms had old Apple [before Macs] and they had CP/M OS options, and the next room had DEC terminals to the mini-mainframes. While I was there a math professor brought in the new Apple computer called a Macintosh. We also a 10 inch screen portable PC-AT or XT that weighted over 40 pounds. The next college center had both DEC terminals and a few dual floppy PCs that were connected to the DEC system via a terminal emulator called Kermit, if my memory is correct. I used its upload/download abilities to save all my work for that college onto the floppies and also did some editing at home. My first PC I had at home was a clone from a kit that cost about half of the IBM prices. Those were the days of the early home PC market and the beginning of a PC in every home idea. Before them, most home computer devices were toys. I only used CP/M on a Supercalc course I took. My first computer, an IMSAI 8080 could run CP/M, *IF* you had floppy drives, which I didn't. I used audio cassettes. When I was taking a Fortran course, I used Procomm+ as a terminal emulator to connect to the school computer. I also had an XT clone. -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] RE : Re: [libreoffice-users] Re: Microsoft Revisits the '80s With MS-DOS, Word for Windows Source Code,
Jean-Louis Oneto wrote: When Microsoft bought DRI Microsoft didn't buy DRI. They bought Q-DOS from Seattle Computer Products. Gary Kildall, creator of CP/M later took MS to court and proved that MS-DOS contained directly copied CP/M code. -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: Microsoft Revisits the '80s With MS-DOS, Word for Windows Source Code,
Jim Seymour wrote: No, they didn't. Early Apple PCs ran the MOS Technologies (later: Mostek) 6502. CP/M never ran on anything but the Intel 8080 and Zilog Z80. (And only on the latter because it was a superset of the former.) Eventually, Kildall realized the 8-bit processors' days were numbered (duh) and created CP/M-86, but, by then, it was way, way too late. There was a Z80 CP/M card available for Apple computers that was made by Microsoft. There were also clones of that card available. -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] RE : Re: [libreoffice-users] Re: Microsoft Revisits the '80s With MS-DOS, Word for Windows Source Code,
Jim Seymour wrote: Nor was CP/M-86 vapourware. It was short-lived, because Kildall was way too late to the game, but it did exist. IIRC, the DEC Rainbow dual-booted CP/M-86 and DOS? CP/M-86 was also one of the 3 operating systems that were initially available with the IBM PC. The third was called (IIRC) pCode or something like that. -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: Microsoft Revisits the '80s With MS-DOS, Word for Windows Source Code,
James Knott: Gary Kildall, creator of CP/M later took MS to court and proved that MS-DOS contained directly copied CP/M code. Gary Kildall was a kind of man who believed that you can write something once and get dividends from it indefinitely. That didn't work well. -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Intentionally crashing LibreOffice when frozen/LibreOffice will not start.
I clicked the link, it took me to home page. I click Download Gnumeric and it takes me back to the home page. I've tried all the variations I can find -- how do I download it? On Sat, Apr 5, 2014 at 4:12 AM, Tom Davies tomc...@gmail.com wrote: Hi :) Try Gnumeric; http://www.gnumeric.org/download.html It's a dedicated spreadsheet program with a tiny footprint that uses minimal resources, so it's faster, lighter and more robust than Excel or Calc. Many people find Gnumeric to be better than Calc or Excel for serious or hefty spreadsheets and/or for handling many more spreadsheets in a shorter time-frame. It can be installed alongside LibreOffice and/or MS Office. It uses the same format as LibreOffice natively so most spreadsheets can be bounced between the 2 programs quite happily. Part of the advantage of LibreOffice is that it fits well into a wider eco-system and co-operates well with a wider range of programs and suites allowing you to tailor individual machines to specific use-cases and yet still retain the ability to share files between different machines and different people using different OSes and programs. Regards from Tom ) On 5 April 2014 06:43, Andrew Douglas Pitonyak and...@pitonyak.org wrote: On 04/04/2014 07:44 PM, andrewH wrote: I am working with a data set that keeps causing my LibreOffice to freeze. I am pretty sure that this is only because it is big. It is a pipe-separated text from the US Economic Census imported into Calc, about 30 columns and around a million rows. (The actual data set is bigger, but Calc quits at a million-odd. The complete file is about 0.8 gig.) I suspect but can not prove that this is related to file handling somehow, e.g. breaking down during auto-saving. The first time I saved the data as a Calc file it took nearly an hour with the soffice.bin *32 process running at 25 percent of CPU time and using about 825 meg of memory the entire time. (Not sure why this is showing up as a 32-bit version). And when Calc freezes, all the LibreOffice programs freeze. So I can't just switch to another file and noodle away while waiting. It looks to me as though Calc cannot handle more than 1048576 rows of data, Do you have more rows than that? If yes, then I think that you cannot open the file. If you have less than that, and, if you think that you are simply running out of memory if you can figure out how to get the data to me, I can run a test on a 64 bit version (running on Linux). My machine has 32 GB of RAM... -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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 -- Helen Etters using Linux, suse12.3 -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Re: Microsoft Revisits the '80s With MS-DOS, Word for Windows Source Code,
CVAlkan: When WordPerfect 5.x arrived, there was even the ability to display a graphic preview (almost WYSIWYG) display of the printed output on a normal character screen - and this was available not only for DOS versions, but on a wide variety of platforms such as the then popular DEC and DG terminals. You are trying to defend a text processor which stores text in a proprietary encoding in the obscured format. Comparing to this, MS Word which used easy and open file format was a clear winner. -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Intentionally crashing LibreOffice when frozen/LibreOffice will not start.
Hi Helen, if you are using linux it should be in the repos so install from there. If windows I went to gnumeric.org. Underneath welcome it shows Gnumeric 1.12.13 and I clicked on the get it from here link. On the next page I selected the link under windows, save to my computer, etc. Not sure what to do if you are mac user :( HTH Tim On 07/04/14 07:59, Helen wrote: I clicked the link, it took me to home page. I click Download Gnumeric and it takes me back to the home page. I've tried all the variations I can find -- how do I download it? On Sat, Apr 5, 2014 at 4:12 AM, Tom Davies tomc...@gmail.com wrote: Hi :) Try Gnumeric; http://www.gnumeric.org/download.html It's a dedicated spreadsheet program with a tiny footprint that uses minimal resources, so it's faster, lighter and more robust than Excel or Calc. Many people find Gnumeric to be better than Calc or Excel for serious or hefty spreadsheets and/or for handling many more spreadsheets in a shorter time-frame. It can be installed alongside LibreOffice and/or MS Office. It uses the same format as LibreOffice natively so most spreadsheets can be bounced between the 2 programs quite happily. Part of the advantage of LibreOffice is that it fits well into a wider eco-system and co-operates well with a wider range of programs and suites allowing you to tailor individual machines to specific use-cases and yet still retain the ability to share files between different machines and different people using different OSes and programs. Regards from Tom ) On 5 April 2014 06:43, Andrew Douglas Pitonyak and...@pitonyak.org wrote: On 04/04/2014 07:44 PM, andrewH wrote: I am working with a data set that keeps causing my LibreOffice to freeze. I am pretty sure that this is only because it is big. It is a pipe-separated text from the US Economic Census imported into Calc, about 30 columns and around a million rows. (The actual data set is bigger, but Calc quits at a million-odd. The complete file is about 0.8 gig.) I suspect but can not prove that this is related to file handling somehow, e.g. breaking down during auto-saving. The first time I saved the data as a Calc file it took nearly an hour with the soffice.bin *32 process running at 25 percent of CPU time and using about 825 meg of memory the entire time. (Not sure why this is showing up as a 32-bit version). And when Calc freezes, all the LibreOffice programs freeze. So I can't just switch to another file and noodle away while waiting. It looks to me as though Calc cannot handle more than 1048576 rows of data, Do you have more rows than that? If yes, then I think that you cannot open the file. If you have less than that, and, if you think that you are simply running out of memory if you can figure out how to get the data to me, I can run a test on a 64 bit version (running on Linux). My machine has 32 GB of RAM... -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: Microsoft Revisits the '80s With MS-DOS, Word for Windows Source Code,
Urmas wrote: Comparing to this, MS Word which used easy and open file format was a clear winner. Gee... I coulda sworn April 1st was last week. -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: Microsoft Revisits the '80s With MS-DOS, Word for Windows Source Code,
On 06/04/14 23:04, Urmas wrote: You are trying to defend a text processor which stores text in a proprietary encoding in the obscured format. Comparing to this, MS Word which used easy and open file format was a clear winner. Microsoft has never used an open file format for ANY software. Not even the Microsoft's supposedly ISO document standard format is really open because it embeds proprietary binary blobs. -- Italo Vignoli - italo.vign...@gmail.com mob IT +39.348.5653829 - mob EU +39.392.7481795 sip it...@libreoffice.org - skype italovignoli GPG Key ID - 0xAAB8D5C0 DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0 -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: Microsoft Revisits the '80s With MS-DOS, Word for Windows Source Code,
On 04/06/2014 05:04 PM, Urmas wrote: CVAlkan: When WordPerfect 5.x arrived, there was even the ability to display a graphic preview (almost WYSIWYG) display of the printed output on a normal character screen - and this was available not only for DOS versions, but on a wide variety of platforms such as the then popular DEC and DG terminals. You are trying to defend a text processor which stores text in a proprietary encoding in the obscured format. Comparing to this, MS Word which used easy and open file format was a clear winner. I am not sure of my time line, but I remember only proprietary formats for early desktop applications and every software house had their own formats. The problem occurred because no one expected the problems with file type obsolescence. I doubt you can easily find a program that will open most word processing or spreadsheets from the before 1990 and you with some difficulty find one that will convert the old formats to a current one. -- Jay Lozier jsloz...@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Intentionally crashing LibreOffice when frozen/LibreOffice will not start.
Hi :) Yeh, from this page http://www.gnumeric.org/download.html click the blue link in the paragraph about the Windows version. That should start downloading the exe file. If you use Linux or Bsd then the best way is to use one of your package managers (such as Synaptic package manager) to install the version in your repositories. Regards from Tom :) On 6 April 2014 23:33, Tim Lloyd tim.ll...@gmx.com wrote: Hi Helen, if you are using linux it should be in the repos so install from there. If windows I went to gnumeric.org. Underneath welcome it shows Gnumeric 1.12.13 and I clicked on the get it from here link. On the next page I selected the link under windows, save to my computer, etc. Not sure what to do if you are mac user :( HTH Tim On 07/04/14 07:59, Helen wrote: I clicked the link, it took me to home page. I click Download Gnumeric and it takes me back to the home page. I've tried all the variations I can find -- how do I download it? On Sat, Apr 5, 2014 at 4:12 AM, Tom Davies tomc...@gmail.com wrote: Hi :) Try Gnumeric; http://www.gnumeric.org/download.html It's a dedicated spreadsheet program with a tiny footprint that uses minimal resources, so it's faster, lighter and more robust than Excel or Calc. Many people find Gnumeric to be better than Calc or Excel for serious or hefty spreadsheets and/or for handling many more spreadsheets in a shorter time-frame. It can be installed alongside LibreOffice and/or MS Office. It uses the same format as LibreOffice natively so most spreadsheets can be bounced between the 2 programs quite happily. Part of the advantage of LibreOffice is that it fits well into a wider eco-system and co-operates well with a wider range of programs and suites allowing you to tailor individual machines to specific use-cases and yet still retain the ability to share files between different machines and different people using different OSes and programs. Regards from Tom ) On 5 April 2014 06:43, Andrew Douglas Pitonyak and...@pitonyak.org wrote: On 04/04/2014 07:44 PM, andrewH wrote: I am working with a data set that keeps causing my LibreOffice to freeze. I am pretty sure that this is only because it is big. It is a pipe-separated text from the US Economic Census imported into Calc, about 30 columns and around a million rows. (The actual data set is bigger, but Calc quits at a million-odd. The complete file is about 0.8 gig.) I suspect but can not prove that this is related to file handling somehow, e.g. breaking down during auto-saving. The first time I saved the data as a Calc file it took nearly an hour with the soffice.bin *32 process running at 25 percent of CPU time and using about 825 meg of memory the entire time. (Not sure why this is showing up as a 32-bit version). And when Calc freezes, all the LibreOffice programs freeze. So I can't just switch to another file and noodle away while waiting. It looks to me as though Calc cannot handle more than 1048576 rows of data, Do you have more rows than that? If yes, then I think that you cannot open the file. If you have less than that, and, if you think that you are simply running out of memory if you can figure out how to get the data to me, I can run a test on a 64 bit version (running on Linux). My machine has 32 GB of RAM... -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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