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

List:       koffice-devel
Subject:    Re: kspread bug in calculation
From:       Giovanni Venturi <gventuri73 () tiscali ! it>
Date:       2003-12-02 17:39:24
[Download RAW message or body]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Alle 11:57, martedě 2 dicembre 2003, LukᨠTinkl ha scritto:
> Dne po 01. prosince 2003 01:01 Giovanni Venturi napsal(a):
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > Hi. It's happening something of strange with KSpread.
> > About 4-5 days ago I compiled CVS HEAD KOFFICE.
> > If I put in the cell A1 a value like 23.586 and in cell B1 I put:
> > "=TRUNC(A1*4)" I get 94.344 like result. But TRUNC(A1*4) should return
> > 94. Is it so? If I use another cell, for example B2, and I write into
> > that cell: "A1-4" I get 23.586, but 23.586 - 4 = 19.586, right? What's
> > happening? Is it a probelm of Qt 3.2.1 or there is a more serious bug in
> > KSpread or what else? I hope it's nothing of serious. But can someone
> > explain me was KSpread doesn't make the calculation of a subtraction and
> > a truncate? It's very strange because I thing this cannot happen. Did I
> > make some wrong writing? I used also: "=(A1-4)", but nothing it doesn't
> > subtract 4 from the value. I send you another bug about KSpread. Did
> > someone take it in study? Maybe I have to use bugs.kde.org for this? Or I
> > can send the entry here? Tell me.
> > Gianni
>
> Is the decimal separator in Italy a dot (.)?
Yes in some case. I know what you want to say. I tryed with (,) and it works. 
So I ask to you. When I write for example 2.3, kspread what does do with dot? 
What number is for kspread "2.3"? 2300? And if it's so why "23.586 - 4" is 
not "23.582"?
Bye,
Gianni
P.S.: I'm sorry but for my presentation I used OpenOffice. I was becoming 
crazy. The printing was not WYSIWYG maybe I have a bad version of Qt. I have 
to use 3.1.2 with KOffice an 3.2.x after KDE 3.2 will be released. The 
management with the object of the page was very hard. The mouse cannot always 
select the right object and in some case the objects become unselectable.
:( I have got just 2 days to finish the presentation for my thesis and 
KPresenter was not for my use. Make me wish :)).
- -- 
A KDE's Italian translator
I work on "GNU/Linux 2.4.19-4GB -- SuSE Linux 8.1"
and "GNU/Linux 2.4.22 -- Slackware 9.0"
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQE/zM5RnT2ev4/bQKARAhygAJsGQKO5TdzmfWctvMXYJCU1KYfi/wCfYyQy
/jZZF0CqNdbZTxm3r3eETP0=
=TT5j
-----END PGP SIGNATURE-----

_______________________________________________
koffice-devel mailing list
koffice-devel@mail.kde.org
https://mail.kde.org/mailman/listinfo/koffice-devel

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