[libreoffice-users] security warning AOO
Today, following mail was distributed from annou...@openoffice.apache.org. Can LibO users face the same threat? QUOTE CVE-2015-1774 OpenOffice HWP Filter Remote Code Execution and Denial of Service Vulnerability A vulnerability in OpenOffice's HWP filter allows attackers to cause a denial of service (memory corruption and application crash) or possibly execution of arbitrary code by preparing specially crafted documents in the HWP document format. Severity: Important Vendor: The Apache Software Foundation Versions Affected: All Apache OpenOffice versions 4.1.1 and older are affected. Mitigation: Apache OpenOffice users are advised to remove the problematic library in the program folder of their OpenOffice installation. On Windows it is named hwp.dll, on Mac it is named libhwp.dylib and on Linux it is named libhwp.so. Alternatively the library can be renamed to anything else e.g. hwp_renamed.dll. This mitigation will drop AOO's support for documents created in Hangul Word Processor versions from 1997 or older. Users of such documents are advised to convert their documents to other document formats such as OpenDocument before doing so. Apache OpenOffice aims to fix the vulnerability in version 4.1.2. Credits: Thanks to an anonymous contributor working with VeriSign iDefense Labs. UNQUOTE -- 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] selecting cells in calc sheet
Correction. I ran across an old message from Mr Barker that suggested using the OFFSET() function for something. -- Jim -Original Message- From: James E Lang jim+...@lang.hm To: pete nikolic pg.nikol...@gmail.com, LibreOffice Users users@global.libreoffice.org Sent: Sat, 25 Apr 2015 15:03 Subject: Re: [libreoffice-users] selecting cells in calc sheet You're in business. The AVERAGE() function does the same thing as the SUM() function divided by the COUNT() function. I would use AVERAGE() as it is cleaner (more streamlined). I'm glad I could help. I use the OFFSET() function myself to dynamically define ranges of cells. If somebody knows a better technique I hope they will chime in. I've never seen anyone else post a practical use for this function but for me, any spreadsheet program that lacks support for it fails to gain my acceptance. -- Jim -Original Message- From: pete nikolic pg.nikol...@gmail.com To: James E Lang jim+...@lang.hm Sent: Sat, 25 Apr 2015 12:17 Subject: Re: [libreoffice-users] selecting cells in calc sheet On Sat, 25 Apr 2015 11:46:23 -0700 James E Lang jim+...@lang.hm wrote: The main thing I'm not understanding is whether the formula is to be one fixed place or if after 3 data points it is in cell X but after 4 data points it is in cell Y. The solution I gave you applies to the latter case. For the former case I would use a more complex formula like this using your latest specification. =IF(COUNT(A1:A50)2,AVERAGE(OFFSET(A1,0,COUNT(A1:A50)-3,1,3)-30,) That says, if there are more than two values then define a horizontal range composed of the last three filled cells, average that range, and subtract 30. This works as long as they are no empty or text cells before the values of interest in A1:A50. This process gets a little bit (to say the least) more hairy if there are intervening cells. Hi Jim .. Right this is looking promissing the actual location of the formula /result will be in a separate cell on the same row but outside the range of entered values it will also be copied to the next 30 or so rows below and edited to suit where needed . one other thing you have it averaging the cells they need to be added together then divided by 3 unless the average function does the same thing Thanks Pete . -- Illegitimi non carborundum . ro for the purists out there Noli nothis permittere te terere. -- 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] security warning AOO
2015-04-26 11:47 GMT+02:00 Italo Vignoli it...@libreoffice.org: LibreOffice 4.3.7, released yesterday, and LibreOffice 4.4.2, available since early April, include a patch for the issue, and therefore offer a real solution to the problem (and not a workaround). On 26/04/15 11:31, rost52 wrote: Today, following mail was distributed from annou...@openoffice.apache.org. Can LibO users face the same threat? QUOTE CVE-2015-1774 OpenOffice HWP Filter Remote Code Execution and Denial of Service Vulnerability A vulnerability in OpenOffice's HWP filter allows attackers to cause a denial of service (memory corruption and application crash) or possibly execution of arbitrary code by preparing specially crafted documents in the HWP document format. Severity: Important Vendor: The Apache Software Foundation Versions Affected: All Apache OpenOffice versions 4.1.1 and older are affected. Mitigation: Apache OpenOffice users are advised to remove the problematic library in the program folder of their OpenOffice installation. On Windows it is named hwp.dll, on Mac it is named libhwp.dylib and on Linux it is named libhwp.so. Alternatively the library can be renamed to anything else e.g. hwp_renamed.dll. This mitigation will drop AOO's support for documents created in Hangul Word Processor versions from 1997 or older. Users of such documents are advised to convert their documents to other document formats such as OpenDocument before doing so. Apache OpenOffice aims to fix the vulnerability in version 4.1.2. -- Italo Vignoli - Marketing PR mobile +39.348.5653829 - email / jabber it...@libreoffice.org hangout / jabber italo.vign...@gmail.com - skype italovignoli GPG Key ID - 0xAAB8D5C0 DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0 Thanks, Italo - good to know that the LibO devs were on to this one !... [?] Henri -- 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] display
On 2015/04/25 2:10, M Henri Day wrote: 2015-04-22 17:17 GMT+02:00 Thomas Blasejewicz ny...@hb.tp1.jp mailto:ny...@hb.tp1.jp: Computer: just bought a new one, running Windows 8.1 (= a nightmare!!!), 8 GB RAM, 120 GB SSD = OS + 1 TB HDD and probably a whole lot of fancy high-tech stuff I not capable of understanding. So, I would LOVE to believe, that there cannot be any sort of insufficient power. IS there a trick to convince the display to work smoothly??? Thank you. Thomas Thomas, this is a tad off-topic, but since you mentioned that «Windows 8.1 (= a nightmare !!!)», I thought I'd suggest two simple steps to tame the beast : 1. Install Classic Shell from *classicshell.net http://classicshell.net* (elect the Windows 7 interface and change the start button), and 2. Deactivate the superfluous Lockscreen by following the steps found here : *_http://www.howtogeek.com/134620/how-to-disable-the-lock-screen-on-windows-8-without-using-group-policy_*/*_/_*/ While not, alas, quite as good as dumping Windows altogether and installing, e g, Linux Mint 17.1 instead, it should suffice to turn those nightmares into relatively sweet dreams. I know it has for many retirees here in Stockholm whom we help with computer problems Henri/**/ Thank you! Actually, I am trying already for more than 7 years to get friendly with Linux and by now can install the OS. Every further step results in trouble ... -- 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] display
On 2015/04/24 23:30, Paul D. Mirowsky wrote: Try here: http://www.intel.com/support/graphics/sb/CS-034107.htm On 4/23/2015 2:24 PM, Thomas Blasejewicz wrote: On 2015/04/23 23:06, Paul D. Mirowsky wrote: Screen tearing issue with NVidia may be resolved by changing Vertical Sync to Adaptive. Start video at URL below at 40 seconds. https://www.youtube.com/watch?v=mFRpnQ09_LA The video is from 2013 and may not quite match, but you get the idea. Hope this helps. Am I correct assuming, that this applies ONLY to NVidia graphic cards? My computer has an Intel HD Graphics 4600 and I cannot find anywhere a setting called vertical sync Thomas Thank you. That link helped me to understand the situation better AND how to get to the setting of my graphics card. However, changing the settings related to vertical sync, I believe I can choose between TWO, does NOT help. The screen tearing still happens as before. Now I have all that super power all over the place and still constantly have to switch between two LO documents (could not yet find the shortcut key for minimizing the window) to be able to have a look at my text. Is there anything else I could try? Thomas -- 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] security warning AOO
LibreOffice 4.3.7, released yesterday, and LibreOffice 4.4.2, available since early April, include a patch for the issue, and therefore offer a real solution to the problem (and not a workaround). On 26/04/15 11:31, rost52 wrote: Today, following mail was distributed from annou...@openoffice.apache.org. Can LibO users face the same threat? QUOTE CVE-2015-1774 OpenOffice HWP Filter Remote Code Execution and Denial of Service Vulnerability A vulnerability in OpenOffice's HWP filter allows attackers to cause a denial of service (memory corruption and application crash) or possibly execution of arbitrary code by preparing specially crafted documents in the HWP document format. Severity: Important Vendor: The Apache Software Foundation Versions Affected: All Apache OpenOffice versions 4.1.1 and older are affected. Mitigation: Apache OpenOffice users are advised to remove the problematic library in the program folder of their OpenOffice installation. On Windows it is named hwp.dll, on Mac it is named libhwp.dylib and on Linux it is named libhwp.so. Alternatively the library can be renamed to anything else e.g. hwp_renamed.dll. This mitigation will drop AOO's support for documents created in Hangul Word Processor versions from 1997 or older. Users of such documents are advised to convert their documents to other document formats such as OpenDocument before doing so. Apache OpenOffice aims to fix the vulnerability in version 4.1.2. -- Italo Vignoli - Marketing PR mobile +39.348.5653829 - email / jabber it...@libreoffice.org hangout / jabber italo.vign...@gmail.com - skype italovignoli GPG Key ID - 0xAAB8D5C0 DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0 -- 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: Libre Calc - moving text in cell + comparison chart
Am 26.04.2015 um 20:31 schrieb charles meyer: Hi Folks, I’m learning the function keys between MS Excel and Libre Calc work quite differently. In Excel if you wish text in a cell to return to the next line in that cell, you choose Ctrl + Enter. That’s doesn’t seem to work in Libre Calc. Could you please share how that is done in Libre Calc? Has anyone happened upon any comparison chart showing how to accomplish certain functions in Libre Calc compared with how you perform them in MS Excel? MS has shared that with MS Word and WordPerfect so if you’re transitioning into MS Word you can acclimate easier. Thanks so much! Charles. Excel: Alt+Enter Calc: Ctrl+Enter -- 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] Libre Calc - moving text in cell + comparison chart
Ctrl+Enter does the job for as long as I can remember in the LibreOffice/OpenOffice.org Calc product line. -- Jim -Original Message- From: charles meyer reachmepl...@gmail.com To: users@global.libreoffice.org Sent: Sun, 26 Apr 2015 11:33 Subject: [libreoffice-users] Libre Calc - moving text in cell + comparison chart Hi Folks, I’m learning the function keys between MS Excel and Libre Calc work quite differently. In Excel if you wish text in a cell to return to the next line in that cell, you choose Ctrl + Enter. That’s doesn’t seem to work in Libre Calc. Could you please share how that is done in Libre Calc? Has anyone happened upon any comparison chart showing how to accomplish certain functions in Libre Calc compared with how you perform them in MS Excel? MS has shared that with MS Word and WordPerfect so if you’re transitioning into MS Word you can acclimate easier. Thanks so much! Charles. -- 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] Libre Calc - moving text in cell + comparison chart
At 14:31 26/04/2015 -0400, Charles Meyer wrote: I'm learning the function keys between MS Excel and Libre Calc work quite differently. In Excel if you wish text in a cell to return to the next line in that cell, you choose Ctrl + Enter. I think you are a bit confused here! In Microsoft Excel, Ctrl+Enter is used in place of Enter to complete an entry when you have selected a range of cells and want them all populated with the same entry. In Excel, if you want to create a manual line break within a cell, you use Alt+Enter, not Ctrl+Enter. That doesn't seem to work in Libre Calc. Could you please share how that is done in Libre Calc? To add to the confusion, Ctrl+Enter is precisely how you achieve the same thing in Calc! But this works only in the cell, not in the Input Line. And - you've guessed it! - Alt+Enter is how you perform multiple insertions. The two keyboard shortcuts swap their effects between Excel and Calc, that is. Has anyone happened upon any comparison chart showing how to accomplish certain functions in Libre Calc compared with how you perform them in MS Excel? https://wiki.openoffice.org/wiki/Documentation/UserGuide/Migration_Guide/Calc_and_Excel is written for OpenOffice and may or may not be helpful. It's part of OpenOffice's Migration Guide. I trust this helps. Brian Barker -- 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] Libre Calc - moving text in cell + comparison chart
Hi Folks, I’m learning the function keys between MS Excel and Libre Calc work quite differently. In Excel if you wish text in a cell to return to the next line in that cell, you choose Ctrl + Enter. That’s doesn’t seem to work in Libre Calc. Could you please share how that is done in Libre Calc? Has anyone happened upon any comparison chart showing how to accomplish certain functions in Libre Calc compared with how you perform them in MS Excel? MS has shared that with MS Word and WordPerfect so if you’re transitioning into MS Word you can acclimate easier. Thanks so much! Charles. -- 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] Libre Calc - moving text in cell + comparison chart
charles meyer wrote: Hi Folks, I’m learning the function keys between MS Excel and Libre Calc work quite differently. In Excel if you wish text in a cell to return to the next line in that cell, you choose Ctrl + Enter. That’s doesn’t seem to work in Libre Calc. Could you please share how that is done in Libre Calc? Has anyone happened upon any comparison chart showing how to accomplish certain functions in Libre Calc compared with how you perform them in MS Excel? MS has shared that with MS Word and WordPerfect so if you’re transitioning into MS Word you can acclimate easier. Thanks so much! Charles. On my Mac it works with Cmd-Enter. Which is kind of strange as Cmd-Enter inserts a page break in Writer, whereas in Writer both Ctrl-Enter and Shift-Enter insert a newline, even in table cells. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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