Re: [libreoffice-users] Help with VLOOKUP requested
Budge, Le 21/07/2017 à 12:15, Budge a écrit : I have a formula VLOOKUP(E2,Sheet2.A2:B690,2,0) in cell J2 which fills in J2 with the value corresponding to the number in E2 which is looked up from a table in sheet2. My problem is that when I copy this formula down column J the E2 changes to E3 which is correct, but the table defined by Sheet2.A2:B690, which should be fixed, has the addresses changed also. How may I fix the lookup table when I copy the file down a column please? Add "$" symbols where it pertains. In your case, your formula should look like: VLOOKUP(E2,Sheet2.$A$2:$B$690,2,0) Note that, when entering a formula, the F4 key (newer versions of LO) or Shift+F4 combination (older versions) could help. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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: LibreOffice Base crashes unexpected
On 07/21/2017 08:36 AM, Alexander Thurgood wrote: Le 21/07/2017 à 16:55, Lumaja a écrit : Check your kernel version and the Ubuntu Launchpad bug report : https://bugs.launchpad.net/ubuntu/+source/linux/+bug/1699772 and also: https://bugs.documentfoundation.org/show_bug.cgi?id=108619 Alex Greetings, I got this link from a responder to my LinuxQuestions.org posting about this matter: https://lkml.org/lkml/2017/7/3/1010 It appears even Linus Torvalds is not aware of the LO problems with this bug, at least not as of July 3rd. It may be a good thing for people at LO to "enlighten" him. I've heard that another solution, other than to back up to a previous kernel as I have done, is to switch to 64-bit. This problem allegedly does not affect 64-bit Linux. I am running 32-bit and have no intention of changing at this time. Girvin Herr -- 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