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