Re: [libreoffice-users] How to fill in "Read filter criteria from"
I'm sorry, ... it looks worst Jorge Rodríguez El sáb, 24-09-2016 a las 12:20 +, jorge escribió: > Hi again: > > I hope in this way you can see better my last e-mail: > > At first you have to copy the headers of your table at you side of you > > > table for example or at the end if it isn't big. > > > > Then you have to add the filter that you need and put bellow of the > > header that you want to filter. > > > > Then run the wizard : Advanced Filter (Before select the table that you > > want to filter) and in options you can select where to put the datas > > filtereds. > > > > Example: > > > > > > Province > > Sells > > Costs > > Profits > > Alajuela > >10 > > 2 > > 8 > >Puntarenas > >20 > > 1 > >19 > > Limón > >20 > > 4 > >16 > > Heredia > >10 > > 7 > > 3 > > San José > >20 > > 5 > >15 > > Alajuela > >10 > > 8 > > 2 > > Heredia > >40 > > 9 > >31 > > Puntarenas > >50 > >12 > >38 > > Advanced Filter:(Read Filter Criteria From) > > Province > > Sells > > Costs > > Profits > > > > > > > > > 20 > > > > > > > > > > > > > > Results of Advance data Filtereds: > > Province > > Sells > > Costs > > Profits > > Heredia > >40 > > 9 > >31 > > Puntarenas > >50 > >12 > >38 > > In this case, we filtered the column Sells to show only Province that > > have sells higher than 20 > > > > > Regards, > > Jorge Rodríguez > > > > El sáb, 24-09-2016 a las 11:59 +, jorge escribió: > > > Hi Larry and all: > > > > At first you have to copy the headers of your table at you side of you > > table for example or at the end if it isn't big. > > > > Then you have to add the filter that you need and put bellow of the > > header that you want to filter. > > > > Then run the wizard : Advanced Filter (Before select the table that you > > want to filter) and in options you can select where to put the datas > > filtereds. > > > > Example: > > > > Table > > > > Province Sells Costs Profits > > Alajuela 10 2 8 > > Puntarenas 20 1 19 > > Limón 20 4 16 > > Heredia 10 7 3 > > San José 20 5 15 > > Alajuela 10 8 2 > > Heredia 40 9 31 > > Puntarenas 50 12 38 > > > > Advanced Filter:(Read Filter Criteria From) > > > > Province Sells Costs Profits > > > 20 > > > > Results of Advance data Filtereds: > > > > Province Sells Costs Profits > > Heredia 40 9 31 > > Puntarenas 50 12 38 > > > > In this case, we filtered the column Sells to show only Province that > > have sells higher than 20 > > > > I hope this help, > > > > Jorge Rodríguez > > > > > > > > El sáb, 24-09-2016 a las 16:49 -0500, Larry Evans escribió: > > > I selected Data>Filter>Advanced Filter; however, > > > I had no idea what to do next. I selected Help button, > > > which sent my browser to: > > > > > > > > > https://help.libreoffice.org/index.php?title=5.1/Calc/Advanced_Filter&Language=en-US&System=UNIX&Version=5.1#bm_id3151113 > > > > > > which was, again, no help. > > > > > > How do I fill out the "Advanced Filter" dialog? > > > > > > -regards, > > > Larry > > > > > > > > -- > Atentamente, > > Jorge Rodríguez > -- 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] How to fill in "Read filter criteria from"
Hi again: I hope in this way you can see better my last e-mail: At first you have to copy the headers of your table at you side of you > table for example or at the end if it isn't big. > > Then you have to add the filter that you need and put bellow of the > header that you want to filter. > > Then run the wizard : Advanced Filter (Before select the table that you > want to filter) and in options you can select where to put the datas > filtereds. > > Example: > > > Province > Sells > Costs > Profits > Alajuela >10 > 2 > 8 >Puntarenas >20 > 1 >19 > Limón >20 > 4 >16 > Heredia >10 > 7 > 3 > San José >20 > 5 >15 > Alajuela >10 > 8 > 2 > Heredia >40 > 9 >31 > Puntarenas >50 >12 >38 > Advanced Filter:(Read Filter Criteria From) > Province > Sells > Costs > Profits > > > > > 20 > > > > > > > Results of Advance data Filtereds: > Province > Sells > Costs > Profits > Heredia >40 > 9 >31 > Puntarenas >50 >12 >38 > In this case, we filtered the column Sells to show only Province that > have sells higher than 20 Regards, Jorge Rodríguez El sáb, 24-09-2016 a las 11:59 +, jorge escribió: > Hi Larry and all: > > At first you have to copy the headers of your table at you side of you > table for example or at the end if it isn't big. > > Then you have to add the filter that you need and put bellow of the > header that you want to filter. > > Then run the wizard : Advanced Filter (Before select the table that you > want to filter) and in options you can select where to put the datas > filtereds. > > Example: > > Table > > Province Sells Costs Profits > Alajuela 10 2 8 > Puntarenas 20 1 19 > Limón 20 4 16 > Heredia 10 7 3 > San José 20 5 15 > Alajuela 10 8 2 > Heredia 40 9 31 > Puntarenas 50 12 38 > > Advanced Filter:(Read Filter Criteria From) > > Province Sells Costs Profits > > 20 > > Results of Advance data Filtereds: > > Province Sells Costs Profits > Heredia 40 9 31 > Puntarenas 50 12 38 > > In this case, we filtered the column Sells to show only Province that > have sells higher than 20 > > I hope this help, > > Jorge Rodríguez > > > > El sáb, 24-09-2016 a las 16:49 -0500, Larry Evans escribió: > > I selected Data>Filter>Advanced Filter; however, > > I had no idea what to do next. I selected Help button, > > which sent my browser to: > > > > > > https://help.libreoffice.org/index.php?title=5.1/Calc/Advanced_Filter&Language=en-US&System=UNIX&Version=5.1#bm_id3151113 > > > > which was, again, no help. > > > > How do I fill out the "Advanced Filter" dialog? > > > > -regards, > > Larry > > > -- 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] How to fill in "Read filter criteria from"
Hi Larry and all: At first you have to copy the headers of your table at you side of you table for example or at the end if it isn't big. Then you have to add the filter that you need and put bellow of the header that you want to filter. Then run the wizard : Advanced Filter (Before select the table that you want to filter) and in options you can select where to put the datas filtereds. Example: Table Province Sells Costs Profits Alajuela 10 2 8 Puntarenas 20 1 19 Limón 20 4 16 Heredia 10 7 3 San José 20 5 15 Alajuela 10 8 2 Heredia 40 9 31 Puntarenas 50 12 38 Advanced Filter:(Read Filter Criteria From) Province Sells Costs Profits > 20 Results of Advance data Filtereds: Province Sells Costs Profits Heredia 40 9 31 Puntarenas 50 12 38 In this case, we filtered the column Sells to show only Province that have sells higher than 20 I hope this help, Jorge Rodríguez El sáb, 24-09-2016 a las 16:49 -0500, Larry Evans escribió: > I selected Data>Filter>Advanced Filter; however, > I had no idea what to do next. I selected Help button, > which sent my browser to: > > > https://help.libreoffice.org/index.php?title=5.1/Calc/Advanced_Filter&Language=en-US&System=UNIX&Version=5.1#bm_id3151113 > > which was, again, no help. > > How do I fill out the "Advanced Filter" dialog? > > -regards, > Larry > -- 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
[libreoffice-users] Re: Formulas displaying in a cell
On 09/24/2016 03:19 PM, Larry Evans wrote: On 01/07/2016 11:23 AM, Harv wrote: Please ignore this note. I found the problem. Please enlighten us. I'm just now having a similar problem.\ I've tryed =TEXT(b3,"###.##") and just the formula appears in the cell. I've tried =ABS(b3) and just the formula appears in the cell. I'm guessing there's some switch to change from displaying formula to displaying result; however, I've no clue where to look :( It finally dawned on me that the column was formatted as Text. When that was changed to Category=All, Format=General, things started working. I don't know how, but there should be some way to hint to the user what to do when a cell which looks like a formula is not a formula. -regards, Larry -- 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 fill in "Read filter criteria from"
I selected Data>Filter>Advanced Filter; however, I had no idea what to do next. I selected Help button, which sent my browser to: https://help.libreoffice.org/index.php?title=5.1/Calc/Advanced_Filter&Language=en-US&System=UNIX&Version=5.1#bm_id3151113 which was, again, no help. How do I fill out the "Advanced Filter" dialog? -regards, Larry -- 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: Formulas displaying in a cell
On 01/07/2016 11:23 AM, Harv wrote: Please ignore this note. I found the problem. Please enlighten us. I'm just now having a similar problem.\ I've tryed =TEXT(b3,"###.##") and just the formula appears in the cell. I've tried =ABS(b3) and just the formula appears in the cell. I'm guessing there's some switch to change from displaying formula to displaying result; however, I've no clue where to look :( Sent from Mail for Windows 10 From: Harv Sent: Thursday, January 7, 2016 10:49 AM To: users@global.libreoffice.org Subject: Formulas displaying in a cell Hello, I can’t figure out why I have certain cells displaying the formula and not the results. I’m using calc version 5.0.4.2. -- 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] Spelling check funnies
my question has been/is as to why anyone would use a spell checker ... I think we should reinstate phonics in schools so the youth can once again learn how to read & spell; reinstating Latin & Greek as well. From: John Willerton Date: Sat, Sep 24, 2016 at 7:06 AM Subject: [libreoffice-users] Spelling check funnies To: users@global.libreoffice.org Hi All, I read the forum regularly but this is my first post. It's only light-hearted but I don't see why that should be against the rules. Using the spelling checker in LO Writer version 5.0.5.2 on Windows 7 Pro, I recently passed over a fairly common English surname, "Ainsworth". The spelling checker gave some wonderful suggestions, namely Wandsworth, Wadsworth, AIRWORTHY, WORDSWORTH, UNSEAWORTHY and NEWSWORTHY (my capitalisations). Has anyone else found some funnies. If so ,why not share them? The forum does not have to be grindingly technical all day every day. -- 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] Spelling check funnies
Hi All, I read the forum regularly but this is my first post. It's only light-hearted but I don't see why that should be against the rules. Using the spelling checker in LO Writer version 5.0.5.2 on Windows 7 Pro, I recently passed over a fairly common English surname, "Ainsworth". The spelling checker gave some wonderful suggestions, namely Wandsworth, Wadsworth, AIRWORTHY, WORDSWORTH, UNSEAWORTHY and NEWSWORTHY (my capitalisations). Has anyone else found some funnies. If so ,why not share them? The forum does not have to be grindingly technical all day every day. -- 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] Get number of items in a calc's sheet filtered list
Make sure "View > Status Bar" is checked. That information is displayed in the second part of the status bar at the bottom of Calc but only when the focus is within the range of data being filtered. At the bottom you will then see something like: | Sheet 3 of 4 | 55 of 1425 records found | etc. On Sat, Sep 24, 2016 at 5:33 AM, Daniel A. Rodriguez < daniel.armando.rodrig...@gmail.com> wrote: > I've been asked about this and can't find an answer yet. The 'other' > software shows something like "found X from Y records" and the need is > to find something like that. > > Any clue? > > > > > > > > Comunidad LibreOffice Argentina > www.libreoffice.org.ar > > -- > 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] Re: Page formatting in writer goes nuts
I have noticed another odd behaviour which may be related to the "picture problem" vs page formatting. I have a page in my large doc with only text. This first picture shows the content when the document is freshly loaded. https://drive.google.com/open?id=0BzKxVP7gn2uTTTJSdzBBUkNRQ00 Then, after a change somewhere (that does not affect the page count), bot sure exactly what triggers it, it becomes https://drive.google.com/open?id=0BzKxVP7gn2uTT3ZJdzA1cHp3U2c Notice that the spacing between the lines has increased and that the last line from the first picture now has spilled over to next page. Of course, this creates seemingly unmotivated changes in the page formatting. Anyone has an idea what is going on here and if I can influence this behaviour? Thanks 2016-09-10 16:59 GMT+02:00 Bo Siltberg : > Thank you Wiebe for updating the existing bug report, that should be > enough. However their reply indicates that it may be difficult to solve. > Not sure that status *needinfo* means, if they want more info from us. I > hope they will take a look at this bug as it is easy to reproduce. > > I have seen similar problems with pagination in tables and frames too, > where no pictures were involved. Starting with this pic bug, I hope it may > solve some other bug too related to page formatting. > > -- 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] Get number of items in a calc's sheet filtered list
I've been asked about this and can't find an answer yet. The 'other' software shows something like "found X from Y records" and the need is to find something like that. Any clue? Comunidad LibreOffice Argentina www.libreoffice.org.ar -- 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