From koffice  Wed Oct 31 18:17:48 2001
From: Werner Trobin <trobin () kde ! org>
Date: Wed, 31 Oct 2001 18:17:48 +0000
To: koffice
Subject: Re: Kspread...
X-MARC-Message: https://marc.info/?l=koffice&m=100455243629383

Jim Hatridge wrote:
> 
> On Tuesday 30 October 2001 19:28, Werner Trobin wrote:
> > Jim Hatridge wrote:
> > > Hi all..
> > >
> > > How do I get Kspread to sum up a column of numbers? For example what I
> > > want is, lets say Column A has numbers from A1 to A100, I want the sum of
> > > this column in space B1. How would I get that?
> >
> > =sum(A1:A100) ? :)
> >
> > Ciao,
> > Werner
> 
> Hi Werner et al...
> 
> Thanks, that was what I was looking for.
> 
> NEXT questions!
> 
> I have files I made with VPplanner, a 123 clone. They all end in WKS. How can
> I import them into Kspread? (Can I import them?)

Is it a binary format? Can you read it in a text editor? Try exporting
.cvs in the "old" app - KSpread can import that stuff. Excel files also
work quite nicely.

> Also when I have a couple of tables of data how can I add up cells on
> different tables? For example, on table 1 cell a1 I want to add up cell a1
> from table 2 thru table 10.

Like in Excel, IIRC:
=Tablename!A1+Tablename2!A1 ...

Ciao,
Werner