Re: [libreoffice-users] How to Stop Automatic Capitalization?
Many thanks! jl -Original Message- From: John Meyer johnme...@pueblocomputing.com To: users users@global.libreoffice.org Sent: Thu, Dec 26, 2013 11:51 pm Subject: Re: [libreoffice-users] How to Stop Automatic Capitalization? On 12/26/2013 7:33 AM, Jonathan Levi wrote: Can someone please explain to me how I change LO's insistence on capitalizing words following a period, even if I don't want it? (i.e., Yest. evening is replaced by Yest. Evening.) TIA, Jonathan Tools-Autocorrect Options-Options-Uncheck Capitalize first letter of every sentence. -- 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
[SOLVED] [libreoffice-users] rounding problem with Base
On Fri, 27 Dec 2013 01:30:27 +0100 Ivan Sergio Borgonovo m...@webthatworks.it wrote: It seems I just had to adjust the format of the column of the query once the query is run. Right click on the query result column and chose format. On Thu, 26 Dec 2013 21:41:48 +0100 Ivan Sergio Borgonovo m...@webthatworks.it wrote: I've a rounding or maybe display format problem with base. I'm making computations with NUMERIC(30, 2) I've a query (let's name it query1) that do some computation on numeric columns something like: SELECT SUM(c1 * c2 / c3) as s1 , SUM(c4 * c5 / c6) as s2 FROM table1 GROUP BY c0; This query actually returns several rows that have the precision I need. Then I've query as: SELECT SUM(s1 * s1) as ss1 from query1; SELECT SUM(s2) as ss2 from query1; And they return result in scientific notation with just 2 decimal visible 6,23E+015 When I try to do further computations with ss1 and ss2 I get 0 with NO decimal digits. When I import query1 in localc and do the sum and squaring and further computation there I can get the precision I need. I've been playing around with column definition, increasing decimal point in numerics and nothing changed. I couldn't see the number of decimals increase in any step of my computation. It seems related to: http://nabble.documentfoundation.org/rounding-off-number-results-in-Base-td4056773.html that's pretty an old problem and I couldn't find any workaround. This looks pretty critical I'm running: Version: 4.1.4.2 Build ID: 410m0(Build:2) in sid -- Ivan Sergio Borgonovo http://www.webthatworks.it -- 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: [SOLVED] [libreoffice-users] rounding problem with Base
Hi :) Are you saying you have solved this problem yourself without help from the list or has the problem just changed a bit? Regards from Tom :) On 27 December 2013 13:02, Ivan Sergio Borgonovo m...@webthatworks.it wrote: On Fri, 27 Dec 2013 01:30:27 +0100 Ivan Sergio Borgonovo m...@webthatworks.it wrote: It seems I just had to adjust the format of the column of the query once the query is run. Right click on the query result column and chose format. On Thu, 26 Dec 2013 21:41:48 +0100 Ivan Sergio Borgonovo m...@webthatworks.it wrote: I've a rounding or maybe display format problem with base. I'm making computations with NUMERIC(30, 2) I've a query (let's name it query1) that do some computation on numeric columns something like: SELECT SUM(c1 * c2 / c3) as s1 , SUM(c4 * c5 / c6) as s2 FROM table1 GROUP BY c0; This query actually returns several rows that have the precision I need. Then I've query as: SELECT SUM(s1 * s1) as ss1 from query1; SELECT SUM(s2) as ss2 from query1; And they return result in scientific notation with just 2 decimal visible 6,23E+015 When I try to do further computations with ss1 and ss2 I get 0 with NO decimal digits. When I import query1 in localc and do the sum and squaring and further computation there I can get the precision I need. I've been playing around with column definition, increasing decimal point in numerics and nothing changed. I couldn't see the number of decimals increase in any step of my computation. It seems related to: http://nabble.documentfoundation.org/rounding-off-number-results-in-Base-td4056773.html that's pretty an old problem and I couldn't find any workaround. This looks pretty critical I'm running: Version: 4.1.4.2 Build ID: 410m0(Build:2) in sid -- Ivan Sergio Borgonovo http://www.webthatworks.it -- 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
[libreoffice-users] Finding data validation cells
Is there a way to find all cells in a spreadsheet which have data validity applied to them? I'm familiar with Mark Invalid Data but want to find all cells with data validity configured regardless of whether: there is data in the cell and, if so, whether it is valid or not. Thanks for your help. -- View this message in context: http://nabble.documentfoundation.org/Finding-data-validation-cells-tp4089791.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] Cooperation in the implementation of LibreOffice
On Thu, Dec 26, 2013 at 08:24:48PM +, Tom Davies wrote: Hi :) Ahh, i love to see these urban myths grow. ...snip.. Wow! Never realized it was an urban legendhowever, it's only that if it *never* happened. Any info on that? -- Bob Holtzman Your mail is being read by tight lipped NSA agents who fail to see humor in Doctor Strangelove Key ID 8D549279 -- 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] What do you think of AndrOpenOffice? (nm)
Jeff Deutsch Speaker Life Coach A SPLINT - ASPies LInking with NTs http://www.asplint.com Listen to the universe while it whispers before it has to shout. Marion Grobb Finkelstein, Communication Catalyst -- http://www.MarionSpeaks.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] Cooperation in the implementation of LibreOffice
Hi :) Sorry! I've been a total moron with that and other recent posts haven't i :( Sorry about that! Apols and regards from Tom :) On 27 December 2013 18:16, Robert Holtzman hol...@cox.net wrote: On Thu, Dec 26, 2013 at 08:24:48PM +, Tom Davies wrote: Hi :) Ahh, i love to see these urban myths grow. ...snip.. Wow! Never realized it was an urban legendhowever, it's only that if it *never* happened. Any info on that? -- Bob Holtzman Your mail is being read by tight lipped NSA agents who fail to see humor in Doctor Strangelove Key ID 8D549279 -- 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] spell checker
I seem to have it on writer, does the same apply to drawing? I have found that changing the speller to US on all text is working. Thanks, hopefully it continues to be consistent. --- Amanda Sloan On 27/12/2013 11:52, Tom Davies wrote: Hi :) Sorry that only got to me privately. The mailing list got messed up a while ago so that nowadays people have to use Reply to all or Group reply or Reply to list (depending on which email client they use) rather than the straight-forwards Reply which almost everyone uses for almost everything. Could you forwards your reply to the mailing list? Users@Global.LibreOffice.Org I don't have much idea about how to move forwards with this issue but someone else on the mailing list probably will. Apols and regards from Tom :) On 27 December 2013 00:29, Amanda Sloan amanda.sl...@vodafone.co.nz wrote: Yes they all look good as described the settings. The ones that were originally MS Word docs do work. The ones that are Libre office only don't, and also even if they have been changed to word docs they don't. In saying that there is a one that's been changed to MS word that does. So theres not a definite pattern. I've downloaded it lots etc, sometimes it works for a litte while too. Thanks --- Amanda Sloan On 26/12/2013 00:09, Tom Davies wrote: Hi :) Try this and let us know what happens. Open one of the ones it doesn't work for and go to Tools - Options - Language Settings - Writing Aids and have a look in the top 2 boxes to make sure the settings look sensible, The main one is top of the top box, make sure the spell checker is ticked. It might be interesting to compare what is different about the ones the spell-checker does work for, Not just in the settings but also is it certain formats, such as maybe some MS Word documents don't work but it seems like native ODF ones do? Regards from Tom :) On 26 December 2013 00:12, Amanda Sloan amanda.sl...@vodafone.co.nz wrote: Hello I have Windows 8 and Libre office 4.1. I am needing the spellchecker to work. It does on some things and not on others. Can you help please, because otherwise its excellent. Thanks -- Amanda Sloan -- 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
[libreoffice-users] Re: Issues downloading LibreOffice Portable
Portable LibreOffice works fine and don't have any language problem. The web site offers two variants. One with a restricted assortment of languages (that you mentioned) and another one with all the languages. At installation time you are asked to select a language. On second start, LO deletes the unneeded languages, except those languages that comes with the software and are global extensions. -- 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