Re: [libreoffice-users] advanced notes question
Hi Mirosław :) Ouch, i only just saw your post after writing my response to a couple of other responses that must have appeared after yours. Surely Brian's answer fixes the issue though? He is usually correct but so are you. So, now i am confused. Regards from Tom :) > > From: Mirosław Zalewski >To: users@global.libreoffice.org >Sent: Tuesday, 25 June 2013, 20:31 >Subject: Re: [libreoffice-users] advanced notes question > > >On 25/06/2013 at 18:04, Brian Barker wrote: > >> >Found it. Thanks. Unfortunately, it's greyed out, which I presume >> >means that LibreOffice isn't detecting the comments in the document. >> >Am I right? >> >> I think not. Now you need to tick Tools | Options... | LibreOffice >> Writer | View | Display | Comments. Then the menu item should become >> active. > >My simple test shows that both these options (in menu and in Tools → Options) >do the same. So if menu item is grayed out, then LO is unaware of any comments >in file. >I would consider it a bug. >-- >Best regards >Mirosław Zalewski > >-- >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] advanced notes question
Hi :) Brian's answers are usually right. It seems a few people missed it though. LibreOffice now calls these "comments". Try View | Comments. and then Now you need to tick Tools | Options... | LibreOffice Writer | View | Display | Comments. Then the menu item should become active. Brian Barker On mailing lists people often post at the bottom of threads and sometimes intersperse their replies to get them closer to the sub-questions they deal with. So, sometimes we have to scroll a bit [shrugs] Regards from Tom :) > > From: Brian Barker >Subject: Re: [libreoffice-users] advanced notes question > > >At 17:04 25/06/2013 +0200, Brian Bakker wrote: >>On 25/06/2013 16:41, Brian Barker wrote: >>>At 15:31 25/06/2013 +0200, Brian Bakker wrote: I received a document (OpenOffice format) from someone who edited it using Micros[of]t software and inserted notes into the document. However, I don't see those notes when I open the document in LibreOffice. I understand from the documentation that LibreOffice certainly does have an "advanced notes feature" (http://www.libreoffice.org/features/writer/ - 10th paragraph) but can't find where to switch it on. >>> >>>LibreOffice now calls these "comments". Try View | Comments. >> >>Found it. Thanks. Unfortunately, it's greyed out, which I presume >>means that LibreOffice isn't detecting the comments in the document. >>Am I right? > >I think not. Now you need to tick Tools | Options... | LibreOffice >Writer | View | Display | Comments. Then the menu item should become active. > >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
Re: [libreoffice-users] It would [not!] be a bug
Hi: Thank you by your help Regards, Jorge Rodríguez El lun, 24-06-2013 a las 08:30 +0100, david_lynch escribió: > On 23/06/2013 23:30, Brian Barker wrote: > > At 12:08 23/06/2013 -0600, Jorge Rodríguez wrote: > >> ... this other chart No. 2: > >> > >> Oficina Ventas > >> Ala18 > >> Here 16 > >> Punta 3 > >> Total Resultado 37 > >> > >> I've used VLookUp function to get data from chart No 2 to this other > >> chart: > >> Function: =BUSCARV(A3;'Tabla dinámica_Hoja2_1'.$A$11:$B$15;2) > >> > >> Show Should Show > >> Office Sells Sells > >> Ala 18 18 > >> Punta 3 3 > >> Here 16 16 > >> Cart18 0 > >> Lim 16 0 > >> > >> As you can see, the chart is order by office but I got 18 and 16 in > >> "Cart" and "Lim" but It should show 0 in both. The LO program get > >> datas from "Ala" and "Here" for "Cart" and "Lim". What happens? > > > > There is no bug - but two mistakes. As you know, if you omit the > > optional fourth parameter in the VLOOKUP() function, the data is > > assumed to be sorted. But as the help text makes clear, a value is > > always returned in this case - corresponding to the the last value > > smaller than the criterion. In your case, "Ala" is next before "Cart" > > and "Here" is next before "Lim". To prevent this, you need to add > > FALSE or 0 as the fourth parameter to VLOOKUP(). > > > > Second, there is no magic process by which Calc will guess that you > > wish for a zero value when no match is found: there is simply no value > > to return! The value #N/A will be returned instead. If you want zero > > values here, you need to test for this error value and replace it with > > zero. You can do this using the ISNA() function, using something like: > > > > =IF(ISNA(VLOOKUP(Xn;;2;0));0;VLOOKUP(Xn;;2;0)) > > or, more simply, (new in LO 4): > =IFNA(VLOOKUP(Xn;;2;0);0) > > > > > > I trust this helps. > > > > Brian Barker > > > > > > -- Atentamente, Jorge Rodríguez -- 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] advanced notes question
If /Microsnot/ actually means /Microsoft/ maybe it just can't be done with LO? I received a document (OpenOffice format) from someone who edited it using Microsnot software and inserted notes into the document. On 06/25/2013 10:54 PM, Dave Liesse wrote: Is the document opening in read-only mode? If you opened it directly from an email it might be -- this happens to me all the time. If that's the case, you'll want to save it first and then (re)open it. On 6/25/2013 12:31, Mirosław Zalewski wrote: On 25/06/2013 at 18:04, Brian Barker wrote: Found it. Thanks. Unfortunately, it's greyed out, which I presume means that LibreOffice isn't detecting the comments in the document. Am I right? I think not. Now you need to tick Tools | Options... | LibreOffice Writer | View | Display | Comments. Then the menu item should become active. My simple test shows that both these options (in menu and in Tools → Options) do the same. So if menu item is grayed out, then LO is unaware of any comments in file. I would consider it a bug. -- 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] advanced notes question
Is the document opening in read-only mode? If you opened it directly from an email it might be -- this happens to me all the time. If that's the case, you'll want to save it first and then (re)open it. On 6/25/2013 12:31, Mirosław Zalewski wrote: On 25/06/2013 at 18:04, Brian Barker wrote: Found it. Thanks. Unfortunately, it's greyed out, which I presume means that LibreOffice isn't detecting the comments in the document. Am I right? I think not. Now you need to tick Tools | Options... | LibreOffice Writer | View | Display | Comments. Then the menu item should become active. My simple test shows that both these options (in menu and in Tools → Options) do the same. So if menu item is grayed out, then LO is unaware of any comments in file. I would consider it a bug. -- 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] 4.0.4win32 download link hacked or problems
Today, I downloaded libreoffice4.0.4.win32.exe twice. The first time I used the big download link from the libroffice.org webpage (which first linked to the donation page). I couldn't find the md5 hash on the libreoffice.org website, though I eventually found the md5 hash for the experimental 64bit version (and downloaded it and found the checksum matched that new download). So I googled to the 32 bit version hash, and found links which all gave a very different checksum beginning f21..., although the download from the libreoffice.org website said it completed and gave a checksum of 3645B0ACFD2E6A7CA380804723D0C94A. Turns out the download through somthing like nexxus was less than 2 mb. I of course deleted the file as possible malware, but thought you should know. And suggest that checksums be made available easily on the libreoffice.org for 32bit versions, not just experimental or 64bit versions. Freeware sites are often targets for malware, as I found out long ago downloading xbmc. -- 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] advanced notes question
On 25/06/2013 at 18:04, Brian Barker wrote: > >Found it. Thanks. Unfortunately, it's greyed out, which I presume > >means that LibreOffice isn't detecting the comments in the document. > >Am I right? > > I think not. Now you need to tick Tools | Options... | LibreOffice > Writer | View | Display | Comments. Then the menu item should become > active. My simple test shows that both these options (in menu and in Tools → Options) do the same. So if menu item is grayed out, then LO is unaware of any comments in file. I would consider it a bug. -- Best regards Mirosław Zalewski -- 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] Fwd: Bouncing messages from users@global.libreoffice.org
I've been getting these stupid bounce messages every day. I've unsubscribed but they still keep coming. Fix the #$%@! problem! - Original message - From: users+ow...@global.libreoffice.org To: lbla...@fastmail.fm Subject: Bouncing messages from users@global.libreoffice.org Date: Tue, 25 Jun 2013 02:06:07 + Hi, this is the Mlmmj program managing the mailing list. Some messages to you could not be delivered. If you're seeing this message it means things are back to normal, and it's merely for your information. Here is the list of the bounced messages: - digest -- Larry Blanchard lbla...@fastmail.fm -- http://www.fastmail.fm - Does exactly what it says on the tin -- 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] advanced notes question
At 17:04 25/06/2013 +0200, Brian Bakker wrote: On 25/06/2013 16:41, Brian Barker wrote: At 15:31 25/06/2013 +0200, Brian Bakker wrote: I received a document (OpenOffice format) from someone who edited it using Micros[of]t software and inserted notes into the document. However, I don't see those notes when I open the document in LibreOffice. I understand from the documentation that LibreOffice certainly does have an "advanced notes feature" (http://www.libreoffice.org/features/writer/ - 10th paragraph) but can't find where to switch it on. LibreOffice now calls these "comments". Try View | Comments. Found it. Thanks. Unfortunately, it's greyed out, which I presume means that LibreOffice isn't detecting the comments in the document. Am I right? I think not. Now you need to tick Tools | Options... | LibreOffice Writer | View | Display | Comments. Then the menu item should become active. 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
Re: [libreoffice-users] advanced notes question
At 15:31 25/06/2013 +0200, Brian Bakker wrote: I received a document (OpenOffice format) from someone who edited it using Micros[of]t software and inserted notes into the document. However, I don't see those notes when I open the document in LibreOffice. I understand from the documentation that LibreOffice certainly does have an "advanced notes feature" (http://www.libreoffice.org/features/writer/ - 10th paragraph) but can't find where to switch it on. LibreOffice now calls these "comments". Try View | Comments. 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] advanced notes question
Hi all Hopefully someone on the list can answer this for me. I received a document (OpenOffice format) from someone who edited it using Microsnot software and inserted notes into the document. However, I don't see those notes when I open the document in LibreOffice. I understand from the documentation that LibreOffice certainly does have an "advanced notes feature" (http://www.libreoffice.org/features/writer/ - 10th paragraph) but can't find where to switch it on. Any assistance with this would be greatly appreciated. b -- 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] Mismatch between installed version number and update icon message
Dear list I'm running Mint 14 and wonder if this is this a glitch in the LibO updates indicator? I recently installed LibO4.0.4 and the update icon is still visible in the top right hand corner of any component window (e.g. Writer, Calc, etc.). When I select the icon the message is "LibreOffice 4.0.4 is available. The installed version is LibreOffice 4.0.3.3." When I select "About" from the Help menu, the version number is also given as 4.0.3.3. and yet, according to Synaptic, the version I am running is 4.0.4.2-2. I appreciate this isn't serious, I'm just wondering if something has gone amiss in the 4.0.4 release which gives this misidentification of the version being run. Thanks for any insight -- 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