Re: [libreoffice-users] Pasting Foreign Language
Hi Jerry, Jerry Rémy schrieb: Dear LibreOffice Team, I would like to receive a liberating solution from the team related to non-English languages. As I pasted an external source written in French into Libre Office I get an unusual result: Tu Útais en ╔den, le jardin de Dieu; Tu Útais couvert de toute espÞce de pierres prÚcieuses, De sardoine, de topaze, de diamant, De chrysolithe, d'onyx, de jaspe, De saphir, d'escarboucle, d'Úmeraude, et d'or; Tes tambourins et tes fl¹tes Útaient Ó ton service, PrÚparÚs pour le jour o¨ tu fus crÚÚ. Original Text: Tu étais en Éden, le jardin de Dieu; Tu étais couvert de toute espèce de pierres précieuses, De sardoine, de topaze, de diamant, De chrysolithe, d'onyx, de jaspe, De saphir, d'escarboucle, d'émeraude, et d'or; Tes tambourins et tes flûtes étaient à ton service, Préparés pour le jour où tu fus créé. As you can see, every accented letter is replaced either with capitalized letters or some other symbol. Please help! Thank you for your prompt understanding and response to the matter at hand. This kind of errors are typical for a wrong encoding. Please tell us into which part of LibreOffice you try to paste the text. The ways to correct the encoding are different. Which operating system do you use? Which application has generated the text? Kind regards Regina -- 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
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: Pasting Foreign Language
Jerry Rémy: As you can see, every accented letter is replaced either with capitalized letters or some other symbol. It can happen when you paste the text from a badly made PDF file; in that case there's no easy solution except search-and-replace. -- 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 :) No worries! It was good to hear from you and also good to get a chuckle on a day which is otherwise quite depressing or annoying for a lot of people. Plus, i had been taking the initial post wy too seriously before you pointed out 'the obvious'. Then, to cheer myself up further, i looked for BolgenOS. Apparently the story has moved on. It started years ago with a Russian school-kid forking Ubuntu and replacing all the logos with his own one, allegedly including for 3rd party apps such as Firefox (although i can't quite believe that bit and you'll see why). When he presented it to his IT Tutor as all his own work (which i also have trouble believing but lets not mess-up the story!) the tutor really believed the kid had really knocked Microsquish for six. The national news covered the story with a mini-documentary about how this kid had apparently knocked-up something that rivalled MS Windows and further exaggerated it that he'd done it over a couple weeks holiday, or maybe just a weekend! Then the national school board 'looked into it' and got so excited about it that they were allegedly keen to roll it out across all schools across the nation after first test-driving it in a few districts. Apparently BolgenOS continues but now admits to being a fork and has put the relevant logos back. There are some claims that the community has reached around 10 million people but having looked at the site i find that hard to believe. The main thing is that it seems to still be supported and has followers. When my mum went to college she was set an assignment to write a short ditty for music classes. Suddenly a short refrain popped into her head that she couldn't recognise it from anywhere so she wrote it down quickly and handed it in and got a B + for it. Later the teacher played it and my mum was shocked to hear it was Beethoven's 5th, well maybe not that one as it's the number 1 most easily recognisable piece and even says it's own name over and over again in the music, but something along those lines. My mum went a bit red but none of the other music students recognised it and neither did the teacher!!! The bit i find most amusing is that the music teacher thought Beethoven (or whoever) was only worthy of a B+. Obviously a LOT of people were upset about the BolgenOS story but for me the most upsetting part was that 1. an IT Tutor had no idea about non-MS OSes. Even if he/she was a more generic science teacher i'd have hoped for a little less ignorance! That national news put the work into filming a mini-documentary but failed to do any kind of research into trying to find similar examples is no surprise. There ARE a lot of good journos out there but sensationalism seems more profitable most of the time. 2. That the school-boards might flee back to MS to avoid the embarrassment rather than latch onto the stronger OSes that have better support-structures. Of course the Russian and other space-programmes are largely built on unix and unix-based platforms, certainly for their commandcontrol critical systems. Amusingly on the space station they occasionally have to send up someone to fix all the astronaughts/cosmonaughts laptops and free them from viruses, malware etc. Apparently at least once all the laptops went down due to malware. However none of the commandcontrol systems have needed as much as a reboot in all the decades they have been up there. There was some talk of the laptops going over to Linux too but i dunno if it ever happened. Regards from Tom :) On 26 December 2013 05:57, Robert Holtzman hol...@cox.net wrote: On Wed, Dec 25, 2013 at 10:53:28PM +, Tom Davies wrote: Hi :) I don't think it's good policy to be rude to trolls. One of the things they are aiming for is to make the list seem unfriendly and then be able to quote those examples out-of-context. As I said at the top of my reply, I seldom reply to FUD but I had time on my hands and was bored. Beside, sometimes I just like to declare open season on trolls. ..snip. -- 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-accessibility] Re: [libreoffice-users] help
Hi, Am So, 22.12.2013, 04:49 schrieb tk: Christophe Strobbe wrote: Probably, the only way to make odt2braille accessible is rewriting it entirely in C++ in order to embed it into OpenOffice and LibreOffice instead of installing it as an extension. So far, no one has offered to do this. The real issue is that one can not select the writing system from within LibO. Do that, and ODT2name-your-A11Y-writing-system is instantly irrelevant,and thus obsolete. I don't see the relevance of the writing system to the accessibility-related limitations of the extensions API. Can you elaborate on that? The writing system is typically set at the OS level. (Setting the language of a document or of part of a document to a non-Western language is tricky in LibreOffice and OpenOffice, but that was not what the original question was about.) Best regards, Christophe jonathon -- Sent from the eating establishment at the Far side of the Universe, at the begining of Time, and at the end of Space. -- To unsubscribe e-mail to: accessibility+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/accessibility/ All messages sent to this list will be publicly archived and cannot be deleted -- Christophe Strobbe Akademischer Mitarbeiter Adaptive User Interfaces Research Group Hochschule der Medien Nobelstraße 10 70569 Stuttgart Tel. +49 711 8923 2749 -- 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] Trying to get possible bug info
On 25 December 2013 21:25, Tom Davies tomc...@gmail.com wrote: Hi :) Sounds like you are looking for advanced debugging information https://wiki.documentfoundation.org/QA/BugReport/Debug_Information but that is beyond the scope of average users so most people are better off just working through the kind of stuff you have already been doing and other things from on this page https://wiki.documentfoundation.org/QA/BugReport (note the link to the advanced page is at the bottom). Errr, the advanced page is beyond me so hopefully you can figure it out or Jay or someone can help with it. Good luck and regards from Tom :) Thanks for the info. -- *rob* -- 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] Trying to get possible bug info
On 25 December 2013 20:39, Jay Lozier jsloz...@gmail.com wrote: Hi, Does your spreadsheet have a large number of calculations and referrals that periodically take a long time to run? Thanks for the reply. Spreadsheet is simple but over 4 years old. There is just a daily entry, calculation of cost of entry, monthly totals. There are 7 sheets covering different periods of time since 2009. Also, can you post the spreadsheet to Nabble? Please do not post anything proprietary or private. I'll consider doing that. Thanks -- *rob* -- 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 Stop Automatic Capitalization?
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 -- 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] 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
Re: [libreoffice-users] How to Stop Automatic Capitalization?
On 26 December 2013 08:45, John Meyer johnme...@pueblocomputing.com wrote: 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. Alternately, Tools-AutoCorrect Options-Exceptions -- and choose which words/abbreviations should NOT trigger a capital letter on the next word. -- T. R. Valentine A rich heart may be under a poor coat. -- 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] How to Stop Automatic Capitalization?
2013/12/26 T. R. Valentine trvalent...@gmail.com On 26 December 2013 08:45, John Meyer johnme...@pueblocomputing.com wrote: 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. Alternately, Tools-AutoCorrect Options-Exceptions -- and choose which words/abbreviations should NOT trigger a capital letter on the next word. Also, you can Ctrl+Z autocorrect, right after it capitalize the letter. It works for (almost?) all autocorrect (changing -- to ̶, -- to arrows, etc.) -- 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: Platform Support
Hello, LO on Android is experimental for the moment. You'll find more information here: https://wiki.documentfoundation.org/LibreOffice_on_Android Julien -- View this message in context: http://nabble.documentfoundation.org/Platform-Support-tp4089573p4089756.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] Trying to get possible bug info
Hi :) We all get all messages to the list so you can respond to more than 1 person in a single post. If you are specifically talking to just one person in 1 paragraph and then another in the next you could use @ signs, for example @Tom blah, blah @Jay blah de blah @Everyone blah I don't know why we don't do that sort of thing on this mailing list but i've seen it a lot in other projects. I gather that gwibber or twitter or something uses something similar for their main addresses so it might get confusing for some people. Maybe that's why i haven't seen it here much. Until my recent move to GMail i would only see 1 message at a time so i would reply to each individual one. It's taking me a looong while to get used to the much more sophisticated approach of threaded mailings but its' helped me cut down on traffic quite a lot! Since you are running into problems with the old spreadsheet might it be worth considering 1. starting a fresh new one and then 2. copypaste or import by Csv only the data you really need access to most often and 3. keeping the old file as an archive to refer to. I found that when moving from 3.3.x branch to 3.4, and again from somewhere around 3.4.x to the next ones, sometimes weird little hitches happened that were smoothed out by starting afresh. Maybe it's because so many forks of LibreOffice merged at around that time because i've not found similar issues with any upgrades since then. Of course it could have been just my imagination or unfamiliarity with LibreOffice because i hadn't used it much before the forking. With Excel i found that spreadsheets over around 5 sheets tended to become a but unwieldy (people couldn't cope with the tabs disappearing under the scroll-bar or having the scroll-bar so short) so i would either break them up (the spreadsheets, not the people) or convert them to databases depending on which seemed more appropriate and/or easier. So there are 2 good(ish) and probably many other good reasons for breaking up the spreadsheet but doubtless there are many good reasons to keep all your data together! So it's just a suggestion that might well not be possible. Regards from Tom :) On 26 December 2013 14:31, Robin rc.rattusrat...@gmail.com wrote: On 25 December 2013 20:39, Jay Lozier jsloz...@gmail.com wrote: Hi, Does your spreadsheet have a large number of calculations and referrals that periodically take a long time to run? Thanks for the reply. Spreadsheet is simple but over 4 years old. There is just a daily entry, calculation of cost of entry, monthly totals. There are 7 sheets covering different periods of time since 2009. Also, can you post the spreadsheet to Nabble? Please do not post anything proprietary or private. I'll consider doing that. Thanks -- *rob* -- 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] Pasting Foreign Language
Hi :) His OS is Linux Mint 16 (Debian family, just as Ubuntu is so they use the same commands fwiw) but i didn't think to ask about any of the other things. Regards from Tom :) On 26 December 2013 12:20, Regina Henschel rb.hensc...@t-online.de wrote: Hi Jerry, Jerry Rémy schrieb: Dear LibreOffice Team, I would like to receive a liberating solution from the team related to non-English languages. As I pasted an external source written in French into Libre Office I get an unusual result: Tu Útais en ╔den, le jardin de Dieu; Tu Útais couvert de toute espÞce de pierres prÚcieuses, De sardoine, de topaze, de diamant, De chrysolithe, d'onyx, de jaspe, De saphir, d'escarboucle, d'Úmeraude, et d'or; Tes tambourins et tes fl¹tes Útaient Ó ton service, PrÚparÚs pour le jour o¨ tu fus crÚÚ. Original Text: Tu étais en Éden, le jardin de Dieu; Tu étais couvert de toute espèce de pierres précieuses, De sardoine, de topaze, de diamant, De chrysolithe, d'onyx, de jaspe, De saphir, d'escarboucle, d'émeraude, et d'or; Tes tambourins et tes flûtes étaient à ton service, Préparés pour le jour où tu fus créé. As you can see, every accented letter is replaced either with capitalized letters or some other symbol. Please help! Thank you for your prompt understanding and response to the matter at hand. This kind of errors are typical for a wrong encoding. Please tell us into which part of LibreOffice you try to paste the text. The ways to correct the encoding are different. Which operating system do you use? Which application has generated the text? Kind regards Regina -- 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] Pasting Foreign Language
Hi :) From a quick off-list chat it seems the fault is some weird clash with the 3rd party application that is being copied from. Apparently if the text is first pasted into GEdit or some other intermediary app (such as email client) and then pasted into LibreOffice it all works fine. So i would hazard a guess that there is some weird formatting marks or tags involved. So, to dodge needing another 3rd party app and to get it down to a single step maybe try Ctrl Shift v rather than just Ctrl v to paste and then select paste as unformatted text. The shift key makes the paste into Paste Special which is prolly in the menus somewhere but it's usually easier to use the keyboard combination. Actually a LOT of times when i paste into LibreOffice i use the unformatted text option, particularly when copying from documents in MS formats because otherwise all sorts of weird nasties seem to come along for the ride. Regards from Tom :) On 26 December 2013 06:09, Doug dmcgarr...@optonline.net wrote: On 12/25/2013 06:37 PM, Jerry Rémy wrote: Dear LibreOffice Team, I would like to receive a liberating solution from the team related to non-English languages. As I pasted an external source written in French into Libre Office I get an unusual result: Tu Útais en ╔den, le jardin de Dieu; Tu Útais couvert de toute espÞce de pierres prÚcieuses, De sardoine, de topaze, de diamant, De chrysolithe, d'onyx, de jaspe, De saphir, d'escarboucle, d'Úmeraude, et d'or; Tes tambourins et tes fl¹tes Útaient Ó ton service, PrÚparÚs pour le jour o¨ tu fus crÚÚ. Original Text: Tu étais en Éden, le jardin de Dieu; Tu étais couvert de toute espèce de pierres précieuses, De sardoine, de topaze, de diamant, De chrysolithe, d'onyx, de jaspe, De saphir, d'escarboucle, d'émeraude, et d'or; Tes tambourins et tes flûtes étaient à ton service, Préparés pour le jour où tu fus créé. As you can see, every accented letter is replaced either with capitalized letters or some other symbol. Please help! Thank you for your prompt understanding and response to the matter at hand. I just took the original text that you posted above and pasted it into LibreOffice. It came up the first time in typewriter font, with all the accents. Then I highlighted that and set the font to Times New Roman, and it came up in TNR, with all the accents. I suspect that you are not using a font that has the accented characters in it. Try changing the font. Or see if you can download the Microsoft TrueType fonts-- I'm pretty sure they have all the common accents available. This was copied back from LO, when it used the typewriter font. Tu étais en Éden, le jardin de Dieu; Tu étais couvert de toute espèce de pierres précieuses, De sardoine, de topaze, de diamant, De chrysolithe, d'onyx, de jaspe, De saphir, d'escarboucle, d'émeraude, et d'or; Tes tambourins et tes flûtes étaient à ton service, Préparés pour le jour où tu fus créé. And this was copied back after I turned it into Times New Roman: Tu étais en Éden, le jardin de Dieu; Tu étais couvert de toute espèce de pierres précieuses, De sardoine, de topaze, de diamant, De chrysolithe, d'onyx, de jaspe, De saphir, d'escarboucle, d'émeraude, et d'or; Tes tambourins et tes flûtes étaient à ton service, Préparés pour le jour où tu fus créé. I don't know if the example will survive email, but it is in Times New Roman here, in my Thunderbird email ready to send. --doug -- 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] Cooperation in the implementation of LibreOffice
On Thu, Dec 26, 2013 at 12:11:30PM +, Tom Davies wrote: Hi :) No worries! It was good to hear from you and also good to get a chuckle on a day which is otherwise quite depressing or annoying for a lot of people. Plus, i had been taking the initial post wy too seriously before you pointed out 'the obvious'. No problem. Actually, I like to see stuff like this occasionally. It breaks up the monotony. ...snip.. Obviously a LOT of people were upset about the BolgenOS story but for me the most upsetting part was that 1. an IT Tutor had no idea about non-MS OSes. Even if he/she was a more generic science teacher i'd have hoped for a little less ignorance! That's common in the school systems. There's a story circulating about a principal who reamed some kid for using linux, telling him that that's a hacker's OS. Yeah, it makes me livid too. ...snip... Take care. -- 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] rounding problem with Base
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. Thanks -- 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
[libreoffice-users] LO Bug report
Hi All, I came across this one on the bugzilla. I can confirm what David reports. I opened the doc in word and I could see the contents (that is, an index). Open in LO (portable or 4.1.4.2 under Fedora) and you can only see the first 2 lines. I went back to word, saved the docx as .doc to see whether that made a difference in LO. Nope. Any ideas? I am sure I have seen instances before of indexes disappearing when transferred from word to LO. I notice his doc only shows the index even when viewed in word - assuming that is intentional. Cheers https://bugs.freedesktop.org/show_bug.cgi?id=73002 -- 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] rounding problem with Base
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