Re: [libreoffice-users] 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