Re: [libreoffice-users] Do not follow external links
Stephan Bergmann <sberg...@redhat.com> writes: > On 23.01.2018 09:27, Olivier wrote: >> Stephan Bergmann <sberg...@redhat.com> writes: >>> On 23.01.2018 04:36, Olivier wrote: >>>> Is there a way I can tell LibreOffice to not try to load external links? >>>> It could be a global configuration or a parameter at command line (but I >>>> could not see it). >>> >>> <https://whatofhow.wordpress.com/2013/12/02/stealth-mode/> >> >> I have tried, but it does not seam to work, at least when loading an >> HTML document: LibreOffice still tries to make an outgoing connection. >> >> To be more specific, it tries to follow the link in the following (I >> slitly modified the syntax, hping it can come through): >> >> [td align="right">[a href="javascript:GoTofff();">[INPUT onclick="return >> GoTofff()" border="0" >> src="http://BAD_PLACE/site/sites/default/files/submit_icon.gif; >> type="image" Value="submit">[/a>[/td> > > I can't reproduce any http access when loading such a html document into > LO and exporting it to pdf. If you have a working example that doesn't > honour the "stealth mode" setting, best file an issue at > <https://bugs.documentfoundation.org/> with the details (and let me know > the issue ID, please). Thank you Stephan. The bug ID is: https://bugs.documentfoundation.org/show_bug.cgi?id=115166 Olivier -- -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Do not follow external links
Stephan Bergmann <sberg...@redhat.com> writes: > On 23.01.2018 04:36, Olivier wrote: >> Is there a way I can tell LibreOffice to not try to load external links? >> It could be a global configuration or a parameter at command line (but I >> could not see it). > > <https://whatofhow.wordpress.com/2013/12/02/stealth-mode/> I have tried, but it does not seam to work, at least when loading an HTML document: LibreOffice still tries to make an outgoing connection. To be more specific, it tries to follow the link in the following (I slitly modified the syntax, hping it can come through): [td align="right">[a href="javascript:GoTofff();">[INPUT onclick="return GoTofff()" border="0" src="http://BAD_PLACE/site/sites/default/files/submit_icon.gif; type="image" Value="submit">[/a>[/td> Best regards, Olivier -- -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Do not follow external links
I am using LibreOffice as part of my anti-spam system to convert a large variety of files to PDF (that is later processed by other tools). It works well except when the file is HTML and contains external links. LibreOffice will wait indefinitely, trying to load the external links, while it does not have acces to them. Is there a way I can tell LibreOffice to not try to load external links? It could be a global configuration or a parameter at command line (but I could not see it). Of course, I am running LibreOffice headless. Thanks in advance, Olivier -- -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc row filter extraction
Yes, I do agree But when there is only one table, Calc will do the job, no ? No need to use a hammer to slam a fly... Regards from Olivier Le 28/08/2011 21:12, Andreas Säger a écrit : What you do in that spreadsheet would be a 100% database task. The data pilot is Calc's most database-ish tool. http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/DataPilot http://user.services.openoffice.org/en/forum/download/file.php?id=8592 -- View this message in context: http://nabble.documentfoundation.org/Calc-row-filter-extraction-tp3207632p3291045.html Sent from the Users mailing list archive at Nabble.com. -- --- Olivier Bietzer -- For unsubscribe instructions e-mail to: users+h...@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: Calc row filter extraction
Hi Hylton, If I understand well, you would like to see some reports of expenses, by different categories or person... Maybe a quick Pilot Table (I'm not sure of the name of this feature in English...) could do the job, no ? You can try, the feature is in the Data menu, Pilot Table - Create Place your column D as the filter, then Col C on the line, col B on the colum, and E in the table. It should propose Sum as default function. Then create, you will see the result (a table with all possible sums accessible). The only thing you miss there is the extraction per person (you sheets B and C of your example...) Hope this helps, Kind regards from Olivier Le 3/08/2011 18:27, Hylton Conacher (ZR1HPC) a écrit : On 28/07/11 23:53, planas wrote: Hi Hylton, On Thu, 2011-07-28 at 21:50 +0200, Hylton Conacher (ZR1HPC) wrote: Hi all, I have a 'data' spreadsheet sheet for my family medical aid on LO 3.3.1 with multiple columns and different information in each column. Please see the text example I include below. What I would ideally like to do is have rows on sheet A, where Column D is the same, linked onto another sheet(B). My next requirement is to group all the like column B on sheet B, C and link them onto sheet D but group them according to column B and SUM the amounts from sheets B, C. I have included a brief text example below: Re-pasted Sheet A A B C D E 20-July SVP SBP Robert 200 20-July STP SPG Hazel 100 21-July STP SBP Robert 180 22-July SVP SBP Robert 50 23-July STP SBP Hazel 400 Sheet B (All 'Robert' entries) A B C D E 20-July SVP SBP Robert 200 21-July STP SBP Robert 180 22-July SVP SBP Robert 50 Sheet C (All 'Hazel' entries) A B C D E 20-July STP SPG Hazel 100 23-July STP SBP Hazel 400 Sheet D (All 'SBP' entries) A B C D E STP SBP Robert 100 STP SBP Hazel 500 SVP SBP Robert 250 I have done some googling regarding row extraction and have also investigated the SUMIF command. and whilst I can get a total of all the STP's, I cannot SUM it by user at STP. The SUMD command has also raised its head but I cannot figure out how to get it to work in conjunction with SUMIF. Any help appreciated, even telling me MySQL is a better option. My problem is that the data is Sheet A is ever growing and being edited by a basic Excel user, and sheets b-D need to reflect those changes made on sheet A. Again, Any Help Appreciated If I understand your problem, you want conditionally add data based on a selection criteria from different sheets. I believe sumif works best using columns from on one sheet. Almost. Only Sheet A is user entered, all the others are retrieved from Sheet A. I wonder if using an intermediate sheet using vlookup and sum these results might work. One issue, vlookup is to have a unique lookup parameter in the selection column. I do not understand the case of using an intermediate sheet as each sheet(B,C,D) only requires population from certain rows on Sheet A. I have also tried for the last few days to get vlookup working but have failed with that too, despite reading the help and using google. Using the above tables, could you give me an example of the formula to copy only certain rows onto anther sheet? Appreciated Hylton -- --- Olivier Bietzer -- For unsubscribe instructions e-mail to: users+h...@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: Reproducible crash when entering (Mart
Hello, Cannot reproduce it on windows XP + 3.4.1. Neither *(Mart* not martin make a crash... Regards, Olivier Le 26/07/2011 17:25, Alexander Thurgood a écrit : Le 26/07/11 15:56, plotnik a écrit : Found it : https://bugs.freedesktop.org/show_bug.cgi?id=37345 It was closed as worksforme because others could not reproduce. I suggest you re-open the issue and add your comments to the report. Also, you might want to see if the crash still occurs with 3.4. Personally, I can not reproduce on my Mac OSX system, with either 3.3.3, or 3.4.2rc2. Alex -- --- Olivier Bietzer -- Unsubscribe instructions: E-mail to users+h...@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: Mail merge saved into individual documents
Le 12/07/2011 22:12, nvrk a écrit : On Tue, Jul 12, 2011 at 11:21 AM, Steve Edmonds steve.edmo...@ptglobal.comwrote: On 13/07/11 4:14 AM, Olivier Bietzer wrote: Hello, Using LibreOffice after some years under OOo... The Mail merge has an option to save the merged documents into one single document OR into individual documents, with some parameters to give an individual name to each doc... But this does NOT work, it does only create one single document... This was working in an older OOo (3.0 ??) but does not work in 3.3, and neither into LO 3.4.1... Does anyone else see that problem ?? Regards, Olivier Confirmed, suggest you file a bug. steve -- Unsubscribe instructions: E-mail to users+help@global.libreoffice.**orgusers%2bh...@global.libreoffice.org In case of problems unsubscribing, write to postmaster@documentfoundation. **orgpostmas...@documentfoundation.org Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquettehttp://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted Encountered this some months ago with OOo. Investigation revealed that (1) a bug had been filed; (2) that OOo rewrote the print module for ver3.3.3 which resulted in the fault, and: (3) LibO picked it up from OOo. The solution for me so far is to revert to a OOo version that worked. All the best, nvsoar OK, I'm waiting for the Bugzilla account to create the bug... Maybe I will have a look at the code to solve it myself Who knows ?? Olivier -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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] Mail merge saved into individual documents
Hello, Using LibreOffice after some years under OOo... The Mail merge has an option to save the merged documents into one single document OR into individual documents, with some parameters to give an individual name to each doc... But this does NOT work, it does only create one single document... This was working in an older OOo (3.0 ??) but does not work in 3.3, and neither into LO 3.4.1... Does anyone else see that problem ?? Regards, Olivier -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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