Re: delete double entries, fill whole sheet with a chart, copy data to second file

[Wen <wendelinhw yahoo de>]

This was a fast :-). 

On Mon, 08 Oct 2007 16:38:29 +1000
Hal Ashburner <hal ashburner info> wrote:

> 
> On Mon, 2007-10-08 at 08:28 +0200, Wen wrote:
> > Hi list,
> > I already sent this mail without being member of the list three days ago. As I subscribed to the list now and I got a third question I also send my first two questions again. Sorry for the possible double posting.
> > 
> > First:
> > Is there an easy way in gnumeric to delete double entries, so that
> > 
> > Row A	Row B
> > 1	3
> > 1	3
> > 4	7
> > 4	9
> > 4	9
> > 4	9
> > 
> > 
> > becomes
> > 
> > 1	3
> > 4	7
> > 4	9
> 
> Hi Wen,
> Data->Filter->Advanced Filter
> then check unique records only.
> 
> Is one of way of doing this pretty quickly.
> 

I will try that.

> 
> > ?
> > Second question: 
> > Is there a possibility to make a chart fill a whole sheet (like in excel)?
> 
> I don't think so. Yet. :)
> 
Ok, not very import. Got to say that the programmers really did good work on the charts dialog. Far better to work with than the way excel does it.

> 
> > Third question:
> > I am not able to copy data via Str+c and Str+v from one gnumeric-file to the other. Only within one file. How can I copy to another gnumeric-file?
> > I am working with gnome 2.14 (debian etch) and gnumeric 1.6.3.
> 
> I am using 1.6.3 on debian with no problems in this regard.
> Can you provide some more details? A minimal set of steps that you can
> use to get copy & paste between files to fail. (Including if possible
> the data) and your locale that would be pretty useful.

Hmm, after doing all my data-imports twice yesterday because I (thought I) wasn't able to copy from one file to another, now it works perfectly.
I will provide more details if I will see this again. If not, I was just too tired.

One more question:
When importing data from an external data-file gnumeric always writes the data into a new file and not into the gnumeric-file in which I opened the import-dialog (via data-> get external data). Is there a way to import data directly to the already existing file?

Thanks a lot,
Wen