[libreoffice-users] Re: Libre crashed, my document ruined...
Hello, Sorry Tom but I just that I´ve written wrong. The file wasn`t there. I was suppose to write wasn´t but I wrote was... So yeah back to scratch one kind of. -- View this message in context: http://nabble.documentfoundation.org/Libre-crashed-my-document-ruined-tp3486596p3492923.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] LibreOffice write extremely slow to load document with lots of linked pictures
Hi, When I load an MS Word document containing a lot of linked pictures (all on wordpress.org) in LibreOffice it takes over 2 minutes to load. Loading the same document in MS Word takes a few seconds. The difference seems to be that LibreOffice is issuing at least four (and in some cases many more) WebDAV requests for each image, whereas MS Word does a single GET for each image. Each round trip to wordpress.org is taking up to 1s. Is this a known issue? Is there any way to turn off WebDAV in LibreOffice? Thanks. Jim -- For unsubscribe instructions e-mail to: users+h...@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] Data Pilot - external Data
Hello, I've been searching the documentation and the forums for a hint on the following questions: I am using the Pivot Table functionality of calc to analyse data in a MySQL Server. I've succeded in doing this on my own computer, by creating a base document, linked to the source server. My first question is as follows: I find this a little bit confusing: is there a way to directly link Calc to the SQL server via a DSN, like Excel does ? Secondly, i'd like to distribute the spreadsheet prepared on my computer to an range of users, so that they can just refresh the data in those spreadsheet from the source server. Therefore my second question is as follows: how can i minimize the installation work on the other users computers, for them to do this ? In Excel, that is very easy as you can just mail the spreadsheet that contains the source server's address. Is there a way just to distribute the base document containing the link to the server and the calcs ? Thanks a lot, -- For unsubscribe instructions e-mail to: users+h...@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] OpenOffice.org linkage
On 11/8/2011 10:14 PM, Jay Lozier wrote: Hi On 11/08/2011 08:17 PM, JS Higginbotham wrote: I've just downloaded and installed LibreOffice 3.4.3. When I start it up, and either open a file or create a new one (first file only), it complains that: Error loading BASIC of document file:///C:/Program%20Files/OpenOffice.org.1.1.2/share/basic/WebWizard/script.xlb/: General Error followed by: Error loading BASIC of document file:///C:/Program%20Files/OpenOffice.org.1.1.2/share/basic/WebWizard/dialog.xlb/: General Error Registry shows no obvious links between OO.org 1.1.2 and LibreOffice, nor do I see anything in LibreOffice ini files that should produce the errors. Note that when I used LibreOffice 3.3.whichever version I was using last, I still had OO.org 1.1.2 installed, and had no errors. I removed OO.org 1.1.2 and 2.x when I upgraded. Any obvious things I should be checking and/or changing to make this go away and behave itself? JSH Is they check box Enable Experimental (Unstable) Features checked, this turns on macros? (TOOLSOPTIONSLIBREOFFICEGENERAL) If a macro is being used, they will fail until macros are enabled. No, it wasn't. Turning that on doesn't change the behaviour. JSH -- For unsubscribe instructions e-mail to: users+h...@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: Libre crashed, my document ruined...
Hi :( Ouch :( Have you emailed it to yourself or anyone? Any copy on another machine at work, school or home? regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Libre-crashed-my-document-ruined-tp3486596p3493402.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] OpenOffice.org linkage
Hi :) This guide probably isn't hugely useful but it might be worth a glance through http://wiki.documentfoundation.org/Installing_in_parallel I think that trying to get rid of OpenOffice is not quite as straight-forwards as it should be. It is probably a lot easier on Windows but on GnuLinux i have 'had' to use the package-manager to hunt down all the extra add-ons and bitsbobs to uninstall. I think on Windows all those types of things tend to be all together regardless of whether you want each bit or not. I'm not certain but if you have a package manager it's worth having a look at what it can find. Regards from Tom :) --- On Wed, 9/11/11, JS Higginbotham jshig...@republicofnewhome.org wrote: From: JS Higginbotham jshig...@republicofnewhome.org Subject: Re: [libreoffice-users] OpenOffice.org linkage To: users@global.libreoffice.org Date: Wednesday, 9 November, 2011, 12:18 On 11/8/2011 10:14 PM, Jay Lozier wrote: Hi On 11/08/2011 08:17 PM, JS Higginbotham wrote: I've just downloaded and installed LibreOffice 3.4.3. When I start it up, and either open a file or create a new one (first file only), it complains that: Error loading BASIC of document file:///C:/Program%20Files/OpenOffice.org.1.1.2/share/basic/WebWizard/script.xlb/: General Error followed by: Error loading BASIC of document file:///C:/Program%20Files/OpenOffice.org.1.1.2/share/basic/WebWizard/dialog.xlb/: General Error Registry shows no obvious links between OO.org 1.1.2 and LibreOffice, nor do I see anything in LibreOffice ini files that should produce the errors. Note that when I used LibreOffice 3.3.whichever version I was using last, I still had OO.org 1.1.2 installed, and had no errors. I removed OO.org 1.1.2 and 2.x when I upgraded. Any obvious things I should be checking and/or changing to make this go away and behave itself? JSH Is they check box Enable Experimental (Unstable) Features checked, this turns on macros? (TOOLSOPTIONSLIBREOFFICEGENERAL) If a macro is being used, they will fail until macros are enabled. No, it wasn't. Turning that on doesn't change the behaviour. JSH -- For unsubscribe instructions e-mail to: users+h...@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] LibreOffice write extremely slow to load document with lots of linked pictures
Let me get this straight. You are loading a document that has its images location online? Is there a specific reason for that option? To be honest, when I was using MSO in both industry and education, I never heard of that being done. From my point of view with working with documents that contain images, it would be better to have the images stored locally, instead of having to go online to deal with loading them. Now here is an option to look at that might help it a little. It involves the many pictures part of your description of the document. Go to ToolsOptionsMemory You will need to increase the Graphics cache options. Increase the Use for LibreOffice to its max of 256 MB. Increase Memory per object to 20 MB or more. Increase Remove from memory after to double the amount of time you think you will be spending on editing the document. Then increase the Number of objects to 10 or 20 more than the number of images you have in your document. This will help keep the images viewed and on your local system, instead of needing to go mack to the online source[s] to re-view the images withing you document. The load times may be reduced somewhat by this, hopefully. As for the single/multi GET part of the loading of the document, I have no idea what the internals are for LO. I just use it and make some English Dictionaries/Thesaurus extensions for it. . On 11/09/2011 04:23 AM, Jim Talbut wrote: Hi, When I load an MS Word document containing a lot of linked pictures (all on wordpress.org) in LibreOffice it takes over 2 minutes to load. Loading the same document in MS Word takes a few seconds. The difference seems to be that LibreOffice is issuing at least four (and in some cases many more) WebDAV requests for each image, whereas MS Word does a single GET for each image. Each round trip to wordpress.org is taking up to 1s. Is this a known issue? Is there any way to turn off WebDAV in LibreOffice? Thanks. Jim -- For unsubscribe instructions e-mail to: users+h...@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] 98, 000+ word list British dictionary, hyphen, thesaurus dictionary
Well Mark I placed the largest word list version for British and American English online per your request. I will work on the Canadian version later today. I need a break and do other things. It is 9am here where I live and I have to gotten anything done except my emails and these two files. Time for the other stuff. I have a read more chapters of a 1000 page paperback. Deal with my cat. Deal with finding the lowest costing desktop for a friend to buy. Plus a lot more. Sometimes I feel like I am working more after retiring for work due to the injuries and the strokes, than before. My doctors tell me to slow down. SO just for you, I skipped the rest of my work and gave you what you asked for. I have a 638,200+ word list for British English [en_GB] and 638,600+ one for American English [en_US]. http://libreoffice-na.us/English-3.4-installs/add-on-dictionaries-large-list/kpp-british-english-dictionary-638k-word-list.oxt http://libreoffice-na.us/English-3.4-installs/add-on-dictionaries-large-list/kpp-american-english-dictionary-638k-word-list.oxt On 11/08/2011 01:04 PM, Mark Stanton wrote: I'd be happy to have the largest list you can comfortably make. Will it be easy to switch between them if I need or want to? Best regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@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] LibreOffice write extremely slow to load document with lots of linked pictures
Hi Jim, Jim Talbut wrote (09-11-11 10:23) [...] The difference seems to be that LibreOffice is issuing at least four (and in some cases many more) WebDAV requests for each image, whereas MS Word does a single GET for each image. Each round trip to wordpress.org is taking up to 1s. Is this a known issue? Is there any way to turn off WebDAV in LibreOffice? I am quite confident that developers will be interested in this. You may either want to create a bug: http://wiki.documentfoundation.org/BugReport or - if you have some input direct for the code - to the developers list: http://lists.freedesktop.org/mailman/listinfo/libreoffice Thanks for posting. -- - Cor - http://nl.libreoffice.org -- For unsubscribe instructions e-mail to: users+h...@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] Problem: LibreOffice remembers the last folder I was in (open/save dialog)
Platform: Win7 SP1 64-bit LibreOffice 3.4.3 release (though I have had this problem with OpenOffice and LibreOffice since I started using Win7) If I do File Open and open a document from there (which isn't in the default documents folder), then close LibreOffice, re-start it and do File Open again, it opens the location that I went to for the previous document. The same applies for the save dialog. My workaround at present is to enable 'use libreoffice dialogs' in Tools Options, but that is quite a feature-light UI in comparison. It doesn't matter whether I use Writer, Calc or Impress. Also, if I start by using Writer but close LO and move on to say Impress, then Impress remembers the path I last loaded/saved in with Writer. I've also seen this behaviour on more than one fresh install Win7 64-bit / OpenOffice / LibreOffice, and while I haven't tested it for this behaviour on every OS install I've done that includes Open/LibreOffice, on every one I've tested it, it had the problem. Is there an option somewhere to control this behaviour? -- For unsubscribe instructions e-mail to: users+h...@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] Problem: LibreOffice remembers the last folder I was in (open/save dialog)
I wish to comment on this issue. It' more in the nature of how to design the UI rather than a defect in the Suite. I used MSO both in corporate environments and personally for many years. Rarely did I use M$'s My Documents as the storage location for any document. In MSO, it is My Documents that is the default location for any File Open or File Save operation. MSO insistence on having My Documents be the default location was a universal hindrance. We in IT constantly struggled to thwart it. The most we could do was redirect it to a networked share. It is not clear in Mike's posting what exactly he would like the behavior to be. I would hope Mike is not requesting the M$ paradigm. I prefer the existing behavior in LO. Mike's suggestion about an option somewhere to control this behaviour? is very worthy. Some will like the My Documents paradigm; me, not so much. I most frequently use the Recent Documents list within LO. The 10 listed items there are just right historical coverage. Respectfully blustering, -- David S. Crampton On Wed, 09 Nov 2011 07:13:41 -0800, Mike Moratz-Coppins mc_lego...@yahoo.co.uk wrote: Platform: Win7 SP1 64-bit LibreOffice 3.4.3 release (though I have had this problem with OpenOffice and LibreOffice since I started using Win7) If I do File Open and open a document from there (which isn't in the default documents folder), then close LibreOffice, re-start it and do File Open again, it opens the location that I went to for the previous document. The same applies for the save dialog. My workaround at present is to enable 'use libreoffice dialogs' in Tools Options, but that is quite a feature-light UI in comparison. It doesn't matter whether I use Writer, Calc or Impress. Also, if I start by using Writer but close LO and move on to say Impress, then Impress remembers the path I last loaded/saved in with Writer. I've also seen this behaviour on more than one fresh install Win7 64-bit / OpenOffice / LibreOffice, and while I haven't tested it for this behaviour on every OS install I've done that includes Open/LibreOffice, on every one I've tested it, it had the problem. Is there an option somewhere to control this behaviour? -- For unsubscribe instructions e-mail to: users+h...@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] Problem: LibreOffice remembers the last folder I was in (open/save dialog)
Hi :) I couldn't find a setting in Tools - Options - Load/Save and i hunted around in the other pages in there too. It might be worth posting a bug-report and put wishlist in the subject-line along with a couple of words to describe it. I really like the default but it might be nice to have a choice of being able to change that. Perhaps googling it might give a good link? There might be a blog or guide or something written for OpenOffice and that would probably work in LibreOffice too. Sorry i haven't been particularly helpful! I guess try posting a bug-report as a wishlist item and then if you find a better answer you could always give the link and close the report. Regards from Tom :) --- On Wed, 9/11/11, David S. Crampton david_cramp...@ie2b.com wrote: From: David S. Crampton david_cramp...@ie2b.com Subject: Re: [libreoffice-users] Problem: LibreOffice remembers the last folder I was in (open/save dialog) To: users@global.libreoffice.org Date: Wednesday, 9 November, 2011, 15:57 I wish to comment on this issue. It' more in the nature of how to design the UI rather than a defect in the Suite. I used MSO both in corporate environments and personally for many years. Rarely did I use M$'s My Documents as the storage location for any document. In MSO, it is My Documents that is the default location for any File Open or File Save operation. MSO insistence on having My Documents be the default location was a universal hindrance. We in IT constantly struggled to thwart it. The most we could do was redirect it to a networked share. It is not clear in Mike's posting what exactly he would like the behavior to be. I would hope Mike is not requesting the M$ paradigm. I prefer the existing behavior in LO. Mike's suggestion about an option somewhere to control this behaviour? is very worthy. Some will like the My Documents paradigm; me, not so much. I most frequently use the Recent Documents list within LO. The 10 listed items there are just right historical coverage. Respectfully blustering, --David S. Crampton On Wed, 09 Nov 2011 07:13:41 -0800, Mike Moratz-Coppins mc_lego...@yahoo.co.uk wrote: Platform: Win7 SP1 64-bit LibreOffice 3.4.3 release (though I have had this problem with OpenOffice and LibreOffice since I started using Win7) If I do File Open and open a document from there (which isn't in the default documents folder), then close LibreOffice, re-start it and do File Open again, it opens the location that I went to for the previous document. The same applies for the save dialog. My workaround at present is to enable 'use libreoffice dialogs' in Tools Options, but that is quite a feature-light UI in comparison. It doesn't matter whether I use Writer, Calc or Impress. Also, if I start by using Writer but close LO and move on to say Impress, then Impress remembers the path I last loaded/saved in with Writer. I've also seen this behaviour on more than one fresh install Win7 64-bit / OpenOffice / LibreOffice, and while I haven't tested it for this behaviour on every OS install I've done that includes Open/LibreOffice, on every one I've tested it, it had the problem. Is there an option somewhere to control this behaviour? --For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Problem: LibreOffice remembers the last folder I was in (open/save dialog)
On 09/11/2011 16:15, Tom Davies wrote: Hi :) I couldn't find a setting in Tools - Options - Load/Save Tools Options LibreOffice General: use LibreOffice dialogs and i hunted around in the other pages in there too. It might be worth posting a bug-report and put wishlist in the subject-line along with a couple of words to describe it. I really like the default but it might be nice to have a choice of being able to change that. Perhaps googling it might give a good link? There might be a blog or guide or something written for OpenOffice and that would probably work in LibreOffice too. Which behaviour are you seeing (and what OS), out of curiosity? Sorry i haven't been particularly helpful! I guess try posting a bug-report as a wishlist item and then if you find a better answer you could always give the link and close the report. Regards from Tom :) --- On Wed, 9/11/11, David S. Cramptondavid_cramp...@ie2b.com wrote: From: David S. Cramptondavid_cramp...@ie2b.com Subject: Re: [libreoffice-users] Problem: LibreOffice remembers the last folder I was in (open/save dialog) To: users@global.libreoffice.org Date: Wednesday, 9 November, 2011, 15:57 I wish to comment on this issue. It' more in the nature of how to design the UI rather than a defect in the Suite. I used MSO both in corporate environments and personally for many years. Rarely did I use M$'s My Documents as the storage location for any document. In MSO, it is My Documents that is the default location for any File Open or File Save operation. MSO insistence on having My Documents be the default location was a universal hindrance. We in IT constantly struggled to thwart it. The most we could do was redirect it to a networked share. It is not clear in Mike's posting what exactly he would like the behavior to be. I would hope Mike is not requesting the M$ paradigm. I prefer the existing behavior in LO. Mike's suggestion about an option somewhere to control this behaviour? is very worthy. Some will like the My Documents paradigm; me, not so much. I most frequently use the Recent Documents list within LO. The 10 listed items there are just right historical coverage. Respectfully blustering, --David S. Crampton On Wed, 09 Nov 2011 07:13:41 -0800, Mike Moratz-Coppinsmc_lego...@yahoo.co.uk wrote: Platform: Win7 SP1 64-bit LibreOffice 3.4.3 release (though I have had this problem with OpenOffice and LibreOffice since I started using Win7) If I do File Open and open a document from there (which isn't in the default documents folder), then close LibreOffice, re-start it and do File Open again, it opens the location that I went to for the previous document. The same applies for the save dialog. My workaround at present is to enable 'use libreoffice dialogs' in Tools Options, but that is quite a feature-light UI in comparison. It doesn't matter whether I use Writer, Calc or Impress. Also, if I start by using Writer but close LO and move on to say Impress, then Impress remembers the path I last loaded/saved in with Writer. I've also seen this behaviour on more than one fresh install Win7 64-bit / OpenOffice / LibreOffice, and while I haven't tested it for this behaviour on every OS install I've done that includes Open/LibreOffice, on every one I've tested it, it had the problem. Is there an option somewhere to control this behaviour? --For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Problem: LibreOffice remembers the last folder I was in (open/save dialog)
On 09/11/2011 15:57, David S. Crampton wrote: I wish to comment on this issue. It' more in the nature of how to design the UI rather than a defect in the Suite. I used MSO both in corporate environments and personally for many years. Rarely did I use M$'s My Documents as the storage location for any document. In MSO, it is My Documents that is the default location for any File Open or File Save operation. MSO insistence on having My Documents be the default location was a universal hindrance. We in IT constantly struggled to thwart it. The most we could do was redirect it to a networked share. It is not clear in Mike's posting what exactly he would like the behavior to be. I would hope Mike is not requesting the M$ paradigm. I prefer the existing behavior in LO. I was under the impression that the behaviour I'm seeing with LO on Win7 was a bug, as it didn't happen for me at all on WinXP. So to begin with, what you refer to as the MS paradigm is what I'm used to, partly through using MSO and partly through OO/LO on Win7. I'm not implying what I think the behaviour ought to be in this paragraph btw, just stating how I'm used to things. When using the LO dialogs, trying to open a document or save a new one opens the default documents folder. I've previously asked for help when I was using OpenOffice, and it seemed to be the case that some people were seeing the same behaviour that I was and others weren't: http://www.oooforum.org/forum/viewtopic.phtml?t=104648highlight= If the behaviour I'm seeing is the intended behaviour, then an option to configure that behaviour between 'default documents folder' and 'last used folder' would be much appreciated. Mike's suggestion about an option somewhere to control this behaviour? is very worthy. Some will like the My Documents paradigm; me, not so much. I most frequently use the Recent Documents list within LO. The 10 listed items there are just right historical coverage. Respectfully blustering, -- For unsubscribe instructions e-mail to: users+h...@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] Success
I just had to say that the find/change feature in Libre Office and macros work great. In fact the thing I tried to do in Word 2007 didn't work near as well. Now I'm not knocking Word because I like it alot. I have some text documents where I need to extract some segment numbers from and I am able to do it cleanly and very fast using a couple of find/change operations in a single macro. So the everything is striped out leaving just the 3 digit number separated by commas. The whole operation of setting the macro up was faster in Libre Office and it seems there are more regex option available than I was able to find in Word. Anyway the bottom line is I am pleased. I have moved MS Office off my laptop to the computer downstairs at home and am running Libre Office on my laptop. I'm liking it. -- StevenD So you want it fast, good, and cheap. Choose any two. A bad day at the beach is better than a good day at work. -- For unsubscribe instructions e-mail to: users+h...@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] Restore Windows Pop-Up
I am running 3.4.4 and every time I start LibreOffice I get a pop-up window labeled Restore Windows. There are 2 button choices in this pop-up: Don't Restore Windows and Restore Windows. Neither of these buttons does anything when I click on them and the pop-up won't go away. Also, I can't quit LibreOffice; it is grayed-out. I have to Force Quit LibreOffice to get out of it. Any suggestions on how to clear this pop-up.? -- View this message in context: http://nabble.documentfoundation.org/Restore-Windows-Pop-Up-tp3494173p3494173.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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: Howto find all macros in a document and delete or deactivate them?
Le 09/11/2011 10:22, hhm a écrit : Hi Hans, I'm looking for a way to find every macro that is attached to a document and delete or respectively deactivate them. How do I do that? With a script would probably be the easisest way, by unzipping the OD* files and parsing the unzipped contents to seach for the Basic directory, deleting it, then rezipping the file ? Alex -- For unsubscribe instructions e-mail to: users+h...@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: Libre crashed, my document ruined...
Noop, I didn´t manage to anything with it. Well, I think I have to rewrite it then :( but thank you very much for your help! Best wishes from C -- View this message in context: http://nabble.documentfoundation.org/Libre-crashed-my-document-ruined-tp3486596p3494736.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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: Data Pilot - external Data
Add this to your spreadsheet and let it run on open. Edit the db file name which is supposed to be in the same directory as the spreadsheet and edit the registration name. It registers your database if it is not already registered, otherwise it does nothing. Sub registerMyDatabase Const cRegName = BooBoo Const cFileName = test.odb oURL = getURLFromString(ThisComponent.getURL()) sURL = oURL.Protocol oURL.Path cFileName dbc=createUnoService(com.sun.star.sdb.DatabaseContext) If NOT dbc.hasRegisteredDatabase(cRegName) and FileExists(sURL) then dbc.registerDatabaseLocation(cRegName, sURL) endif End Sub Function getURLFromString(s$, optional protocol) REM returns a com.sun.star.util.URL or Basic Null for invalid urls Dim url as new com.sun.star.util.URL Dim srv, bSuccess as Boolean if isMissing(protocol) then protocol = srv = createUnoService(com.sun.star.util.URLTransformer) url.Complete = s if len(protocol)0 then bSuccess = srv.parseSmart(url, protocol) else bSuccess = srv.parseStrict(url) endif if bSuccess then getURLFromString = url else getURLFromString = Null endif End Function -- For unsubscribe instructions e-mail to: users+h...@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] Problem: LibreOffice remembers the last folder I was in (open/save dialog)
Hi :) Errr, either Ubuntu 10.04 or 10.10 but sometimes Xp, all 32bit. In the Save or Open dialogue boxes there is a panel on the left that has either places or a tree/explorer/folders. Can you bookmark/favourites the main folders you use so that they show-up in there easily? Regards from Tom :) --- On Wed, 9/11/11, Mike Moratz-Coppins mc_lego...@yahoo.co.uk wrote: From: Mike Moratz-Coppins mc_lego...@yahoo.co.uk Subject: Re: [libreoffice-users] Problem: LibreOffice remembers the last folder I was in (open/save dialog) To: users@global.libreoffice.org Date: Wednesday, 9 November, 2011, 16:26 On 09/11/2011 16:15, Tom Davies wrote: Hi :) I couldn't find a setting in Tools - Options - Load/Save Tools Options LibreOffice General: use LibreOffice dialogs and i hunted around in the other pages in there too. It might be worth posting a bug-report and put wishlist in the subject-line along with a couple of words to describe it. I really like the default but it might be nice to have a choice of being able to change that. Perhaps googling it might give a good link? There might be a blog or guide or something written for OpenOffice and that would probably work in LibreOffice too. Which behaviour are you seeing (and what OS), out of curiosity? Sorry i haven't been particularly helpful! I guess try posting a bug-report as a wishlist item and then if you find a better answer you could always give the link and close the report. Regards from Tom :) --- On Wed, 9/11/11, David S. Cramptondavid_cramp...@ie2b.com wrote: From: David S. Cramptondavid_cramp...@ie2b.com Subject: Re: [libreoffice-users] Problem: LibreOffice remembers the last folder I was in (open/save dialog) To: users@global.libreoffice.org Date: Wednesday, 9 November, 2011, 15:57 I wish to comment on this issue. It' more in the nature of how to design the UI rather than a defect in the Suite. I used MSO both in corporate environments and personally for many years. Rarely did I use M$'s My Documents as the storage location for any document. In MSO, it is My Documents that is the default location for any File Open or File Save operation. MSO insistence on having My Documents be the default location was a universal hindrance. We in IT constantly struggled to thwart it. The most we could do was redirect it to a networked share. It is not clear in Mike's posting what exactly he would like the behavior to be. I would hope Mike is not requesting the M$ paradigm. I prefer the existing behavior in LO. Mike's suggestion about an option somewhere to control this behaviour? is very worthy. Some will like the My Documents paradigm; me, not so much. I most frequently use the Recent Documents list within LO. The 10 listed items there are just right historical coverage. Respectfully blustering, --David S. Crampton On Wed, 09 Nov 2011 07:13:41 -0800, Mike Moratz-Coppinsmc_lego...@yahoo.co.uk wrote: Platform: Win7 SP1 64-bit LibreOffice 3.4.3 release (though I have had this problem with OpenOffice and LibreOffice since I started using Win7) If I do File Open and open a document from there (which isn't in the default documents folder), then close LibreOffice, re-start it and do File Open again, it opens the location that I went to for the previous document. The same applies for the save dialog. My workaround at present is to enable 'use libreoffice dialogs' in Tools Options, but that is quite a feature-light UI in comparison. It doesn't matter whether I use Writer, Calc or Impress. Also, if I start by using Writer but close LO and move on to say Impress, then Impress remembers the path I last loaded/saved in with Writer. I've also seen this behaviour on more than one fresh install Win7 64-bit / OpenOffice / LibreOffice, and while I haven't tested it for this behaviour on every OS install I've done that includes Open/LibreOffice, on every one I've tested it, it had the problem. Is there an option somewhere to control this behaviour? --For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more:
Re: [libreoffice-users] Re: Howto find all macros in a document and delete or deactivate them?
On Wed, 2011-11-09 at 20:12 +, Alex Thurgood wrote: Le 09/11/2011 10:22, hhm a écrit : Hi Hans, I'm looking for a way to find every macro that is attached to a document and delete or respectively deactivate them. How do I do that? With a script would probably be the easisest way, by unzipping the OD* files and parsing the unzipped contents to seach for the Basic directory, deleting it, then rezipping the file ? Hi Alex, I was thinking it took a bit more then that and so I just tried it and yes. You need to make three changes. After unzipping the file you remove two directories: = Basic = Dialogs Then you need to edit the file manifest.xml in the META-INF directory. - remove all lines that reference basic or dialog. [They look something like] manifest:file-entry manifest:media-type=text/xml manifest:full-path=Basic/Standard/script-lb.xml/ Then you re-zip and voila it works. If you leave out the last step the file will not open. HTH somehow, //drew -- For unsubscribe instructions e-mail to: users+h...@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] Theausarus inactive
What OS are you using? What Windows version? Or what Linux version you are using? The following came from an earlier solution, but it might work for you. [quote:] Another--more user-friendly --workaround: Rename (or remove) th e folder 'bundled' [path : ...\LibreOffice\3\user\extensions\bundled]. Then restart LibreOffice. The bundled dictionaries extensions will be synchronized again (for the user profile) with the correct current location. [unquote:] Depending on which OS you are using, the exact path for the folder may be different. Some OS installs have this issue while other installs on the same OS did not have the issue. This may be a random problem and the bug is being looked into, but it is hard to reproduce when it does not happen during all installs on the OS. Now, which language are you using? US-American English, British English, or Canadian English, for your default English? [if English is your default language] Some English version do not have a default thesaurus option. I am currently working on English spelling dictionaries with hyphenation and thesaurus included. I have American, British, and Canadian versions with word lists ranging from 98,000 words to 638,000 words in the spelling word lists. If you want to try one, please go to this link and download and install - via the ToolsExtension Manager - any or all of the kpp dictionaries in the English section of the list. By the way, this list is the largest listing for LibreOffice, till they are all included but their authors in the LibreOffice Extension Center My 180+ dictionary list [over localized 20 Spanish ones] - including my kpp set of dictionaries with a few more to come. http://libreoffice-na.us/English-3.4-installs/dictionary.html The LibreOffice Extension Center link http://extensions.libreoffice.org/extension-center . On 11/09/2011 04:11 PM, somesooner wrote: Thesaurus inactive (greyed out) in 3.4.3. Could not turn on. Installed 3.4.4. Still no thesaurus. ? -- View this message in context: http://nabble.documentfoundation.org/Theausarus-inactive-tp3494870p3494870.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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: Howto find all macros in a document and delete or deactivate them?
On 11/09/2011 05:07 PM, drew wrote: On Wed, 2011-11-09 at 20:12 +, Alex Thurgood wrote: Le 09/11/2011 10:22, hhm a écrit : Hi Hans, I'm looking for a way to find every macro that is attached to a document and delete or respectively deactivate them. How do I do that? With a script would probably be the easisest way, by unzipping the OD* files and parsing the unzipped contents to seach for the Basic directory, deleting it, then rezipping the file ? Hi Alex, I was thinking it took a bit more then that and so I just tried it and yes. You need to make three changes. After unzipping the file you remove two directories: = Basic = Dialogs Then you need to edit the file manifest.xml in the META-INF directory. - remove all lines that reference basic or dialog. [They look something like] manifest:file-entry manifest:media-type=text/xml manifest:full-path=Basic/Standard/script-lb.xml/ Then you re-zip and voila it works. If you leave out the last step the file will not open. HTH somehow, //drew Drew's method will work just fine if what you mean to do is to remove all macros contained in a document (as opposed to removing all references to macros from inside the document; in a button or an associated event, for example). -- 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+h...@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] Calc: Sort By Column Names?
I have a large spreadsheet with column titles in row 1, and I need to sort the columns alphabetically by their titles. It appears that the sort function (as in all the spreadsheets I've used in the past) will sort by rows in a specified column, but I need to sort columns by a specified row. Possible? If so, please point me to instructions. TIA, Rich -- For unsubscribe instructions e-mail to: users+h...@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: Howto find all macros in a document and delete or deactivate them?
On 11/09/2011 05:45 PM, Andrew Douglas Pitonyak wrote: On 11/09/2011 05:07 PM, drew wrote: On Wed, 2011-11-09 at 20:12 +, Alex Thurgood wrote: Le 09/11/2011 10:22, hhm a écrit : Hi Hans, I'm looking for a way to find every macro that is attached to a document and delete or respectively deactivate them. How do I do that? With a script would probably be the easisest way, by unzipping the OD* files and parsing the unzipped contents to seach for the Basic directory, deleting it, then rezipping the file ? Hi Alex, I was thinking it took a bit more then that and so I just tried it and yes. You need to make three changes. After unzipping the file you remove two directories: = Basic = Dialogs Then you need to edit the file manifest.xml in the META-INF directory. - remove all lines that reference basic or dialog. [They look something like] manifest:file-entry manifest:media-type=text/xml manifest:full-path=Basic/Standard/script-lb.xml/ Then you re-zip and voila it works. If you leave out the last step the file will not open. HTH somehow, //drew Drew's method will work just fine if what you mean to do is to remove all macros contained in a document (as opposed to removing all references to macros from inside the document; in a button or an associated event, for example). See if you can make the document current and run this macro Sub RemoveAllContainedLibs Dim sNames Dim oLibs Dim i% oLibs = ThisComponent.BasicLibraries sNames = oLibs.getElementNames() For i = UBound(sNames) To LBound(sNames) Step -1 oLibs.removeLibrary(sNames(i)) Next oLibs = ThisComponent.DialogLibraries sNames = oLibs.getElementNames() For i = UBound(sNames) To LBound(sNames) Step -1 oLibs.removeLibrary(sNames(i)) Next End Sub -- 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+h...@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: Calc: Sort By Column Names?
Rich Shepard wrote: I have a large spreadsheet with column titles in row 1, and I need to sort the columns alphabetically by their titles. It appears that the sort function (as in all the spreadsheets I've used in the past) will sort by rows in a specified column, but I need to sort columns by a specified row. Possible? If so, please point me to instructions. Yes, it is possible but not very intuitive :) Select the block to be sorted, click on Data, Sort, click on the Options tab and uncheck the Range contains column labels option, click on the last radio button Left to right (sort columns). Click on the Sort Criteria tab, make sure that Row 1 is showing the Sort by box and press OK. Worked for me :) -- View this message in context: http://nabble.documentfoundation.org/Calc-Sort-By-Column-Names-tp3495112p3495199.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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:Libre-Base Pushbutton Macro
Dear Sir, I would be much obliged if you could help me with the following problem Using LibreBase (Ubuntu 11.10) I tried to make a pushbutton macro to open a form Name2c from within another form From the Internet I get the following script Sub OpenAForm(oEv As Object) Dim GetFormName As String Dim GetForm as Object GetFormName = Name2c GetForm = ThisDatabaseDocument.FormDocuments.GetByName(GetFormName) GetForm.Open End Sub however when I run it the following message appears Basic runtime error Object variable not set Could you provide me with the correct script Thanking you for your attention and cooperation Your Investment - Wealth - Health - Education consultant Budi Machribie (F06592) The SunHorse Team PT.Sunlife Finance Indonesia Gd CIMB-Niaga 3Ath fl Jl.Jen.Sudirman kav 25 Jakarta 12920 +08161815979 Blog-http://tough2slf.multiply.com/ Website: http://www.tough2slf.net78.net/ End Sub -- 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+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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: Calc: Sort By Column Names?
On Wed, 9 Nov 2011, Pedro wrote: Yes, it is possible but not very intuitive :) Pedro, Perhaps not intuitive, but much easier seeing the last radio button to sort by columns. I completely missed that when I looked at both dialog box tabs. Worked for me :) Me, too! Thanks very much, Rich -- For unsubscribe instructions e-mail to: users+h...@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: Calc: Sort By Column Names?
Rich Shepard wrote: Perhaps not intuitive, but much easier seeing the last radio button to sort by columns. I completely missed that when I looked at both dialog box tabs. I mentioned that it is not intuitive because even if you found the last radio button, if you didn't uncheck the Range contains column labels box, it wouldn't work. Rich Shepard wrote: Thanks very much, You are welcome ;) -- View this message in context: http://nabble.documentfoundation.org/Calc-Sort-By-Column-Names-tp3495112p3495242.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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: Calc: Sort By Column Names?
On Wed, 9 Nov 2011, Pedro wrote: I mentioned that it is not intuitive because even if you found the last radio button, if you didn't uncheck the Range contains column labels box, it wouldn't work. Ah, so. That is counter-intuitive since selecting all cells (ctrl-a) includes the column labels. Rich -- For unsubscribe instructions e-mail to: users+h...@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: Howto find all macros in a document and delete or deactivate them?
On Wed, 2011-11-09 at 17:55 -0500, Andrew Douglas Pitonyak wrote: On 11/09/2011 05:45 PM, Andrew Douglas Pitonyak wrote: On 11/09/2011 05:07 PM, drew wrote: On Wed, 2011-11-09 at 20:12 +, Alex Thurgood wrote: Le 09/11/2011 10:22, hhm a écrit : Hi Hans, I'm looking for a way to find every macro that is attached to a document and delete or respectively deactivate them. How do I do that? With a script would probably be the easisest way, by unzipping the OD* files and parsing the unzipped contents to seach for the Basic directory, deleting it, then rezipping the file ? Hi Alex, I was thinking it took a bit more then that and so I just tried it and yes. You need to make three changes. After unzipping the file you remove two directories: = Basic = Dialogs Then you need to edit the file manifest.xml in the META-INF directory. - remove all lines that reference basic or dialog. [They look something like] manifest:file-entry manifest:media-type=text/xml manifest:full-path=Basic/Standard/script-lb.xml/ Then you re-zip and voila it works. If you leave out the last step the file will not open. HTH somehow, //drew Drew's method will work just fine if what you mean to do is to remove all macros contained in a document (as opposed to removing all references to macros from inside the document; in a button or an associated event, for example). See if you can make the document current and run this macro Sub RemoveAllContainedLibs Dim sNames Dim oLibs Dim i% oLibs = ThisComponent.BasicLibraries sNames = oLibs.getElementNames() For i = UBound(sNames) To LBound(sNames) Step -1 oLibs.removeLibrary(sNames(i)) Next oLibs = ThisComponent.DialogLibraries sNames = oLibs.getElementNames() For i = UBound(sNames) To LBound(sNames) Step -1 oLibs.removeLibrary(sNames(i)) Next End Sub -- Hi Andrew, Excellent - the only problem is, and it aint yours per so, is removing libraries from a document - at least with LibO 3.4.4 as that is what I tried it on - does not set the dirty flag for the documnet. So if you run the macro and close the document the change isn't saved...arrrgh. Best wishes, //drew -- For unsubscribe instructions e-mail to: users+h...@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:Libre-Base Pushbutton Macro
On Wed, 2011-11-09 at 15:36 -0800, budi machribie wrote: Dear Sir, Hi Budi For future reference - It is much better if you start a new thread for new questions, rather then changing the subject line from an existing discussion. I would be much obliged if you could help me with the following problem Using LibreBase (Ubuntu 11.10) I tried to make a pushbutton macro to open a form Name2c from within another form From the Internet I get the following script Sub OpenAForm(oEv As Object) Dim GetFormName As String Dim GetForm as Object GetFormName = Name2c GetForm = ThisDatabaseDocument.FormDocuments.GetByName(GetFormName) GetForm.Open End Sub however when I run it the following message appears Basic runtime error Object variable not set Yeah - the problem is that the psudo variable ThisDatabaseDocument is only valid when the macro is contained in a basic library embedded in the ODB file - and refers explicitly to this Base file without regard from where it's called. So, I'm guessing your calling it from a shared Basic library, just move the code into the ODB file and your good to start. Best wishes, //drew -- For unsubscribe instructions e-mail to: users+h...@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: Howto find all macros in a document and delete or deactivate them?
Am 10.11.2011 01:02, drew wrote: On Wed, 2011-11-09 at 17:55 -0500, Andrew Douglas Pitonyak wrote: sNames = oLibs.getElementNames() For i = UBound(sNames) To LBound(sNames) Step -1 oLibs.removeLibrary(sNames(i)) Next End Sub sNames = oLibs.getElementNames() For i = UBound(sNames) To LBound(sNames) Step -1 if sNames(i)Standard then oLibs.removeLibrary(sNames(i)) ThisComponent.setModified(True) endif Next End Sub -- Hi Andrew, Excellent - the only problem is, and it aint yours per so, is removing libraries from a document - at least with LibO 3.4.4 as that is what I tried it on - does not set the dirty flag for the documnet. So if you run the macro and close the document the change isn't saved...arrrgh. Best wishes, //drew -- For unsubscribe instructions e-mail to: users+h...@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: Howto find all macros in a document and delete or deactivate them?
On Thu, 2011-11-10 at 01:41 +0100, Andreas Säger wrote: Am 10.11.2011 01:02, drew wrote: On Wed, 2011-11-09 at 17:55 -0500, Andrew Douglas Pitonyak wrote: sNames = oLibs.getElementNames() For i = UBound(sNames) To LBound(sNames) Step -1 oLibs.removeLibrary(sNames(i)) Next End Sub sNames = oLibs.getElementNames() For i = UBound(sNames) To LBound(sNames) Step -1 if sNames(i)Standard then oLibs.removeLibrary(sNames(i)) ThisComponent.setModified(True) endif Next End Sub -- Howdy Andreas, Cool - now back to something Andrew noted - what about places where the embedded macros might called from. Not sure how to find everywhere, but we can enhance that basic procedure to clear out any document event handlers. Sub RemoveAllContainedLibs Dim sNames Dim oLibs Dim i% Dim EmptyEventProps(1) as new com.sun.star.beans.PropertyValue oLibs = ThisComponent.BasicLibraries sNames = oLibs.getElementNames() For i = UBound(sNames) To LBound(sNames) Step -1 oLibs.removeLibrary(sNames(i)) Next oLibs = ThisComponent.DialogLibraries sNames = oLibs.getElementNames() For i = UBound(sNames) To LBound(sNames) Step -1 oLibs.removeLibrary(sNames(i)) Next ' ' clear all document event handlers For i = UBound(ThisComponent.Events.elementNames) To LBound(ThisComponent.Events.elementNames) Step -1 ThisComponent.Events.ReplaceByName(ThisComponent.Events.ElementNames(i), EmptyEventProps()) next ' ' force dirty flag on document ThisComponent.setModified(True) End Sub -- For unsubscribe instructions e-mail to: users+h...@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: Howto find all macros in a document and delete or deactivate them?
On 11/09/2011 07:02 PM, drew wrote: On Wed, 2011-11-09 at 17:55 -0500, Andrew Douglas Pitonyak wrote: On 11/09/2011 05:45 PM, Andrew Douglas Pitonyak wrote: On 11/09/2011 05:07 PM, drew wrote: On Wed, 2011-11-09 at 20:12 +, Alex Thurgood wrote: Le 09/11/2011 10:22, hhm a écrit : Hi Hans, I'm looking for a way to find every macro that is attached to a document and delete or respectively deactivate them. How do I do that? With a script would probably be the easisest way, by unzipping the OD* files and parsing the unzipped contents to seach for the Basic directory, deleting it, then rezipping the file ? Hi Alex, I was thinking it took a bit more then that and so I just tried it and yes. You need to make three changes. After unzipping the file you remove two directories: = Basic = Dialogs Then you need to edit the file manifest.xml in the META-INF directory. - remove all lines that reference basic or dialog. [They look something like] manifest:file-entry manifest:media-type=text/xml manifest:full-path=Basic/Standard/script-lb.xml/ Then you re-zip and voila it works. If you leave out the last step the file will not open. HTH somehow, //drew Drew's method will work just fine if what you mean to do is to remove all macros contained in a document (as opposed to removing all references to macros from inside the document; in a button or an associated event, for example). See if you can make the document current and run this macro Sub RemoveAllContainedLibs Dim sNames Dim oLibs Dim i% oLibs = ThisComponent.BasicLibraries sNames = oLibs.getElementNames() For i = UBound(sNames) To LBound(sNames) Step -1 oLibs.removeLibrary(sNames(i)) Next oLibs = ThisComponent.DialogLibraries sNames = oLibs.getElementNames() For i = UBound(sNames) To LBound(sNames) Step -1 oLibs.removeLibrary(sNames(i)) Next End Sub -- Hi Andrew, Excellent - the only problem is, and it aint yours per so, is removing libraries from a document - at least with LibO 3.4.4 as that is what I tried it on - does not set the dirty flag for the documnet. So if you run the macro and close the document the change isn't saved...arrrgh. Yeah, I noticed that too. I considered changing the macro to set the document dirty (I think that I can do that), but, decided it was not worth the trouble to look up how to do it I upgraded to Fedora 16, installed LO 3.4.3, and then the next day they release 3.4.4 sigh. So that is the same version that I tested with as well. -- 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+h...@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] Problem: LibreOffice remembers the last folder I was in (open/save dialog)
Mike, I fully agree that it should be made as an optional behavior. I don't know how to submit that idea. As a feature request perhaps in Bugzilla? On Wed, 09 Nov 2011 08:26:22 -0800, Mike Moratz-Coppins mc_lego...@yahoo.co.uk wrote: If the behaviour I'm seeing is the intended behaviour, then an option to configure that behaviour between 'default documents folder' and 'last used folder' would be much appreciated. -- David S. Crampton -- For unsubscribe instructions e-mail to: users+h...@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