[libreoffice-users] Re: Linux hyphenation
Virgil Arrington: Have you tried to install 'hyphen-en-us' package? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Linux hyphenation
On 09/14/2013 08:28 AM, Urmas wrote: Virgil Arrington: Have you tried to install 'hyphen-en-us' package? Are you asking about a package that is included with Linux Mint? There is a working hyphen package in the American English dictionary. Spelling, Thesaurus, and Hyphenation, for en_US. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] LO 4.0 vs word editing
There is a feature in Word that is not well supported in LO and is breaking my back when people make a comment in Word, the text is highlighted and that highlighting disappears again when you delete the comment. Try to do that in LO, and it's hopeless. The highlighting does not disappear, and worse yet, the final letter of the highlighted section comes out several fontsizes smaller, thus requiring two manual adjustments every time you delete a comment. Try to do that in a doc with hundreds of comments. -- *Rogier Fentener van Vlissingen http://viz.me/vliscony/t/7* *About Me* http://about.me/vliscony -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calk - lookup cell in column
The closest I came to a solution was a scenario where all the dates for the year were in one column. I put the dates for the year (Monday 12/31/2012 thru Sunday 1/5/2014 in A5:A375. Then, in A1 I put whatever date I'm looking for. Off to the side (D1) I entered: =VLOOKUP($A$1,$A$5:$A$375,1,0)-(A5-1)+4 VLOOKUP(A1,$A$5:$A$375,1,1) finds the date you're looking for. -(A5-1) subtracts the day before the first date on the list FROM the date found. +4 adds in the four rows above the range. The result is the row number of the date you're looking for. I hope this helps. -- Tim === On 9/13/2013 11:36 AM, IGraham wrote: Hi Now this might take a bit of explaining I have a spreadsheet that records data for each day of the year Vertically row by row I have the days of the year I like my week to start on a Monday So I have my year/days set to start on the first Monday of the year So the actual first day of the year position/row is dynamic either on the Monday or above This all works ok However I then (for manipulating data by month) need to know the row/cell in which the first day of the year (or month) appears How do I look up/find within a column the cell in which the first day of the month is - I assume that if I know how to do it for say January then I can do it for any month. I'm totally clueless as to how to do this /Hopping that my explanation isn't to bamboozling/ Any ideas - please - IGraham W764 LibreOffice 4.1.0.4 -- View this message in context: http://nabble.documentfoundation.org/Calk-lookup-cell-in-column-tp4074117.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Linux hyphenation
As Kracked alluded, I'm not sure what Urmas is referring to. I've installed the American English dictionary from the extension library. It has a hyphenation library. What my program seems to be messing is the Libhyphen Hyphenator module, whatever that is... Virgil -Original Message- From: Kracked_P_P---webmaster Sent: Saturday, September 14, 2013 10:19 AM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: Linux hyphenation On 09/14/2013 08:28 AM, Urmas wrote: Virgil Arrington: Have you tried to install 'hyphen-en-us' package? Are you asking about a package that is included with Linux Mint? There is a working hyphen package in the American English dictionary. Spelling, Thesaurus, and Hyphenation, for en_US. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Linux hyphenation
Hi :) The Rpm distros put the User Profile in exactly the same place as does every other GnuLinux system except openSuSE and maybe SuSE. The difference they make is about halfway through there is a folder called libreoffice which they rename to lo. Programs used to put their user-profiles and configuration files straight into the users home directory but over the years there was some agreement that it made things look a bit messy so most programs are moving their configs into a sub-folder called .config and that . makes it a hidden folder. If you have a version of LibreOffice earlier than 3.5.0 then it's User Profile might be in the old place but all currently supported versions are in /home/user name/.config/libreoffice/4/user errr, except 3.6.x which is in /home/user name/.config/libreoffice/3/user If you are new to GnuLinux it might be interesting to have a look in /home/user name/.config to see which programs/packages have already made it into there and then look in the old /home/user name to see which ones haven't made it yet. Those that haven't moved already probably will move to rejoin the others in their next upgrade (or maybe the one after). LibreOffice made the move earlier than a lot of them because LO upgrades so quickly. I'm not sure what you mean about scattered around the system. The only bits you need to worry about are in /home Log-files are kept with all the other logfiles but you shouldn't poke around with them and the programs are kept with the other programs but you shouldn't poke around with them either. Generally it is not a good idea to poke around with any system-files and all system-files form everything that is outside the /home You may have successfully followed advice to make some changes to your system-files to move around menu entries in your boot-menu or edited your network settings or graphics card or ssh but all those are per machine rather then per user and you will have had to use sudo, gksu, su or had to deal with a dialogue-box asking permission to act as Super User in order to deal with changes to system-files. One advantage is that if you need to back-up your system then you only need to back-up your /home and that doesn't grab tons of extra stuff that wont work on a different system. You could copy your /home to a different machine and then install a different OS and still find all your stuff and configs neatly unharmed and all working to give you your programs the way you tweaked them. It helps if your /home is on it's own partition because then there are tons of other neat tricks you can do. Anyway all this is wy off-topic. It would be nice to have a separate thread about that sort of thing but it's not really anything to do with LibreOffice. One nice forum that tries to cover all the different flavours of GnuLinux is http://www.linuxquestions.org although each distro tends to have it's own in addition to using that one. Regards from Tom :) From: Kracked_P_P---webmaster webmas...@krackedpress.com To: users@global.libreoffice.org Sent: Friday, 13 September 2013, 21:51 Subject: Re: [libreoffice-users] Linux hyphenation On 09/13/2013 04:36 PM, Virgil Arrington wrote: Kracked_P_P---webmaster wrote: In the top box of the Writing Aids, I see Hunspell Spellchecker, Libhyphen Hyphenator, Lightproof grammar checker, and Openoffice.org New Thesaurus. I'm missing the Libhyphen Hyphenator and Lightproof Grammar Checker. I'll try renaming the profile. I've done this so many times in Windows that it's second nature to me. I've been a little skittish about doing in in Linux as I'm just not accustomed to the way Linux spreads things around its file system. Virgil Yes, Linux can be something after using Windows for years and years. The .config folder is a hidden folder as well, so that messes people up as well. I know where it is located with Debian-based Linux, Like Ubuntu and Mint, but not on the RPM based installs of LO. I do not know why you do not have those two parts. I recently did a clean install on a new drive. So it all has been mostly default installs. I did not add anything to LO except the dictionary .oxt file. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot
[libreoffice-users] EMail mailmerge - does it work?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi In the past I had used the email mailmerge features in LibreOffice with some problems, and was wondering if it works now? I still see it in the menus but before setting up a proper data source and going throught the wizard I just wanted to ask here. I seem to remember it depended on Java and it would be removed or rewritten at some point. Thanks for any information about this. Regards, Fabian - -- Fabián Rodríguez http://fsf.magicfab.ca -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: PGP/Mime available upon request Comment: Using GnuPG with undefined - http://www.enigmail.net/ iEYEARECAAYFAlI0R2gACgkQfUcTXFrypNVkyACgyPlV409DEDYK0ebJv5XbWvMr GYcAoOQndxDNdMUDh548bOGpZ/vPUQEg =M8mP -END PGP SIGNATURE- -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] How to change the fonts of all equations in an impress presentation
Dear all, I have a problem with Libreoffice Impressfor which I didn't find any solution in internet. My problem: I have a presentation with lots of equations and I want to change the fonts in this presentation. For normal text this is easily done changing the corresponding styles. However, so far I didn't find a way to change the fonts of all equations (in an efficient way, without modifying each equation manually). I understand that I need a macro for doing this. In the Math documentation http://wiki.documentfoundation.org/images/3/37/MG40-MathGuide.pdf on page 46 I found a macro which works nicely in Libreoffice Writer, but not in Impress. On page 47 it is said that in Impress some modifications are necessary. I made these modifications (hopefully correctly, I am not sure), but the macro does not work, giving me the error message BASIC runtime error. Property or method not found: EmbeddedObjects My macro is this (essentially the one from the documentation): Sub ChangeFormatFormuleImpress oCurrentController = ThisComponent.getCurrentController() oTextDocument = oCurrentController.Model oEmbeddedObjects = oTextDocument.EmbeddedObjects nEndIndex = oEmbeddedObjects.Count-1 for nIndex=0 to nEndIndex oMathObject = oEmbeddedObjects.getByIndex(nIndex) oModel = oMathObject.Model if (not isNull(oModel)) then if(not isEmpty(oModel)) then if oShape.supportsService(com.sun.star.drawing.OLE2Shape) then if oShape.CLSID = 078B7ABA-54FC-457F-8551-6147e776a997 then oModelFormula = oShape.Model oModelFormula.BaseFontHeight = 12 oModel.BaseFontHeight = 12 policeCommune= Arial ' Variables oModel.FontNameVariables= policeCommune oModel.FontVariablesIsItalic=false oModel.FontVariablesIsBold=false ' Functions oModel.FontNameFunctions = policeCommune oModel.FontFunctionsIsItalic=false oModel.FontFunctionsIsBold=false ' Numbers oModel.FontNameNumbers= policeCommune oModel.FontNumbersIsItalic=false oModel.FontNumbersIsBold=false ' Text oModel.FontNameText= policeCommune oModel.FontTextIsItalic=false oModel.FontTextIsBold=false ' Update oXCOEO = oMathObject.ExtendedControlOverEmbeddedObject oXCOEO.update() endif endif ' if formula endif ' if not empty endif ' if not null next nIndex ThisComponent.reformat() ' Met à jour tous les éléments du document End Sub Because I have never written a Libreoffice macro before, I am lost here and any help would be appreciated. My system: Libreoffice 4.1.1, Linux, 64 bit Markus -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] EMail mailmerge - does it work?
Hi, Fabian Been successfully using the mailmerge feature for a number of years now, using MySql/MariaDB as well as Calc spreadsheets, in both Ubuntu Natty and Linux Mint 13 (Maya). HTH. John Herron - On 09/14/2013 01:24 PM, Fabian Rodriguez wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi In the past I had used the email mailmerge features in LibreOffice with some problems, and was wondering if it works now? I still see it in the menus but before setting up a proper data source and going throught the wizard I just wanted to ask here. I seem to remember it depended on Java and it would be removed or rewritten at some point. Thanks for any information about this. Regards, Fabian - -- Fabián Rodríguez http://fsf.magicfab.ca -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: PGP/Mime available upon request Comment: Using GnuPG with undefined - http://www.enigmail.net/ iEYEARECAAYFAlI0R2gACgkQfUcTXFrypNVkyACgyPlV409DEDYK0ebJv5XbWvMr GYcAoOQndxDNdMUDh548bOGpZ/vPUQEg =M8mP -END PGP SIGNATURE- -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calk - lookup cell in column
On 09/14/2013 07:01 PM, Tim Deaton wrote: The closest I came to a solution was a scenario where all the dates for the year were in one column. I put the dates for the year (Monday 12/31/2012 thru Sunday 1/5/2014 in A5:A375. Then, in A1 I put whatever date I'm looking for. Off to the side (D1) I entered: =VLOOKUP($A$1,$A$5:$A$375,1,0)-(A5-1)+4 VLOOKUP(A1,$A$5:$A$375,1,1) finds the date you're looking for. -(A5-1) subtracts the day before the first date on the list FROM the date found. +4 adds in the four rows above the range. The result is the row number of the date you're looking for. A simpler formula: =MATCH($a$1,$a$5:$a$375,0)+row($a$5)-1 MATCH returns the offset into the array (so if $a$1 = $a$5, MATCH would return 1), and row($a$5)-1 adjusts it to give the absolute row. The reason I do it this way is that if you name the array (e.g. name it YearRange), it works as follows: =MATCH($a$1,YearRange,0)+row(YearRange)-1 So you don't need to know what row your array starts on to write the formula. Jim -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
