[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice-devel
Subject:    Re: Formula problem, xl import filter
From:       David Faure <david () mandrakesoft ! com>
Date:       2002-04-26 8:45:13
[Download RAW message or body]

On Thursday 25 April 2002 20:26, Nikolas Zimmermann wrote:
> Hi there,
> 
> i ran into a certain problems:
> It seems like excel makes no difference if you write
> "0222" in a row or "222" it saves it 'the same way'

Yes, that's the difference between numbers and strings.
As a number 0222==222, but as a string it's different.

> So i added, some months ago, the ' in front to fix
> some testfiles i have here....

But did you add it to strings only ?

> But as we all know this is a big problem now, cause
> formulas aren't calculated anymore in all cases
> So what to do ? "Fix" kspread?

IMHO the fix is to add a ' when the cell contents is a string,
and not when it's a number, or a formula, etc.
Since Excel has the same behaviour (0222==222 unless you
put a ' in front of it), I'm sure it can tell whether a cell is a number
or a string/formula.

-- 
David FAURE, david@mandrakesoft.com, faure@kde.org
http://people.mandrakesoft.com/~david/
Contributing to: http://www.konqueror.org/, http://www.koffice.org/
KDE, Making The Future of Computing Available Today

_______________________________________________
koffice-devel mailing list
koffice-devel@mail.kde.org
http://mail.kde.org/mailman/listinfo/koffice-devel
[prev in list] [next in list] [prev in thread] [next in thread]