Hi Cor, Though with a copy paste I could get it easily done I would like to get it updated automatically. As my journal keeps growing it would require me to regulary filter and copy/paste. Also I would like todo it on other codes.
Kind regards, JZ ------------------- -----Original Message----- From: "Cor Nouws [via Document Foundation Mail Archive]" <ml-node+2869517-71229292-394...@n3.nabble.com> Date: Wed, 27 Apr 2011 01:18:43 To: JZ1982<anima.s...@gmail.com> Subject: Re: Calc and datapilot Hi, JZ1982 wrote (23-04-11 23:43) > First of all I'm new to LibreOffice and i'm kind of a numbskull if it comes > to the more advanced options within this software. > > What I'm trying to achieve is the following, I've got data consisting of > "code" "date" "text" "value" which I keep journalizing. I want to manipulate > this data in a different sheet in a manner that I want the whole rows parsed > to the different sheet depending on which "code" and "date" I'm looking for. > > See the following picture: > > [IMG]http://i54.tinypic.com/20ubpdt.jpg[/IMG] > > I've been toying aroudn with DataPilot now for quite some time and I can > sort nicely on "code" but I fail to parse entire rows like I want to. Getting the result as on the right side of your picture, can easily be done with the default filter. Data > Filter > Default Then filter on code 402 and copy/paste the result to a different place, when needed. Hmm, but is it this what you want to achieve? Kind regards, Cor -- - http://nl.libreoffice.org - giving openoffice.org its foundation :: The Document Foundation - -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted _______________________________________________ If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/Spreadsheet-and-datapilot-tp2856239p2869517.html To unsubscribe from Spreadsheet and datapilot, visit http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=2856239&code=YW5pbWEuc29sYUBnbWFpbC5jb218Mjg1NjIzOXwxNTE1OTI4Mjg= -- View this message in context: http://nabble.documentfoundation.org/Spreadsheet-and-datapilot-tp2856239p2869786.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted