[libreoffice-users] Re: Calc and datapilot

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-394266@n3.nabble.com>
Date: Wed, 27 Apr 2011 01:18:43 
To: JZ1982<anima.sola@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+help@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+help@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