[libreoffice-users] Re: --convert-to txt:Text *.odp, *.ods
Hi :) Once you change the settings for converting to text i think the setting stays the same until you re-set it. So from then on when you use headless mode to save as text-files it should avoid all the commas. You know that .csv stands for Comma Separated Values and that looks like it's been a standard way of exchanging data in text-format for a couple of decades. There is also tsv but that seems to be a lot rarer. Isn't fixed-width a really unusual format? Regards from Tom :) From: jomali jomali3...@gmail.com To: Trever L. Adams trever.ad...@gmail.com Cc: users@global.libreoffice.org Sent: Saturday, 20 October 2012, 21:34 Subject: Re: BUG/FEATURE: Re: [libreoffice-users] --convert-to txt:Text *.odp, *.ods On Sat, Oct 20, 2012 at 3:46 PM, Trever L. Adams trever.ad...@gmail.comwrote: On 10/20/2012 12:53 PM, jomali wrote: snip I believe it is a bug that Impress and Calc won't do text export. Yes, Calc does .csv, but the commas are a problem. A text export should use spaces (if this can be done on the command line then calc works. Impress needs a text export. In Calc: 1. Save As... 2. Choose to save as csv; tick Edit Filter Settings 3. Accept Use Text CSV Format 4. Tick Fixed Column Width 5 Save file That will not work for massive batch/automatic conversions. Trever I'm sorry. I did not understand your requirement. LO provides a programming interface that can provide such special case functionality. I doubt that it would ever be provided in LO itself. John -- 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] North American DVD 3.5.6
Hi :) Don't worry about checking it. The best way to know is to burn the dvd and then see if it works :( The NA team doesn't know how to generate the checksums. They keep asking how to generate them but no-one helps them. I don't know either, just in case you wondered. If you could point them to some documentation or help them learn how to generate md5sums or Sha or whatever then that would be a huge help. Apols and regards from Tom :) From: Russ Fineman upsc...@nwi.net To: users@global.libreoffice.org Sent: Sunday, 21 October 2012, 2:18 Subject: [libreoffice-users] North American DVD 3.5.6 I just downloaded the DVD mentioned in the Subject. I want to verify the download is good but have not found a location on the North American website to get the checksums. K3B says there is an MD5 checksum of: 96560a0b6c117a07d32d33baa1e2ef30 Is this correct? Shouldn't the checksums be available on the website. i already use LibreOffice on My Linux base system. See Signature. I now want to put it on my wife's Win 7 system. Thanks. Russ -- openSUSE 12.2(Linux 3.4.11-2.16-desktop x86_64)| KDE 4.9.2 release 511|Intel core2duo 2.5 MHZ,|8GB DDR3|GeForce 8400GS(NVIDIA-Linux-x86_64-304.51) -- 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: how to crack a PW in LO?
Hi :) It's easy to create an extremely secure system. The problem is that people then want access to it. Immediately that creates a weakness. Then they want it to be easy access and if they get that then there is no security. After making a system weak they then complain about it being weak and want to upgrade the system and blame the people that setup the previous system for failing to keep it secure. Most of the fight in creating a secure system is not technical. It's about convincing people not to subvert their own security. Regards from Tom :) From: Steve Edmonds steve.edmo...@ptglobal.com To: dennis.hamil...@acm.org Cc: 'Sandy Harris' sandyinch...@gmail.com; users@global.libreoffice.org Sent: Saturday, 20 October 2012, 23:23 Subject: Re: [libreoffice-users] Re: how to crack a PW in LO? It is interesting how insecure password protection is, and how we forgo security for convenience, I recently had to gain access to a Win7 machine with lost administrator PW. It was trivial but led me and a work colleague to rainbow tables, GPU cracking and just how fast a PW can be cracked. Our discussions got to slowing things down, double encrypt with different methods (encrypt content with RSA using a hash from a long random password) or not allow automated PW entry (capcha with PW entry). Either way it becomes inconvenient and therefore will probably not be used. Steve On 2012-10-21 09:30, Dennis E. Hamilton wrote: Oh, why is (7) considered Good News, below? Well, it takes 45*365+197 16,500 cooperating culprits to crack a 7-character random password in 1 day. If that seems too feasible (it might be), try a challenging length, like 16 characters. Just remember the Worse News, (8) in my previous message. At some point, it is necessary to abandon passwords as reliable for protecting the privacy of encrypted documents. All they do is increase the risk that an ordinary user will lose a password and not be able to open one of their own private documents. - Dennis -Original Message- From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] Sent: Saturday, October 20, 2012 13:15 To: 'Sandy Harris'; users@global.libreoffice.org Subject: RE: [libreoffice-users] Re: how to crack a PW in LO? [ ... ] 6. GOOD NEWS #1 (for now): Even allowing for (4-5), the estimates for longer passwords are heartening: Pwd Accent OFFICE Length Time Estimate (same conditions) 5 27m03s 6 1d19h 7 173d3h 8 45y197d You can see why length and random selection from the full 95 ASCII codes matters. Using larger character sets is even better, of course. I routinely use 15-character randomly-chosen passwords that are never used for more than one purpose. 7. GOOD NEWS #2 (for now): It is possible to crowd-source this work on multiple processors or as a challenge with multiple hackers over the internet, where the attack space is subdivided. Normally, one would not want to share the document, especially if its decryption is extremely valuable. However, there are parts of encrypted ODF documents that are benign and usable in a community/cloud-based attack. Once the password is recovered for that portion, the holder of the complete document can decrypt all of it. [ ... ] -- 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] Suitability of Lo in Small organisations
Best all you LibO experts and Devs! What Webmaster now says is a good example on all the basic level issues that must be completely eliminated from LibO. Some posts ago I asked what version of LibO at this moment is to be considered as the most reliable and most stable. And got the answer that LibO3.5.7 is the one for newcomers perhaps followed by LibO3.6.2. (But nothing said about Base, that is my main concern and asked for) For all of you that know LibO's build-up, its features and work-arounds and alternative solutions these issues may seem simple. But for users like me they are serious - I do not even know where to start looking for a solution if I meet such a problem. It is really a matter of using LibO or not -- and I do not want to have different programs/suites for different types of need. My main interest is to get the job done and because of limits in time or costs I cannot accept delays caused by the tool I use. Obviously I have to continue - even if I don't want to - to buy MSO. A lack of resources is not a valid excuse as long as you can continue developing new bugs and issues - plus them 1000-2000 already waiting for fixing. I know very well that it is never fun to afterwards repair mistakes - so better not to make them. Waiting for the results of your wise decisions - especially regarding Windows with some 90% of the users. Pertti Rönnberg On 20.10.2012 23:57, webmaster-Kracked_P_P wrote: The freezing and word count issues - was that on 3.5.6, 3.5.7, or some other version. I have noticed that 3.5.7 freezes sometimes on loading/opening with Ubuntu 64-bit 12.04 and MATE desktop. I never saw this with 3.5.6 and Ubuntu 10.04 and GNOME desktop. Since I upgraded to 12.04 on Oct. 8th and 3.5.7 when it came out on the 18th, I did not have much time with 12.04 and 3.5.6 to tell if there was any issues. The freezing happened several times. Once with clicking on the panel launcher and twice with the right-clicking and open with option. The only way to get the LO splash/opening to unfreeze is to reboot. Actually when Ubuntu reboots, LO opens up properly. I have the system set to open any packages with windows open when I log off or shut-down/re-boot. So I do get the freezing splash screen once and a while for 3.5.7. Is this an issue with other users of 3.5.7? On 10/20/2012 03:10 PM, Anthony Easthope wrote: I haven't yet given them the 3.5.7 release as I have still been away! the bugs where mainly freezing wordcount and thelike On Sat, 20 Oct 2012, at 03:49 PM, Tom Davies wrote: Hi :) +1 Was it something that would have been easily fixed by renaming the User Profile? Regards from Tom :) From: rost52 bugquestcon...@online.de To: users@global.libreoffice.org Sent: Friday, 19 October 2012, 7:17 Subject: Re: [libreoffice-users] Suitability of Lo in Small organisations It would be interesting to learn what version was used, which bugs were observed and if they were all reported an when. On 2012-10-19 10:39, Anthony Easthope wrote: Hi guys I was wondering what would perhaps be the best release of LO to recommend to a small charitable organisation. I had a problem with the latest release as it was quite buggy and the church athletics club I installed it for was not to happy when they found the bugs interrupted their workflow, So what is the most stable release? -- Anthony Easthope antiso...@myopera.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 -- 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
[libreoffice-users] Cannot add auto-increment field as 4th field.
Software: Libreoffice base Version: 3.5.4.2 (Debian Wheezy) Subject: Cannot add auto-increment field as 4th field. Goal: Add 4th field as unique ID / record counter. 1. Table with 3 fields as primary key. 2. Added 4th field as integer 3. Set 4th field as auto-increment. 4. Saved table which completes without errors or warnings. 5. Opened table and 4th field is not set as auto-increment. This is very frustrating because I need the 4th field to be auto-incrementing so that I can set it as the primary key for the table. This table has evolved to the point where it needs a unique ID field for performance reasons. I've tried opening the table up and manually enumerating the 4th field before turning on the auto-increment and it still doesn't save the field as auto-increment. I've been able to do this kind of operation with a large number of other database software (MS Access, MS SQL, MySQL, etc.) but it's my first time using Libreoffice. Am I doing something obviously wrong here? It seems Libreoffice base only supports the first field in every table as an auto-increment field. Is this true? And if that's the case do I need to completely recreate the whole table to add an auto-increment field? Is this a bug? Or a feature limitation? Thanks. -- 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] Cannot add primary key after saving without primary key.
Software: Libreoffice base Version: 3.5.4.2 (Debian Wheezy) Subject: Cannot add primary key after saving without primary key. I've got a problem. I'm trying to test some different table designs. Whenever I create a table without a primary key, I find that I cannot go back and add a primary key later. When I first save the table, Libreoffice asks me if I want to create a primary key now. I choose no because I'm experimenting with some different table designs and didn't want to commit to anything just yet. 1. Create table without primary key. 2. Save table. 3. Libreoffice asks if I want to create a primary key now. 4. I choose no. 5. I later then open the table and set the primary key. 6. I save the table. 7. I open the table again and the primary key that I chose was not saved! I've never had this kind of problem with a database before. Is this a bug or a missing feature? -- 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] Suitability of Lo in Small organisations
Hi :) I've not had any freezing on Win Xp, Win7 or Ubuntu but that was all with 3.5.4. The 3.5.7 should be about the same but just a bit more stable. It's only bug-fixes and such added on so nothing new added and so no new surprises. If something straight-forwards doesn't work the 1st thing i do is poke around and see if i can find another way. If not i try a bunch of stuff at roughly the same time; ask colleagues how they would do it, open up a guide or 2, consider if some other program might be better for the task or if the task needs doing at all. If still stuck then i would; rename user-profile, dig around the lists, post a new question to the list, even start reading the documentation i had opened. Just because people are on this list doesn't mean they are experts. I guess some people do learn a lot by listening but that still seldom makes us into experts. There are some experts on thsi list but most questions are really easy to solve or at least point people in the right direction. I don't think i'm an expert but i've listened a lot. Regards from Tom :) From: Pertti Rönnberg p...@elisanet.fi To: users@global.libreoffice.org Sent: Sunday, 21 October 2012, 9:51 Subject: Re: [libreoffice-users] Suitability of Lo in Small organisations Best all you LibO experts and Devs! What Webmaster now says is a good example on all the basic level issues that must be completely eliminated from LibO. Some posts ago I asked what version of LibO at this moment is to be considered as the most reliable and most stable. And got the answer that LibO3.5.7 is the one for newcomers perhaps followed by LibO3.6.2. (But nothing said about Base, that is my main concern and asked for) For all of you that know LibO's build-up, its features and work-arounds and alternative solutions these issues may seem simple. But for users like me they are serious - I do not even know where to start looking for a solution if I meet such a problem. It is really a matter of using LibO or not -- and I do not want to have different programs/suites for different types of need. My main interest is to get the job done and because of limits in time or costs I cannot accept delays caused by the tool I use. Obviously I have to continue - even if I don't want to - to buy MSO. A lack of resources is not a valid excuse as long as you can continue developing new bugs and issues - plus them 1000-2000 already waiting for fixing. I know very well that it is never fun to afterwards repair mistakes - so better not to make them. Waiting for the results of your wise decisions - especially regarding Windows with some 90% of the users. Pertti Rönnberg On 20.10.2012 23:57, webmaster-Kracked_P_P wrote: The freezing and word count issues - was that on 3.5.6, 3.5.7, or some other version. I have noticed that 3.5.7 freezes sometimes on loading/opening with Ubuntu 64-bit 12.04 and MATE desktop. I never saw this with 3.5.6 and Ubuntu 10.04 and GNOME desktop. Since I upgraded to 12.04 on Oct. 8th and 3.5.7 when it came out on the 18th, I did not have much time with 12.04 and 3.5.6 to tell if there was any issues. The freezing happened several times. Once with clicking on the panel launcher and twice with the right-clicking and open with option. The only way to get the LO splash/opening to unfreeze is to reboot. Actually when Ubuntu reboots, LO opens up properly. I have the system set to open any packages with windows open when I log off or shut-down/re-boot. So I do get the freezing splash screen once and a while for 3.5.7. Is this an issue with other users of 3.5.7? On 10/20/2012 03:10 PM, Anthony Easthope wrote: I haven't yet given them the 3.5.7 release as I have still been away! the bugs where mainly freezing wordcount and thelike On Sat, 20 Oct 2012, at 03:49 PM, Tom Davies wrote: Hi :) +1 Was it something that would have been easily fixed by renaming the User Profile? Regards from Tom :) From: rost52 bugquestcon...@online.de To: users@global.libreoffice.org Sent: Friday, 19 October 2012, 7:17 Subject: Re: [libreoffice-users] Suitability of Lo in Small organisations It would be interesting to learn what version was used, which bugs were observed and if they were all reported an when. On 2012-10-19 10:39, Anthony Easthope wrote: Hi guys I was wondering what would perhaps be the best release of LO to recommend to a small charitable organisation. I had a problem with the latest release as it was quite buggy and the church athletics club I installed it for was not to happy when they found the bugs interrupted their workflow, So what is the most stable release? -- Anthony Easthope antiso...@myopera.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?
Re: [libreoffice-users] Cannot add primary key after saving without primary key.
Hi :) Which back-end are you using to store the data? MySql/MariaDb, Postgresql, Sqlite? Regards from Tom :) From: David Smith sidic...@gmail.com To: users@global.libreoffice.org Sent: Sunday, 21 October 2012, 10:40 Subject: [libreoffice-users] Cannot add primary key after saving without primary key. Software: Libreoffice base Version: 3.5.4.2 (Debian Wheezy) Subject: Cannot add primary key after saving without primary key. I've got a problem. I'm trying to test some different table designs. Whenever I create a table without a primary key, I find that I cannot go back and add a primary key later. When I first save the table, Libreoffice asks me if I want to create a primary key now. I choose no because I'm experimenting with some different table designs and didn't want to commit to anything just yet. 1. Create table without primary key. 2. Save table. 3. Libreoffice asks if I want to create a primary key now. 4. I choose no. 5. I later then open the table and set the primary key. 6. I save the table. 7. I open the table again and the primary key that I chose was not saved! I've never had this kind of problem with a database before. Is this a bug or a missing feature? -- 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] Cannot add primary key after saving without primary key.
I used the Libreoffice wizard to create the database. It's a local file. It's an offline laptop and I don't have MySQL or PostgresSQL running so maybe it's SQLite? What's the process to check the backend? Thanks for your time. On Sun, Oct 21, 2012 at 5:45 PM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Which back-end are you using to store the data? MySql/MariaDb, Postgresql, Sqlite? Regards from Tom :) From: David Smith sidic...@gmail.com To: users@global.libreoffice.org Sent: Sunday, 21 October 2012, 10:40 Subject: [libreoffice-users] Cannot add primary key after saving without primary key. Software: Libreoffice base Version: 3.5.4.2 (Debian Wheezy) Subject: Cannot add primary key after saving without primary key. I've got a problem. I'm trying to test some different table designs. Whenever I create a table without a primary key, I find that I cannot go back and add a primary key later. When I first save the table, Libreoffice asks me if I want to create a primary key now. I choose no because I'm experimenting with some different table designs and didn't want to commit to anything just yet. 1. Create table without primary key. 2. Save table. 3. Libreoffice asks if I want to create a primary key now. 4. I choose no. 5. I later then open the table and set the primary key. 6. I save the table. 7. I open the table again and the primary key that I chose was not saved! I've never had this kind of problem with a database before. Is this a bug or a missing feature? -- 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
[libreoffice-users] image anchoring
Hello, for a long time, i have been looking for a way to set image anchoring to 'as text' as the default preset, instead of 'to paragraph'. Since i have'nt found any clue to do so (maybe i did not search enough), i am finally writing this email. Does anybody know a way to go, i.e. setting the default anchoring to 'as text' after an image insertion ? thanks, -- 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] Cannot add primary key after saving without primary key.
I used the Libreoffice wizard to create the database. It's a local file. It's an offline laptop and I don't have MySQL or PostgresSQL running so maybe it's SQLite? What's the process to check the backend? Ok, Database File is an .odb. Open Document Database. Thanks for your time. -- 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] Cannot add primary key after saving without primary key.
Hi :) Thanks :) So the data itself is stored inside the Base file. There is only 1 file. Base is not just the front-end connecting you to an external back-end with the data in it. Like it would be if using MS Access instead of LO Base. It's the way i would have approached Base before reading a lot of the comments on this list that suggest having the data in a separate back-end is much, much better. At the moment i am a bit perplexed about how to use Base but it 'should' be possible to just add an exra field,especially a primary key! I'm just not sure how to do so. I tried looking it up in the Faq http://wiki.documentfoundation.org/Faq/Base/009 but that didn't seem aprticularly helpful! The main page of the Faq is here http://wiki.documentfoundation.org/Faq#Base There is an introduction to Base in the Getting Started Guide http://wiki.documentfoundation.org/Documentation/Publications but only the 1st chapter is done for the main guide http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide Hopefully one of the database experts will be able to help you soon. Apols and regards from Tom :) From: David Smith sidic...@gmail.com To: Tom Davies tomdavie...@yahoo.co.uk Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Sunday, 21 October 2012, 12:16 Subject: Re: [libreoffice-users] Cannot add primary key after saving without primary key. I used the Libreoffice wizard to create the database. It's a local file. It's an offline laptop and I don't have MySQL or PostgresSQL running so maybe it's SQLite? What's the process to check the backend? Ok, Database File is an .odb. Open Document Database. Thanks for your time. -- 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: Insert the filename in a cell
Hi :) The help pages are very out-of-date. It's a good 1st place to search for stuff but the proper guides are far better http://wiki.documentfoundation.org/Documentation/Publications Regards from Tom :) From: Luuk luu...@gmail.com To: users@global.libreoffice.org Sent: Saturday, 20 October 2012, 12:07 Subject: [libreoffice-users] Re: Insert the filename in a cell On 19-10-2012 16:23, Samuele Zampini wrote: I solved it with this formula: =REPLACE(REPLACE(CELL(filename);FIND(.;CELL(filename);1);(LEN(CELL(filename))-FIND(.;CELL(filename);1)+1););1;SEARCH(/[^/]*$; CELL(filename));) I like it! its a bit too long i would like CELL(shortfilename) more CELL(Filename) should return just the name (without path) and CELL(path) to return the path but that is obviously not possible because Microsoft 'invented' it the other way ;( and why is there no mentioning in the help page that we can use a regular expression to search with SEARCH()...? -- 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] image anchoring
On 10/21/2012 06:54 AM, Alexandre FRIEDMANN wrote: Hello, for a long time, i have been looking for a way to set image anchoring to 'as text' as the default preset, instead of 'to paragraph'. Since i have'nt found any clue to do so (maybe i did not search enough), i am finally writing this email. Does anybody know a way to go, i.e. setting the default anchoring to 'as text' after an image insertion ? thanks, The default setting for anchoring an image is to paragraph. What you want to use is as character. --Dan -- 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] Suitability of Lo in Small organisations
Personal opinion: LibO version 3.5.7 for Base. What do you know about how Base works? What is your background in the topic of relational databases? Each database program has its own method of creating and working with its databases. What are you going to use as a resource for learning to use Base? Knowing which version is the most reliable and stable is very important. Perhaps knowing where to find the resources to use makes the program much more useful. --Dan On 10/21/2012 04:51 AM, Pertti Rönnberg wrote: Best all you LibO experts and Devs! What Webmaster now says is a good example on all the basic level issues that must be completely eliminated from LibO. Some posts ago I asked what version of LibO at this moment is to be considered as the most reliable and most stable. And got the answer that LibO3.5.7 is the one for newcomers perhaps followed by LibO3.6.2. (But nothing said about Base, that is my main concern and asked for) For all of you that know LibO's build-up, its features and work-arounds and alternative solutions these issues may seem simple. But for users like me they are serious - I do not even know where to start looking for a solution if I meet such a problem. It is really a matter of using LibO or not -- and I do not want to have different programs/suites for different types of need. My main interest is to get the job done and because of limits in time or costs I cannot accept delays caused by the tool I use. Obviously I have to continue - even if I don't want to - to buy MSO. A lack of resources is not a valid excuse as long as you can continue developing new bugs and issues - plus them 1000-2000 already waiting for fixing. I know very well that it is never fun to afterwards repair mistakes - so better not to make them. Waiting for the results of your wise decisions - especially regarding Windows with some 90% of the users. Pertti Rönnberg On 20.10.2012 23:57, webmaster-Kracked_P_P wrote: The freezing and word count issues - was that on 3.5.6, 3.5.7, or some other version. I have noticed that 3.5.7 freezes sometimes on loading/opening with Ubuntu 64-bit 12.04 and MATE desktop. I never saw this with 3.5.6 and Ubuntu 10.04 and GNOME desktop. Since I upgraded to 12.04 on Oct. 8th and 3.5.7 when it came out on the 18th, I did not have much time with 12.04 and 3.5.6 to tell if there was any issues. The freezing happened several times. Once with clicking on the panel launcher and twice with the right-clicking and open with option. The only way to get the LO splash/opening to unfreeze is to reboot. Actually when Ubuntu reboots, LO opens up properly. I have the system set to open any packages with windows open when I log off or shut-down/re-boot. So I do get the freezing splash screen once and a while for 3.5.7. Is this an issue with other users of 3.5.7? On 10/20/2012 03:10 PM, Anthony Easthope wrote: I haven't yet given them the 3.5.7 release as I have still been away! the bugs where mainly freezing wordcount and thelike On Sat, 20 Oct 2012, at 03:49 PM, Tom Davies wrote: Hi :) +1 Was it something that would have been easily fixed by renaming the User Profile? Regards from Tom :) From: rost52 bugquestcon...@online.de To: users@global.libreoffice.org Sent: Friday, 19 October 2012, 7:17 Subject: Re: [libreoffice-users] Suitability of Lo in Small organisations It would be interesting to learn what version was used, which bugs were observed and if they were all reported an when. On 2012-10-19 10:39, Anthony Easthope wrote: Hi guys I was wondering what would perhaps be the best release of LO to recommend to a small charitable organisation. I had a problem with the latest release as it was quite buggy and the church athletics club I installed it for was not to happy when they found the bugs interrupted their workflow, So what is the most stable release? -- Anthony Easthope antiso...@myopera.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] North American DVD 3.5.6
I do not have any software to create a checksum. But, it is downloaded from the LO servers, so they have them for you. On the green button for the downloading of the ISO files, there is an Info text. You click on that text and you should get a page showing mirrors for the files and their checksums. I would not download the 3.5.6 version. IT has a bug in the download page that involves the Windows files. I did not upload the modified version, since it was too close to the 3.5.7 release and having the 3.5.6 version uploaded [take 9-10 hours on my part to upload a full DVD ISO file] and then in a week or so the 3.5.7 DVD will be listed as the current version. It seemed not doable to just upload the 3.5.6 version fix when 3.5.7 was so close. Actually I just found the bug about a week ago, a few days before 3.5.7 was released to the public. As soon as I downloaded all of the 90+ 3.5.7 needed install files , I created the 3.5.7 DVD ISO file and uploaded it to the holding server to wait till the conference was over so the person would have it available to do the move to the download server[s]. Then it was up to the mirrors to get the new folder[s]/file[s] sync-ed up and then the new ISO file will be available to the public for downloading. In a few days the 3.5.7 DVD will be on the LO servers. With the conference going on, the person who moves the ISO file to the proper server and folder was not available to do the move. But it will happen in a few days, hopefully. The exact date is not known. http://www.libreoffice.org/download/?type=boxversion=3.5.7 This should be the direct link to the 3.5.7 DVD download page. AS FOR downloading the Windows version for your wife's computer, just use LO's download page. It will be quicker. If you want to install the 3.5.6 version, you will find it here http://www.libreoffice.org/download-more/ or here http://downloadarchive.documentfoundation.org/libreoffice/old/3.5.6.2/ http://www.libreoffice.org/download-more/ On 10/21/2012 03:35 AM, Tom Davies wrote: Hi :) Don't worry about checking it. The best way to know is to burn the dvd and then see if it works :( The NA team doesn't know how to generate the checksums. They keep asking how to generate them but no-one helps them. I don't know either, just in case you wondered. If you could point them to some documentation or help them learn how to generate md5sums or Sha or whatever then that would be a huge help. Apols and regards from Tom :) From: Russ Fineman upsc...@nwi.net To: users@global.libreoffice.org Sent: Sunday, 21 October 2012, 2:18 Subject: [libreoffice-users] North American DVD 3.5.6 I just downloaded the DVD mentioned in the Subject. I want to verify the download is good but have not found a location on the North American website to get the checksums. K3B says there is an MD5 checksum of: 96560a0b6c117a07d32d33baa1e2ef30 Is this correct? Shouldn't the checksums be available on the website. i already use LibreOffice on My Linux base system. See Signature. I now want to put it on my wife's Win 7 system. Thanks. Russ -- openSUSE 12.2(Linux 3.4.11-2.16-desktop x86_64)| KDE 4.9.2 release 511|Intel core2duo 2.5 MHZ,|8GB DDR3|GeForce 8400GS(NVIDIA-Linux-x86_64-304.51) -- 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] Suitability of Lo in Small organisations
On 10/21/2012 04:51 AM, Pertti Rönnberg wrote: Best all you LibO experts and Devs! What Webmaster now says is a good example on all the basic level issues that must be completely eliminated from LibO. I did not state that. Where did you get must be completely eliminated from LibO? Some posts ago I asked what version of LibO at this moment is to be considered as the most reliable and most stable. And got the answer that LibO3.5.7 is the one for newcomers perhaps followed by LibO3.6.2. (But nothing said about Base, that is my main concern and asked for) There are Base users out there, but I am not one of them so I could not answer your question about Base. For all of you that know LibO's build-up, its features and work-arounds and alternative solutions these issues may seem simple. But for users like me they are serious - I do not even know where to start looking for a solution if I meet such a problem. It is really a matter of using LibO or not -- and I do not want to have different programs/suites for different types of need. My main interest is to get the job done and because of limits in time or costs I cannot accept delays caused by the tool I use. Obviously I have to continue - even if I don't want to - to buy MSO. I am a serious user, and I get my answers from here. Just because people do not use Base does not mean they are not serious users of LibreOffice. We really need a list for only Base question, but until then you must wait for the Base users to read your posting and give you an answer. A lack of resources is not a valid excuse as long as you can continue developing new bugs and issues - plus them 1000-2000 already waiting for fixing. Where did you get the figure of 1000-2000 bugs waiting on being fixed? I did not see that listed anywhere on the bug reporting pages. I know very well that it is never fun to afterwards repair mistakes - so better not to make them. Waiting for the results of your wise decisions - especially regarding Windows with some 90% of the users. Pertti Rönnberg On 20.10.2012 23:57, webmaster-Kracked_P_P wrote: The freezing and word count issues - was that on 3.5.6, 3.5.7, or some other version. I have noticed that 3.5.7 freezes sometimes on loading/opening with Ubuntu 64-bit 12.04 and MATE desktop. I never saw this with 3.5.6 and Ubuntu 10.04 and GNOME desktop. Since I upgraded to 12.04 on Oct. 8th and 3.5.7 when it came out on the 18th, I did not have much time with 12.04 and 3.5.6 to tell if there was any issues. The freezing happened several times. Once with clicking on the panel launcher and twice with the right-clicking and open with option. The only way to get the LO splash/opening to unfreeze is to reboot. Actually when Ubuntu reboots, LO opens up properly. I have the system set to open any packages with windows open when I log off or shut-down/re-boot. So I do get the freezing splash screen once and a while for 3.5.7. Is this an issue with other users of 3.5.7? On 10/20/2012 03:10 PM, Anthony Easthope wrote: I haven't yet given them the 3.5.7 release as I have still been away! the bugs where mainly freezing wordcount and thelike On Sat, 20 Oct 2012, at 03:49 PM, Tom Davies wrote: Hi :) +1 Was it something that would have been easily fixed by renaming the User Profile? Regards from Tom :) From: rost52 bugquestcon...@online.de To: users@global.libreoffice.org Sent: Friday, 19 October 2012, 7:17 Subject: Re: [libreoffice-users] Suitability of Lo in Small organisations It would be interesting to learn what version was used, which bugs were observed and if they were all reported an when. On 2012-10-19 10:39, Anthony Easthope wrote: Hi guys I was wondering what would perhaps be the best release of LO to recommend to a small charitable organisation. I had a problem with the latest release as it was quite buggy and the church athletics club I installed it for was not to happy when they found the bugs interrupted their workflow, So what is the most stable release? -- Anthony Easthope antiso...@myopera.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 -- 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:
Re: [libreoffice-users] North American DVD 3.5.6
webmaster-Kracked_P_P wrote: I do not have any software to create a checksum. But, it is downloaded from the LO servers, so they have them for you. On the green button for the downloading of the ISO files, there is an Info text. You click on that text and you should get a page showing mirrors for the files and their checksums. Where are you seeing that Info text? I certainly don't see it. As for checksum, the usual one to use is called md5sum. The utility for that comes with Linux and is also available for download for Windows. Disc burner software will also check md5sum. You should always have md5sum available for downloads, not just CD/DVD images. I have often downloaded multiple files from a site and there will usually be a file called md5sum, which contains md5sum for all the relevant files. I can then download that to the same directory as the other files. Then, in a command prompt, I enter the command md5sum -c md5sum, which then runs md5sum on all the files listed in that md5sum file and displays the results as to valid, bad or missing. However, even just displaying the md5sum on the web page makes it easy to verify a good download, by comparing the locally generated md5sum with what's displayed on the web site. -- 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] Suitability of Lo in Small organisations
The freezing may have to do with MATE desktop environment on a Ubuntu 12.04 system that has Unity, KDE, and MATE installed. If the freezing is due to that, or dealing with some specific system setup that the developers are not using, then they would not know if it is my system or some issue that only happens for a few users. There are so many combinations of OSs and desktop environments for Linux and the developers would need 20, 50, or even 100 systems [not virtual] to test LO against. That is not doable for most people who do not have the money to buy, let alone have space, to set up all the different combinations of system setups. For LO, there are no experts. We all have knowledge on what works for us and what does not. I know how to create a dictionary extension, and a few other things. I am not an expert in that field, but I know how to do certain things, since I have done them. I have used Ubuntu Linux as my default OS on my desktop since Feb 2010, BUT I do not know much in the way of doing thing in the Terminal Command Line system. I just do not use it much. So I need help from others, or from online help systems to find the best way to do things with the Terminal system. Actually I rarely use it more than installing LO or installing other things that are not part of the Ubuntu Software Center, like MATE desktop environment. On 10/21/2012 05:41 AM, Tom Davies wrote: Hi :) I've not had any freezing on Win Xp, Win7 or Ubuntu but that was all with 3.5.4. The 3.5.7 should be about the same but just a bit more stable. It's only bug-fixes and such added on so nothing new added and so no new surprises. If something straight-forwards doesn't work the 1st thing i do is poke around and see if i can find another way. If not i try a bunch of stuff at roughly the same time; ask colleagues how they would do it, open up a guide or 2, consider if some other program might be better for the task or if the task needs doing at all. If still stuck then i would; rename user-profile, dig around the lists, post a new question to the list, even start reading the documentation i had opened. Just because people are on this list doesn't mean they are experts. I guess some people do learn a lot by listening but that still seldom makes us into experts. There are some experts on thsi list but most questions are really easy to solve or at least point people in the right direction. I don't think i'm an expert but i've listened a lot. Regards from Tom :) From: Pertti Rönnberg p...@elisanet.fi To: users@global.libreoffice.org Sent: Sunday, 21 October 2012, 9:51 Subject: Re: [libreoffice-users] Suitability of Lo in Small organisations Best all you LibO experts and Devs! What Webmaster now says is a good example on all the basic level issues that must be completely eliminated from LibO. Some posts ago I asked what version of LibO at this moment is to be considered as the most reliable and most stable. And got the answer that LibO3.5.7 is the one for newcomers perhaps followed by LibO3.6.2. (But nothing said about Base, that is my main concern and asked for) For all of you that know LibO's build-up, its features and work-arounds and alternative solutions these issues may seem simple. But for users like me they are serious - I do not even know where to start looking for a solution if I meet such a problem. It is really a matter of using LibO or not -- and I do not want to have different programs/suites for different types of need. My main interest is to get the job done and because of limits in time or costs I cannot accept delays caused by the tool I use. Obviously I have to continue - even if I don't want to - to buy MSO. A lack of resources is not a valid excuse as long as you can continue developing new bugs and issues - plus them 1000-2000 already waiting for fixing. I know very well that it is never fun to afterwards repair mistakes - so better not to make them. Waiting for the results of your wise decisions - especially regarding Windows with some 90% of the users. Pertti Rönnberg On 20.10.2012 23:57, webmaster-Kracked_P_P wrote: The freezing and word count issues - was that on 3.5.6, 3.5.7, or some other version. I have noticed that 3.5.7 freezes sometimes on loading/opening with Ubuntu 64-bit 12.04 and MATE desktop. I never saw this with 3.5.6 and Ubuntu 10.04 and GNOME desktop. Since I upgraded to 12.04 on Oct. 8th and 3.5.7 when it came out on the 18th, I did not have much time with 12.04 and 3.5.6 to tell if there was any issues. The freezing happened several times. Once with clicking on the panel launcher and twice with the right-clicking and open with option. The only way to get the LO splash/opening to unfreeze is to reboot. Actually when Ubuntu reboots, LO opens up properly. I have the system set to open any packages with windows open when I log off or shut-down/re-boot. So I do get the
Re: [libreoffice-users] image anchoring
On 10/21/2012 09:14 AM, Dan Lewis wrote: On 10/21/2012 06:54 AM, Alexandre FRIEDMANN wrote: Hello, for a long time, i have been looking for a way to set image anchoring to 'as text' as the default preset, instead of 'to paragraph'. Since i have'nt found any clue to do so (maybe i did not search enough), i am finally writing this email. Does anybody know a way to go, i.e. setting the default anchoring to 'as text' after an image insertion ? thanks, The default setting for anchoring an image is to paragraph. What you want to use is as character. --Dan What is the difference between TO Character and AS Character? I tend to make images anchor to the Page, forthe most part. IF you want the image to go with a specific paragraph or line of textas you add text before that section of a large[er] document, then I do not know which is best. To Paragraph, To Character, As Character. I wonder how you actually determine which Character you are anchoring the image to. -- 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] North American DVD 3.5.6
Hi :) That does sound hugely useful but please could you let us know the name of the utility you used? If it was for a particular DE i'm sure we could work out the name for another DE if we need to. Just knowing the name of 1 would help! Also any suggestions on how to use the utility? If it's command-line only i think it's still possible even for us pointclick users but we could use a little guidance. Errr, i'm still not in the NA Dvd team but am still interested in how to generate an Md5sum. Many thanks and regards from Tom :) From: James Knott james.kn...@rogers.com To: LibreOffice users@global.libreoffice.org Sent: Sunday, 21 October 2012, 15:35 Subject: Re: [libreoffice-users] North American DVD 3.5.6 webmaster-Kracked_P_P wrote: I do not have any software to create a checksum. But, it is downloaded from the LO servers, so they have them for you. On the green button for the downloading of the ISO files, there is an Info text. You click on that text and you should get a page showing mirrors for the files and their checksums. Where are you seeing that Info text? I certainly don't see it. As for checksum, the usual one to use is called md5sum. The utility for that comes with Linux and is also available for download for Windows. Disc burner software will also check md5sum. You should always have md5sum available for downloads, not just CD/DVD images. I have often downloaded multiple files from a site and there will usually be a file called md5sum, which contains md5sum for all the relevant files. I can then download that to the same directory as the other files. Then, in a command prompt, I enter the command md5sum -c md5sum, which then runs md5sum on all the files listed in that md5sum file and displays the results as to valid, bad or missing. However, even just displaying the md5sum on the web page makes it easy to verify a good download, by comparing the locally generated md5sum with what's displayed on the web site. -- 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] image anchoring
Hi :) Right-click on the image. On the right-click menu hover over Anchor to and from the sub-menu choose either As Character or To Character If you don't like the way it woks try the other option. Chapter 11 of the Gettign Started Guide might be more helpful http://wiki.documentfoundation.org/Documentation/Publications I don't know what the difference is between the 2 options so i'm hoping the guide covers it! Apols and regards from Tom :) From: webmaster-Kracked_P_P webmas...@krackedpress.com To: users@global.libreoffice.org Sent: Sunday, 21 October 2012, 15:49 Subject: Re: [libreoffice-users] image anchoring On 10/21/2012 09:14 AM, Dan Lewis wrote: On 10/21/2012 06:54 AM, Alexandre FRIEDMANN wrote: Hello, for a long time, i have been looking for a way to set image anchoring to 'as text' as the default preset, instead of 'to paragraph'. Since i have'nt found any clue to do so (maybe i did not search enough), i am finally writing this email. Does anybody know a way to go, i.e. setting the default anchoring to 'as text' after an image insertion ? thanks, The default setting for anchoring an image is to paragraph. What you want to use is as character. --Dan What is the difference between TO Character and AS Character? I tend to make images anchor to the Page, forthe most part. IF you want the image to go with a specific paragraph or line of textas you add text before that section of a large[er] document, then I do not know which is best. To Paragraph, To Character, As Character. I wonder how you actually determine which Character you are anchoring the image to. -- 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] image anchoring
Le 21/10/2012 17:03, Tom Davies a écrit : Hi :) Right-click on the image. On the right-click menu hover over Anchor to and from the sub-menu choose either As Character or To Character I guess the OP wants this as the default behaviour. As there's no image style, this path is not possible. A workaround could be to insert images within frames. Setting the frame style accordingly then saving the document as a template, then setting that template as the default one could do the trick. Use the File / Templates menu to get the template thingy done. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] image anchoring
On 21/10/2012 at 17:13, Jean-Francois Nifenecker jean- francois.nifenec...@laposte.net wrote: As there's no image style, this path is not possible. There are image styles. They are called Frame styles and you will find them under third icon from left in Styles and formatting window. As far as I remember, MS Word doesn't have them. But for some strange reason you can't change anchoring in style properties. -- Best regards Mirosław Zalewski -- 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] North American DVD 3.5.6
Tom Davies wrote: Hi :) That does sound hugely useful but please could you let us know the name of the utility you used? If it was for a particular DE i'm sure we could work out the name for another DE if we need to. Just knowing the name of 1 would help! Also any suggestions on how to use the utility? If it's command-line only i think it's still possible even for us pointclick users but we could use a little guidance. Errr, i'm still not in the NA Dvd team but am still interested in how to generate an Md5sum. Many thanks and regards from Tom :) In Linux, it's called md5sum. As for Windows, Google on Windows md5sum to find utilities you can download. Here's a list of the directory where I downloaded openSUSE: jknott@linux:~/download/suse/12_2 $ ls -l total 8903692 -rw-r--r-- 1 jknott users126 Sep 16 14:41 md5sum -rw-r--r-- 1 jknott users 4448059392 Sep 16 14:24 openSUSE-12.2-DVD-i586.iso -rw-r--r-- 1 jknott users 4669308928 Sep 16 14:22 openSUSE-12.2-DVD-x86_64.iso The md5sum file contains: 26dd6c187f743f3af0cbb31eed138a07 openSUSE-12.2-DVD-x86_64.iso 0373980cd6f270e1172067b86c044633 openSUSE-12.2-DVD-i586.iso If I run the command md5sum -c md5sum, I get: openSUSE-12.2-DVD-x86_64.iso: OK openSUSE-12.2-DVD-i586.iso: OK This shows both files match their md5sum. If I run the command md5sum openSUSE-12.2-DVD-x86_64.iso, I get: 26dd6c187f743f3af0cbb31eed138a07 openSUSE-12.2-DVD-x86_64.iso This matches the value from the web site, and shows the file is OK. The thing about md5sums is that a small change in the file results in a large change in the file's md5sum. This means that you don't have to check every character. If a few at each end are correct, then in all probability the file is OK. As I mentioned, disc burner software will generally display the md5sum of a file before you burn the disc. Just check that against the md5sum from the web site. There may be graphical utilities available, but I haven't had the need to use them as the command line utility is so easy to use. -- 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] image anchoring
On 21/10/2012 at 16:49, webmaster-Kracked_P_P webmas...@krackedpress.com wrote: What is the difference between TO Character and AS Character? Why don't you just open Writer and check it yourself? Anchoring image to character gives you ability to position image relative to page, text area or paragraph, both vertical and horizontal. Anchoring image as character makes image behave as it was character. You can't move it horizontally and in vertical space you can move it in relation to imaginary text lines (see this Wikipedia article for details: http://en.wikipedia.org/wiki/Baseline_(typography) ). Unless your image is the same height as text-size of your paragraph (or smaller), anchoring it as character will produce unsightly results. -- Best regards Mirosław Zalewski -- 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] Libre Writer - Opening plain text documents to desired font
Hi Brian, Yes, you got it. My goal is to open (not paste in) saved plain text files in a blank, newly opened Libre Write document. I've visited Preformatted Style and change the style to Bookman Old 12 point, clicked Apply and then saved it (or so I thought) only for it to always default back to Courier New 10 point when I open any plain text file. I've created a Default font with Bookman Old 12 point but Libre Write automatically opens all *saved* plain text files to Preformatted Style not Default. I just wondered if there was any way to change which style Libre Writer will open *saved* plain text files automatically to since Libre Writer does not seems to save changes to the Prefromatted Style? Oddly enough if you click Format Styles the drop down list of autonomic styles Preoformated is *not* listed. You must list all styles to find it. Following webmaster-Kracked's inspiration, I saved a document as Text Encoded but whne I re-opened the file it still opens all documents saved as Text Encoded and/or Plain Text in the Performatted Style. The key seems to be induing Libre Writer to open Text Encoded and/or Plain Text files to either Default (where I have it set to Bookman Old 12 point) or another style which does not require Courier New 10 point. Has anyone on the list successful changed the style Text Encoded or Plain Text files open to? Thanks so much, Charles. Subject:Re: [libreoffice-users] Libre Writer - Opening plain text documents to desired font From:Brian Barker b.m.bar...@btinternet.com Date:Sat, 20 Oct 2012 04:21:49 +0100 To:users@global.libreoffice.org snip There are two issues here, I think. In order to change the Preformatted Text paragraph style you have to have a document open - and the change is made to the style in that document, not in your installation of LibreOffice. So your change is ignored when you open the new document from your plain text file. The way around that might seem to be to create a template containing your modified Preformatted Text paragraph style and then to set that as the default template. You can certainly do that. Now you would probably expect in this case that when you open your plain text file the new text (Writer) document would be created from your new modified default template, but - perhaps perversely - it appears to be opened using the original default default template, ignoring your desired change. I trust this helps (though I doubt it does). Brian Barker -- 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] North American DVD 3.5.6
Hi :) Wow!! Thanks :) That sounds reasonably easy and do-able. I have to pop out but hopefully Tim can let us know how it's gone if he gets time to try it out. many thanks and regards from Tom :) From: James Knott james.kn...@rogers.com To: LibreOffice users@global.libreoffice.org Sent: Sunday, 21 October 2012, 16:23 Subject: Re: [libreoffice-users] North American DVD 3.5.6 Tom Davies wrote: Hi :) That does sound hugely useful but please could you let us know the name of the utility you used? If it was for a particular DE i'm sure we could work out the name for another DE if we need to. Just knowing the name of 1 would help! Also any suggestions on how to use the utility? If it's command-line only i think it's still possible even for us pointclick users but we could use a little guidance. Errr, i'm still not in the NA Dvd team but am still interested in how to generate an Md5sum. Many thanks and regards from Tom :) In Linux, it's called md5sum. As for Windows, Google on Windows md5sum to find utilities you can download. Here's a list of the directory where I downloaded openSUSE: jknott@linux:~/download/suse/12_2 $ ls -l total 8903692 -rw-r--r-- 1 jknott users 126 Sep 16 14:41 md5sum -rw-r--r-- 1 jknott users 4448059392 Sep 16 14:24 openSUSE-12.2-DVD-i586.iso -rw-r--r-- 1 jknott users 4669308928 Sep 16 14:22 openSUSE-12.2-DVD-x86_64.iso The md5sum file contains: 26dd6c187f743f3af0cbb31eed138a07 openSUSE-12.2-DVD-x86_64.iso 0373980cd6f270e1172067b86c044633 openSUSE-12.2-DVD-i586.iso If I run the command md5sum -c md5sum, I get: openSUSE-12.2-DVD-x86_64.iso: OK openSUSE-12.2-DVD-i586.iso: OK This shows both files match their md5sum. If I run the command md5sum openSUSE-12.2-DVD-x86_64.iso, I get: 26dd6c187f743f3af0cbb31eed138a07 openSUSE-12.2-DVD-x86_64.iso This matches the value from the web site, and shows the file is OK. The thing about md5sums is that a small change in the file results in a large change in the file's md5sum. This means that you don't have to check every character. If a few at each end are correct, then in all probability the file is OK. As I mentioned, disc burner software will generally display the md5sum of a file before you burn the disc. Just check that against the md5sum from the web site. There may be graphical utilities available, but I haven't had the need to use them as the command line utility is so easy to use. -- 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] image anchoring
On 10/21/2012 11:23 AM, Mirosław Zalewski wrote: On 21/10/2012 at 16:49, webmaster-Kracked_P_P webmas...@krackedpress.com wrote: What is the difference between TO Character and AS Character? Why don't you just open Writer and check it yourself? Anchoring image to character gives you ability to position image relative to page, text area or paragraph, both vertical and horizontal. Anchoring image as character makes image behave as it was character. You can't move it horizontally and in vertical space you can move it in relation to imaginary text lines (see this Wikipedia article for details: http://en.wikipedia.org/wiki/Baseline_(typography) ). Unless your image is the same height as text-size of your paragraph (or smaller), anchoring it as character will produce unsightly results. There are more things than involved that would not show up in a small test I could do. ALSO I would rather have someone who knows the difference explain it to me and the list. That person might have info on how it is effected by adding large amount of text and images in the document before that specific anchored image, and how different formatting schemes, like 2 columns or text boxes, like in magazines and newsletter, effect the movement of the image with the anchor. -- 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] North American DVD 3.5.6
webmaster-Kracked_P_P wrote: NO ONE has given me the answer before on how to create a md5sum file before. And I asked that question back in the 3.3.x version days. I have printed your answer out to PDF and I will place it on my folder[s] for the NA-DVD work. I use Ubuntu 12.04/MATE [10.04/GNOME before this month] to create the NA-DVD web site and the ISO file. I use Kompozer and Kate for most of the HTML work. I use K3b to create the ISO file I use Filezilla as my FTP client. K3b creates a checksum but I do not know where it is stored for my use. You can store it in a file md5sum with the command md5sum [filename] md5sum. As I mentioned, it can be used for any file, not just ISOs. If you're saving the md5sum for multiple files, use the above command for the 1st and then md5sum [filename] md5sum which concatenates the additional md5sums onto the existing file, rather than create a new file. -- 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] image anchoring
Hi :) There have been other useful responses. I just wanted to say i find Anchor to page more useful and then if the paragraph moves or changes page then i just deal with it then. I don't want images to jump around the page while i'm typign soemthing in or shifting text around. I just need an idea of roughly how much space they are going to take up. Finalising positions is one of the last jobs i tend to do. Obviously each of us prefers different work-flow and usually for good reasons that wouldn't suit someone else. The trick is to find a way that suits you best given the tools you use. Regards from Tom :) From: webmaster-Kracked_P_P webmas...@krackedpress.com To: users@global.libreoffice.org Sent: Sunday, 21 October 2012, 16:39 Subject: Re: [libreoffice-users] image anchoring On 10/21/2012 11:23 AM, Mirosław Zalewski wrote: On 21/10/2012 at 16:49, webmaster-Kracked_P_P webmas...@krackedpress.com wrote: What is the difference between TO Character and AS Character? Why don't you just open Writer and check it yourself? Anchoring image to character gives you ability to position image relative to page, text area or paragraph, both vertical and horizontal. Anchoring image as character makes image behave as it was character. You can't move it horizontally and in vertical space you can move it in relation to imaginary text lines (see this Wikipedia article for details: http://en.wikipedia.org/wiki/Baseline_(typography) ). Unless your image is the same height as text-size of your paragraph (or smaller), anchoring it as character will produce unsightly results. There are more things than involved that would not show up in a small test I could do. ALSO I would rather have someone who knows the difference explain it to me and the list. That person might have info on how it is effected by adding large amount of text and images in the document before that specific anchored image, and how different formatting schemes, like 2 columns or text boxes, like in magazines and newsletter, effect the movement of the image with the anchor. -- 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] North American DVD 3.5.6
On 21/10/2012 at 17:23, James Knott james.kn...@rogers.com wrote: As for Windows, Google on Windows md5sum to find utilities you can download. Recently I saw some article about HashTab. Being Linux user myself, I have not tried it. But it looks quite nice. Unfortunately, it is not open source program and they provide commercial license. I don't know if Kracked Press webmaster's scenario would require such license or not. Anyway, you can download this app from http://www.implbits.com/HashTab.aspx. -- Best regards Mirosław Zalewski -- 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] North American DVD 3.5.6
Hi :) I think Tim uses a dual-boot on his main machine so the linux option is fine. Errr, did someone say they managed to generate an Md5 of the iso on the website and compared it to one generated from their download? If so does that mean the one they generated could just be written onto the website? Sorry, i am being really slow on the uptake here! Presumably it would be good if Tim could generate one based on the version he has on his machine and check that it matches the one built for the website? Would that be a good way of confirming that whatever is on the website is completely correct? Thanks and regards from Tom :) From: Mirosław Zalewski mini...@poczta.onet.pl To: users@global.libreoffice.org Sent: Sunday, 21 October 2012, 16:49 Subject: Re: [libreoffice-users] North American DVD 3.5.6 On 21/10/2012 at 17:23, James Knott james.kn...@rogers.com wrote: As for Windows, Google on Windows md5sum to find utilities you can download. Recently I saw some article about HashTab. Being Linux user myself, I have not tried it. But it looks quite nice. Unfortunately, it is not open source program and they provide commercial license. I don't know if Kracked Press webmaster's scenario would require such license or not. Anyway, you can download this app from http://www.implbits.com/HashTab.aspx. -- Best regards Mirosław Zalewski -- 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] North American DVD 3.5.6
Tom Davies wrote: I think Tim uses a dual-boot on his main machine so the linux option is fine. Errr, did someone say they managed to generate an Md5 of the iso on the website and compared it to one generated from their download? If so does that mean the one they generated could just be written onto the website? Sorry, i am being really slow on the uptake here! You'd get the md5sum from the web site and compare with the downloaded file md5sum. The only one writing to the web site should be the one who placed the files there. Please note that md5sum verifies only the integrity of the downloaded file. If it came from a web site after it had been tampered with and the md5sum recreated, then you could still get something nasty. So, it's best to check against the original source md5sum. There may be authorized mirrors of the original site that can also be trusted. -- 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] Libre Writer - Opening plain text documents to desired font
At 11:25 21/10/2012 -0400, Charles Meyer wrote: Yes, you got it. My goal is to open (not paste in) saved plain text files in a blank, newly opened Libre Write document. I've visited Preformatted Style and change the style to Bookman Old 12 point, clicked Apply and then saved it (or so I thought) only for it to always default back to Courier New 10 point when I open any plain text file. I've created a Default font with Bookman Old 12 point but Libre Write automatically opens all *saved* plain text files to Preformatted Style not Default. I just wondered if there was any way to change which style Libre Writer will open *saved* plain text files automatically to since Libre Writer does not seems to save changes to the Preformatted Style? Writer will save changes to paragraph styles, but only in the current document. If you save your document in Writer's native .odt format and reopen it, you will see that any modifications to styles have been preserved. The point that you are perhaps missing is that saving as plain text is very much an export option, not a way of saving a word processor document. (Think of it like creating a PDF version of your document - which function Writer helpfully includes as Export in the File menu, not as a Save As... option.) As already mentioned by others, style changes cannot be saved in a plain text file - which is just that: the plain and unvarnished text. So when you reopen such a file, you are creating a fresh document as far as Writer is concerned and any changes you made to its now-discarded alter ego are irrelevant. If you need to save a document and later to re-edit it, plain text is useless. As always, the best way to proceed is to save your documents in Writer's native format. If there is any need for a plain text version of your document, first save your most recent changes to the .odt file (for future use) and then save the plain text version separately. The key seems to be inducing Libre Writer to open Text Encoded and/or Plain Text files to either Default (where I have it set to Bookman Old 12 point) or another style which does not require Courier New 10 point. I don't see any way to do this. If you follow the scheme above, you will need to apply the style or font you prefer only once for each such document - which is hardly a penance. After that, the .odt version you are working with will preserve its appearance faithfully. Has anyone on the list successful changed the style Text Encoded or Plain Text files open to? I wish you luck. But - as I say - the expected method of modifying the Preformatted Text paragraph style in a new template and then setting that as the default template does not work. When opening plain text files into new documents, Writer uses the default default template (Text Document), not your newly defined default template, and relies on the unmodified style in that template. This is unexpected (by me, at least) but true! Brian Barker -- 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] Brazilian LibreOffice Magazine released
Dear Community, With proud the Brazilian LibreOffice Community released the first edition of LibreOffice Magazine in portuguese during the event Latinoware 2012. The Magazine is available on wiki in two formats: pdf and odg. * PDF: http://wiki.documentfoundation.org/images/9/98/LibreOffice_Magazine_01.pdf * ODG: http://wiki.documentfoundation.org/images/c/cf/LM-ED01.odg The Magazine was prepared in LibreOffice Draw. It was one of the surprises in the event. Best Eliane Domingos de Sousa Brazilian LibreOffice Community -- 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] Cannot add primary key after saving without primary key.
David Smith wrote: Software: Libreoffice base Version: 3.5.4.2 (Debian Wheezy) Subject: Cannot add primary key after saving without primary key. I've got a problem. I'm trying to test some different table designs. Whenever I create a table without a primary key, I find that I cannot go back and add a primary key later. When I first save the table, Libreoffice asks me if I want to create a primary key now. I choose no because I'm experimenting with some different table designs and didn't want to commit to anything just yet. 1. Create table without primary key. 2. Save table. 3. Libreoffice asks if I want to create a primary key now. 4. I choose no. 5. I later then open the table and set the primary key. 6. I save the table. 7. I open the table again and the primary key that I chose was not saved! I've never had this kind of problem with a database before. Is this a bug or a missing feature? David, I am using the MySQL server for my database and have seen similar problems. I recently created a new table, selected the key, but forgot to set the Autoincrement attribute on the key before my first save of the table structure. I tried several things, such as moving the key to a temporary field, but nothing allowed me to make the original key field autoincrement. Every time I saved the table, the autoincrement selection on the key would revert to No. Since this was a new table and no data was in it yet, I ended up deleting the table and recreating it with the autoincrement set on the key before I first saved it. I had similar things happen to me with table structure key definitions before. Once, I had to use the MySQL Monitor program and some SQL statements to change key definitions on existing database tables. Not fun and error prone, but it worked. The odd thing is that there is no error message from the server when these things happen, which makes me suspicious of Base or the JDBC driver - even more so since you are using a different server. The bottom line is that as far as Base table keys go, you must set them up properly before you do that first save of the new table structure. In my experience, non-key fields may be changed or added after the first save. The key field is special. Hope this helps. Girvin Herr -- 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] North American DVD 3.5.6
My desktop is not dual boot, but I have a laptop that is. desktop - Ubuntu 12.04/MATE laptop - Vista 32-bit [came with] and Ubuntu 12.04/Mate testing system. My NA-DVD ISO file is placed on the LO server system, and the mirror sync system. Soon 3.5.7 will be there. I never did use any md5sum system because I never knew how to use them properly or create them properly. My NA-DVD has about 90 LO install files plus the language and help packs. That is a lot of md5sum files to generate for the online version every time the install files are changed, either LO's file or all of the other files that are available. My current 3.5.x folder has 866 files and folders in that folder system. The actual number of installs, language/help packs, documentation, dictionaries, templates and extensions, artwork and images, and extra software, that are on the DVD is currently not known - since I never really kept a count of them. Which file need a md5sum and which do not? I created the NA-DVD so people could download a copy and burn it to their own DVD, then they will have a physical media to give to people with dial-up or ones who could use all of the documentation, dictionaries, etc., on one disk for easy access. The people at LO are hosting the ISO files, thank you, since my hosting company will not allow a CD or DVD sized file to be placed on their servers. They do not want to have their system used as a repository site. I can have all of the files in the DVD online as a web site, but not them combined into an ISO file. I also have unlimited bandwidth/traffic for the site. That would make a repository site creator happy, but sorry no repository allowed there. If I could I would have been one of those authorized mirrors are well, but sadly not allowed either. I have created a page listing free software - for Windows - but to stop any possible nasties that could happen, I link back to the software's original download pages. Also, I do not need to keep up with their updates/upgrades. To be honest, since I went to Ubuntu for my desktop, since I could not afford to buy Win7 and get the desktop I wanted, I have not kept up with looking for good free software alternatives for Windows users. When I was a Windows user, I needed a place to go to for all of the software I use or have used so I, or friends, could easily find the software I/they might need. I still point it out to people for a place to find links to free anti-virus and firewall software. http://lungstrom.com/list/ On 10/21/2012 01:34 PM, James Knott wrote: Tom Davies wrote: I think Tim uses a dual-boot on his main machine so the linux option is fine. Errr, did someone say they managed to generate an Md5 of the iso on the website and compared it to one generated from their download? If so does that mean the one they generated could just be written onto the website? Sorry, i am being really slow on the uptake here! You'd get the md5sum from the web site and compare with the downloaded file md5sum. The only one writing to the web site should be the one who placed the files there. Please note that md5sum verifies only the integrity of the downloaded file. If it came from a web site after it had been tampered with and the md5sum recreated, then you could still get something nasty. So, it's best to check against the original source md5sum. There may be authorized mirrors of the original site that can also be trusted. -- 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] Brazilian LibreOffice Magazine released
On 10/21/2012 02:00 PM, Eliane Domingos de Sousa wrote: Dear Community, With proud the Brazilian LibreOffice Community released the first edition of LibreOffice Magazine in portuguese during the event Latinoware 2012. The Magazine is available on wiki in two formats: pdf and odg. * PDF: http://wiki.documentfoundation.org/images/9/98/LibreOffice_Magazine_01.pdf * ODG: http://wiki.documentfoundation.org/images/c/cf/LM-ED01.odg The Magazine was prepared in LibreOffice Draw. It was one of the surprises in the event. Best Eliane Domingos de Sousa Brazilian LibreOffice Community It would be nice to have this type of PDF magazine in English. I know many people who would download it. -- 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] Use of MD5 and other HASH values of LibO package downloads and alternate distribution DVD uploads
Tim, We applaud the work you've been doing on the English-NA-DVD, but since you've taken on that responsibility its cradle to grave handling also requires that you validate receipt of the initial ISO image upload to the Document Foundation Mirrors. TDF will take your upload of bundled components and post it exactly as they receive it. Followed by TDF implemented MirrorBrain metadata service that calculates the initial HASH values (MD5, SHA-1, SHA-256 and BitTorrent) and publishes the details for use on the download mirrors. Point is, they won't normally test that they have a good upload from your build system--that responsibility is yours. And to add to your effort, to be technically correct you should probably verify the HASH value of each component installer you download for use in the compilation--found most conveniently at the http://download.documentfoundation.org/libreoffice/ where you probably want the stable/ tree (and can check on your box/ DVD distro). Navigate down into the build you are compiling and the OS. On the page listing the language specific installers each file will have a corresponding MirriorBrain provisioned link labeled Details that has full metadata of just that file including the HASH values. Check each package you will bundle against those values so you know you have a clean download. You probably don't want to be responsible for distributing a corrupt install package that was incompletely downloaded as you build the DVD. Then, once compiled into your English-NA-DVD .iso image, you need to calculate a HASH value of the ISO being uploaded. You need this to compare what you send against what the transfer server receives. After upload, or probably once published to the TDF mirror, compare the HASH value(s) the MirrorBrain published metadata. When uploading or downloading I generally will calculate and compare against the first few digits of MD5 and SHA256 HASH values As an example, since you are on a Linux, you have the terminal window command line use of these commands: md5sum LO-3.5.6_English-NA-DVD_all-platforms_multi-lang_plus-extras_v2.iso sha1sum LO-3.5.6_English-NA-DVD_all-platforms_multi-lang_plus-extras_v2.iso sha256sum LO-3.5.6_English-NA-DVD_all-platforms_multi-lang_plus-extras_v2.iso Folks on Windows don't have a Microsoft provided digest tool--command line or GUI. But there are many to be found. Because of the range of digest HASH types I have to deal with I prefer a digest tool integrated with the Windows shell and widely use the freeware Hash CRC tool published in the fileTweak utilizes of Febooti. Available here: http://www.febooti.com/downloads/ Installed as administrator, it then gives ALL users the ability to calculate HASH values from the Properties panel (i.e. right mouse) of any file viewable in Windows explorer shell GUI. If you'd like to compare for real, here are the HASH values for the last ISO build you posted as available at: http://download.documentfoundation.org/libreoffice/box/3.5.6/LO-3.5.6_English-NA-DVD_all-platforms_multi-lang_plus-extras_v2.iso.mirrorlist LO-3.5.6_English-NA-DVD_all-platforms_multi-lang_plus-extras_v2.iso Powered by MirrorBrain Size: 3.8G (4044062720 bytes) Last modified: Wed, 22 Aug 2012 03:58:15 GMT (Unix time: 1345607895) SHA-256 Hash: 55d62394196ab920d99ec99480d515672d738a152c26c92177500cd3113c8fa7 SHA-1 Hash: 8560042169d28f30053f91aae5523fbac049234b MD5 Hash: 96560a0b6c117a07d32d33baa1e2ef30 BitTorrent Information Hash: 9ea3cc57031a78cb5af214a041637a5ff2f30648 Hope that is clear enough so that it helps you to understand that there is a bit more work you need to take on to assure the quality of your DVD box/ (i.e. as in Boxed set software distribution). Stuart p.s. I've cc'd this to the QA list to see if there are any other recommendations for the process. From: webmaster-Kracked_P_P [mailto:webmas...@krackedpress.com] Sent: Sun 10/21/2012 10:34 AM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] North American DVD 3.5.6 NO ONE has given me the answer before on how to create a md5sum file before. And I asked that question back in the 3.3.x version days. I have printed your answer out to PDF and I will place it on my folder[s] for the NA-DVD work. I use Ubuntu 12.04/MATE [10.04/GNOME before this month] to create the NA-DVD web site and the ISO file. I use Kompozer and Kate for most of the HTML work. I use K3b to create the ISO file I use Filezilla as my FTP client. K3b creates a checksum but I do not know where it is stored for my use. -- 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
Re: [libreoffice-users] Inserting a code for today's date
upscope wrote: On Friday, October 19, 2012 10:29:32 AM Girvin R. Herr wrote: Joel Madero wrote: Ah, yes my mistake for assuming what you were using. I'll have to look into writer. I just tried inserting a table (1x1) and putting the formula, no good. Regards, Joel snip 1. Place the cursor where you want the date. 2. Select Insert - Fields - Other 3. Select the Document tab 4. Select Date for Type 5. Select Date for Select 6. Choose your date format under Format. 7. Click on Insert. If in step #5 you select Date (Fixed), I think that will insert today's date but it will not update in future edits. Even this procedure may not work in a template. More investigation is needed. Hope this helps. Girvin Herr When I last used it, the Date (Fixed) inserted the date on the day its set up and does not update the date. If you select Date it changes the date everytime the document is opened, also changes it when person recieving the document recieves it, I'm told. I send out a newletter each month and the date is changed each time I update it before I send it and then when it goes out. upscope, Yes, this is true. That is why I personally don't use Date as opposed to Date (Fixed) on my documents. If the document is a one-time simple document, such as a letter where the date is used once and not throughout a multi-page document, I usually just type the date in and edit it each time I revise the document. That way it doesn't unexpectedly change on me. Using the auto change date form caused me headaches in this respect. Another option I use is the document properties feature. I create a custom version date property File - Properties Custom Properties tab and then insert that property as a field. Insert - Fields - Other DocInformation tab Custom type Then I only need to change the one property to change any and all instances in the document. Works for me. It also works in headers and footers. While verifying this just now, I noticed some other fields in the Docinformation tab I will have to investigate: Last Printed and Modified may be of interest to this thread. Hope this helps. Girvin Herr -- 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] advantages of LO plus a link to membership forms
Hi :) People write to this list from all over the world when they have a problem with LO. The tens of millions of people that have no problem with LO don't write in to this list to say so. (thankfully!) So, how can we hear about some of the advantages? Why use LO when there are alternatives? Is it just about the cost of license fees? Why do so many people put so much of themselves into this project? How about this list of intentions produced around when TDF was becoming a legal company? http://www.documentfoundation.org/foundation/ Do you find some of the points in the Our Values section true for you too? Regards from Tom :) -- 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
Cloud-space? Re: [libreoffice-users] Use of MD5 and other HASH values of LibO package downloads and alternate distribution DVD uploads
Hi :) The workflow for the NA DVD Project involves 1. downloading the installer files from the LO or TDF servers 2. bundling it with some documentation, Extensions and 3rd party programs 3. re-uploading the resulting .iso through a domestic line that takes somewhere between 4-8hours (assuming it goes smoothly and the line doesn't drop-out). The 'broadband' line is in a building that is of an age that prohibits upgrading the line. A few people looked into 3rd party Cloud space to store and work on the files but the options seemed inflexible and quite expensive. The amount of space required only occasionally tips over the amount the team could get for free without using fairly dubious 3rd party space. A lot of the space is for files that already exist on TDF and LO servers. Also the team wasn't completely confident about how much to trust or how to use any strange tools available on 3rd party Cloud-space. There must be some easier way of doing this without having to learn tons of advanced new stuff! Regards from Tom :) From: V Stuart Foote vstuart.fo...@utsa.edu To: users@global.libreoffice.org; libreoffice...@lists.freedesktop.org Sent: Sunday, 21 October 2012, 19:33 Subject: [libreoffice-users] Use of MD5 and other HASH values of LibO package downloads and alternate distribution DVD uploads Tim, We applaud the work you've been doing on the English-NA-DVD, but since you've taken on that responsibility its cradle to grave handling also requires that you validate receipt of the initial ISO image upload to the Document Foundation Mirrors. TDF will take your upload of bundled components and post it exactly as they receive it. Followed by TDF implemented MirrorBrain metadata service that calculates the initial HASH values (MD5, SHA-1, SHA-256 and BitTorrent) and publishes the details for use on the download mirrors. Point is, they won't normally test that they have a good upload from your build system--that responsibility is yours. And to add to your effort, to be technically correct you should probably verify the HASH value of each component installer you download for use in the compilation--found most conveniently at the http://download.documentfoundation.org/libreoffice/ where you probably want the stable/ tree (and can check on your box/ DVD distro). Navigate down into the build you are compiling and the OS. On the page listing the language specific installers each file will have a corresponding MirriorBrain provisioned link labeled Details that has full metadata of just that file including the HASH values. Check each package you will bundle against those values so you know you have a clean download. You probably don't want to be responsible for distributing a corrupt install package that was incompletely downloaded as you build the DVD. Then, once compiled into your English-NA-DVD .iso image, you need to calculate a HASH value of the ISO being uploaded. You need this to compare what you send against what the transfer server receives. After upload, or probably once published to the TDF mirror, compare the HASH value(s) the MirrorBrain published metadata. When uploading or downloading I generally will calculate and compare against the first few digits of MD5 and SHA256 HASH values As an example, since you are on a Linux, you have the terminal window command line use of these commands: md5sum LO-3.5.6_English-NA-DVD_all-platforms_multi-lang_plus-extras_v2.iso sha1sum LO-3.5.6_English-NA-DVD_all-platforms_multi-lang_plus-extras_v2.iso sha256sum LO-3.5.6_English-NA-DVD_all-platforms_multi-lang_plus-extras_v2.iso Folks on Windows don't have a Microsoft provided digest tool--command line or GUI. But there are many to be found. Because of the range of digest HASH types I have to deal with I prefer a digest tool integrated with the Windows shell and widely use the freeware Hash CRC tool published in the fileTweak utilizes of Febooti. Available here: http://www.febooti.com/downloads/ Installed as administrator, it then gives ALL users the ability to calculate HASH values from the Properties panel (i.e. right mouse) of any file viewable in Windows explorer shell GUI. If you'd like to compare for real, here are the HASH values for the last ISO build you posted as available at: http://download.documentfoundation.org/libreoffice/box/3.5.6/LO-3.5.6_English-NA-DVD_all-platforms_multi-lang_plus-extras_v2.iso.mirrorlist LO-3.5.6_English-NA-DVD_all-platforms_multi-lang_plus-extras_v2.iso Powered by MirrorBrain Size: 3.8G (4044062720 bytes) Last modified: Wed, 22 Aug 2012 03:58:15 GMT (Unix time: 1345607895) SHA-256 Hash: 55d62394196ab920d99ec99480d515672d738a152c26c92177500cd3113c8fa7 SHA-1 Hash: 8560042169d28f30053f91aae5523fbac049234b MD5 Hash: 96560a0b6c117a07d32d33baa1e2ef30 BitTorrent Information Hash: 9ea3cc57031a78cb5af214a041637a5ff2f30648 Hope that is clear enough
[libreoffice-users] Re: From MS Word to Writer: keeping my styles, macros, toolbars from Normal.dot
Hello all, and thank you for welcoming me here. First, I'd like to address the remarks of the few people who told me that I should not fill any fuel into [my new car] even if [it] looks very similar like the old one. I am not starting my document-creating life from scratch today. I created lots of content over many years, and would like to keep using that content. There are thousands (millions?) of users like me: should all the people who used Word before OOo and LibO even existed lose the tools they've spent years perfecting? I think my migration questions are perfectly valid. And I'll go further: I think an official answer (read: documentation) should be available to all of LibO's users. Because no, not many people are born into using LibO: most are, instead, migrating from another office suite. If you want them to adopt this new software, you must help them doing so! --- Now, for what I did so far (questions in green): I opened my Normal.dot template with Writer, saved it as MyTemplate.ott. Then FilesTemplatesOrganize, selected it and made it the default template (that's exactly what Tom and Andreas recommended. Thanks!) The results: *Styles*: every new document allows me to use my former styles. All of them were imported, except for the few character styles I had: Word distinguishes between paragraph styles and character styles, and it looks like it won't let me convert a character style into a paragraph style. I'll have to re-create those in LibO (I'll make sure to read the two chapters dedicated to styles in http://wiki.documentfoundation.org/images/7/73/WG3400-WriterGuideLO.pdf). *Buttons*: LibO didn't import any of the buttons which referred to MS Word commands, which... makes sense, of course. I also had many buttons calling my macros, and it did not import all of them; I think it only imported the ones I had created, and not the predefined Word buttons... Although I'm not entirely sure. I'll need more custom buttons. It's nice to be able to import image files, but is there any way I could import several at once? *Toolbars*: in Word, I had 5 custom toolbars displayed out of 14. Well, LibO imported 4 toolbars, including one that wasn't displayed in Word and that I didn't really care about... No idea how it chose them. In Word, I had also placed buttons on the menu bar. It imported them, but won't let me remove them through its own interface now! ^^ *Shortcuts*: I suppose it makes perfect sense that I have to re-create those. That's alright. :) *AutoText* and *AutoCorrect* entries: I gave a method to import those in my last email... But on second thought, I won't. Instead, I will use a system-wide text expander such as Breevy or PhraseExpress, that will work in all my applications. *Custom dictionaries*: it looks like you can paste content directly in C:\Users\username\AppData\Roaming\LibreOffice\3\user\wordbook\DictYouJustCreated.dic, as long as you have one entry per line. No need for a macro! *Macros*, mine, the ones I actually need: I tried running several of them, and none seemed to work. It returns error messages from the first line of code every time... I must have forgotten something! In the Options, on the Load/Save / VBA Properties page, all the boxes are checked (can't remember if I did that or if that was the default). Is there any way to make that work any better? If I need to re-write / re-record everything, chapter 13 of https://wiki.documentfoundation.org/images/3/33/GS35-GettingStartedLO.pdfseems like a good place to start. And it provides links to other resources as well. I also found an MS Word macro to print a list of all my existing macroshttp://word.tips.net/T007423_Printing_a_Macro_List.html. That'll be useful to check them one by one as I re-create them! ^^ --- If you have ideas, comments, answers to my questions... please don't hesitate! Thanks, Kyla 2012/10/11 Kyla Robertson robertsonk...@gmail.com: Hello, I'm migrating from MS Word (Office 2002 !) to LibO Writer. In Word, my Normal.dot template contains many, many things: about 150 styles, 250 macros, some auto-insert texts, some custom shortcuts, many toolbars and custom buttons. How can I keep this all to use it with Writer? In Migration Guide: A guide to ease your migration to OpenOffice.org from other office [suites] (2004) ( http://www.openoffice.org/documentation/manuals/oooauthors/MigrationGuide.pdf ), I found a few things: * AutoText entries: will the built-in method to import them still work with LibO 3.6.2?(should I get version 3.6.2 or 3.5.6, btw? I'm not sure I understand the difference.) * AutoCorrect entries: there's a work-around with a macro and the editing of a ./user/autocorr/acorr.dat file... * Custom dictionaries: there was a work-around to import their content, but the link to download the macro isn't valid anymore. Do you know of a more recent migration guide, or a tutorial on the Web, or forum post maybe? I couldn't find anything else. Thanks in
Re: [libreoffice-users] Re: From MS Word to Writer: keeping my styles, macros, toolbars from Normal.dot
Hi :) Wow!! Looks like a lot of valuable work and some good feedback there. Perhaps something that would be good for a wiki-page? If you want to post some of the contents of some of your macros to the Users List or tell us what you wanted them to do then there might be soem help in translating them into LO macros or pointing you to existing Extensions that already do something similar. It's not really what the Users List is for but sometimes people with the rigth skills are here and get interested in the odd challenge. Regards from Tom :) From: Kyla Robertson robertsonk...@gmail.com To: users@global.libreoffice.org Cc: documentat...@global.libreoffice.org Sent: Sunday, 21 October 2012, 22:56 Subject: [libreoffice-users] Re: From MS Word to Writer: keeping my styles, macros, toolbars from Normal.dot Hello all, and thank you for welcoming me here. First, I'd like to address the remarks of the few people who told me that I should not fill any fuel into [my new car] even if [it] looks very similar like the old one. I am not starting my document-creating life from scratch today. I created lots of content over many years, and would like to keep using that content. There are thousands (millions?) of users like me: should all the people who used Word before OOo and LibO even existed lose the tools they've spent years perfecting? I think my migration questions are perfectly valid. And I'll go further: I think an official answer (read: documentation) should be available to all of LibO's users. Because no, not many people are born into using LibO: most are, instead, migrating from another office suite. If you want them to adopt this new software, you must help them doing so! --- Now, for what I did so far (questions in green): I opened my Normal.dot template with Writer, saved it as MyTemplate.ott. Then FilesTemplatesOrganize, selected it and made it the default template (that's exactly what Tom and Andreas recommended. Thanks!) The results: *Styles*: every new document allows me to use my former styles. All of them were imported, except for the few character styles I had: Word distinguishes between paragraph styles and character styles, and it looks like it won't let me convert a character style into a paragraph style. I'll have to re-create those in LibO (I'll make sure to read the two chapters dedicated to styles in http://wiki.documentfoundation.org/images/7/73/WG3400-WriterGuideLO.pdf). *Buttons*: LibO didn't import any of the buttons which referred to MS Word commands, which... makes sense, of course. I also had many buttons calling my macros, and it did not import all of them; I think it only imported the ones I had created, and not the predefined Word buttons... Although I'm not entirely sure. I'll need more custom buttons. It's nice to be able to import image files, but is there any way I could import several at once? *Toolbars*: in Word, I had 5 custom toolbars displayed out of 14. Well, LibO imported 4 toolbars, including one that wasn't displayed in Word and that I didn't really care about... No idea how it chose them. In Word, I had also placed buttons on the menu bar. It imported them, but won't let me remove them through its own interface now! ^^ *Shortcuts*: I suppose it makes perfect sense that I have to re-create those. That's alright. :) *AutoText* and *AutoCorrect* entries: I gave a method to import those in my last email... But on second thought, I won't. Instead, I will use a system-wide text expander such as Breevy or PhraseExpress, that will work in all my applications. *Custom dictionaries*: it looks like you can paste content directly in C:\Users\username\AppData\Roaming\LibreOffice\3\user\wordbook\DictYouJustCreated.dic, as long as you have one entry per line. No need for a macro! *Macros*, mine, the ones I actually need: I tried running several of them, and none seemed to work. It returns error messages from the first line of code every time... I must have forgotten something! In the Options, on the Load/Save / VBA Properties page, all the boxes are checked (can't remember if I did that or if that was the default). Is there any way to make that work any better? If I need to re-write / re-record everything, chapter 13 of https://wiki.documentfoundation.org/images/3/33/GS35-GettingStartedLO.pdfseems like a good place to start. And it provides links to other resources as well. I also found an MS Word macro to print a list of all my existing macroshttp://word.tips.net/T007423_Printing_a_Macro_List.html. That'll be useful to check them one by one as I re-create them! ^^ --- If you have ideas, comments, answers to my questions... please don't hesitate! Thanks, Kyla 2012/10/11 Kyla Robertson robertsonk...@gmail.com: Hello, I'm migrating from MS Word (Office 2002 !) to LibO Writer. In Word, my Normal.dot template contains many, many things: about 150 styles, 250 macros, some auto-insert texts, some custom
Re: [libreoffice-users] Use of MD5 and other HASHvalues of LibO package downloads and alternate distribution DVD uploads
Tim, Very reasonable that you would not have, or want, direct write access to the pool holding the master copies for distribution out to the mirrors--that is syssamdin magic better handled by the folks running the mirror service. My suggestion is that you verify that the MirrorBrain HASH values for the .ISO file against what you created locally prior to you upload. That way you can be certain that what you prepared will make it intact out to the mirrors. Each user then must be responsible for verifying their own downloads, with some trust that what is being downloaded is your original. Using the HASH values facilitates that at all steps--but you set the foundation for it. You can wait for it to post up to the mirrors and grab the MirrorBrain HASH (as either the Info, or Details link--same content), or you can ask your contact to provide you the HASH value of what they received at the transfer server. Or if you're conservative, just do both. Practice a bit with the md5sum, md256sum and you'll soon make it habit for all your data transfers--even locally between your computers. Stuart From: webmaster-Kracked_P_P [mailto:webmas...@krackedpress.com] Sent: Sun 10/21/2012 6:55 PM To: users@global.libreoffice.org Subject: Re: Cloud-space? Re: [libreoffice-users] Use of MD5 and other HASHvalues of LibO package downloads and alternate distribution DVD uploads My 4.2 - 4.3 GB of an ISO file takes about 9 to 10 hours to upload. Also, I do not have access to the mirror system of servers. I upload it to a different server where it is them moved onto the system that it part of the mirror sync system. [or so I have been told] So I cannot use the TDF system to verify my uploaded file. I do not have that option[s]. I upload to the server I have access to via Filezilla. Personally, I really do not want to have the permissions to access the LO folder system that is part of the system that will be mirrored. I do not want to have a partially uploaded file get mirrored when the local mirror goes and syncs to the master files/folders on the LO server[s]. It is much safer to upload it to an outside server folder outside to the mirrored folders, and then have a server support person move it from the temporary folder to the one it needs to go to. For the 3.5.7 DVD it would be the folder that holds the files for the http://www.libreoffice.org/download/?type=boxversion=3.5.7 page, where-ever it is located. For a different ISO file, the link is: http://download.documentfoundation.org/libreoffice/box/3.5.6/LO-3.5.6_English-NA-DVD_all-platforms_multi-lang_plus-extras_v2.iso but that does not mean that it is the exact folder of /libreoffice/box/3.5.6/ off the download.sub-domain folder but something that the system associates with it. I know my hosting system has a lot of relative file/folder placements in my domain.us/folders/folders/file.html URLs. -- 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] Libre Writer - Opening plain text documents to desired font
On 2012-10-21 11:25, charles meyer wrote: Hi Brian, Yes, you got it. My goal is to open (not paste in) saved plain text files in a blank, newly opened Libre Write document. I've visited Preformatted Style and change the style to Bookman Old 12 point, clicked Apply and then saved it (or so I thought) only for it to always default back to Courier New 10 point when I open any plain text file. I've created a Default font with Bookman Old 12 point but Libre Write automatically opens all *saved* plain text files to Preformatted Style not Default. I just wondered if there was any way to change which style Libre Writer will open *saved* plain text files automatically to since Libre Writer does not seems to save changes to the Prefromatted Style? Oddly enough if you click FormatStyles the drop down list of autonomic styles Preoformated is *not* listed. You must list all styles to find it. Following webmaster-Kracked's inspiration, I saved a document as Text Encoded but whne I re-opened the file it still opens all documents saved as Text Encoded and/or Plain Text in the Performatted Style. The key seems to be induing Libre Writer to open Text Encoded and/or Plain Text files to either Default (where I have it set to Bookman Old 12 point) or another style which does not require Courier New 10 point. Has anyone on the list successful changed the style Text Encoded or Plain Text files open to? Thanks so much, Charles. Subject:Re: [libreoffice-users] Libre Writer - Opening plain text documents to desired font From:Brian Barkerb.m.bar...@btinternet.com Date:Sat, 20 Oct 2012 04:21:49 +0100 To:users@global.libreoffice.org snip There are two issues here, I think. In order to change the Preformatted Text paragraph style you have to have a document open - and the change is made to the style in that document, not in your installation of LibreOffice. So your change is ignored when you open the new document from your plain text file. The way around that might seem to be to create a template containing your modified Preformatted Text paragraph style and then to set that as the default template. You can certainly do that. Now you would probably expect in this case that when you open your plain text file the new text (Writer) document would be created from your new modified default template, but - perhaps perversely - it appears to be opened using the original default default template, ignoring your desired change. I trust this helps (though I doubt it does). Brian Barker Charles/Brian: I found one way to view a plain text file in something other than the default Courier New 10 pt' when it is opened. If you go into Tools|Options|Fonts, you can use font substitution to change the Courier New 10 pt font to a different font. FYI: This will impact any other documents that use the Courier New font that may not be plain text files. Maybe this helps, TomW -- 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