Re: [libreoffice-users] Calc and datapilot

On 27/04/11 18:18, Cor Nouws wrote:
> 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

Hi,

I don't think you can use Calc in the way you invision.

Some options exist...

1. Create a macro that sorts the list. This is not dynamic.
2. Create a duplicate of the sheet containing the core data. Use VLOOKUP 
to dynamically duplicate the sheet. Then create a filter on each 
duplicate sheet. Each duplicate sheet is filtered based on a particular 
'volgnummer'. Usually I put this value at the top of the file as a 
header. This works really well with small to medium datsets but can be 
slow with larger datasets.
3. For larger datasets consider storing in a database then use Base to 
import just the 'code' lines you want to each sheet. This is a bit more 
complicated and less portable, depending on the database used.

--
Cheers Simon

   Simon Cropper
   Principal Consultant
   Botanicus Australia Pty Ltd
   PO Box 160, Sunshine, VIC
   W: www.botanicusaustralia.com.au

--
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