From koffice  Mon Sep 19 09:44:01 2005
From: "R.M. Langbroek" <rutger () raveworld ! org>
Date: Mon, 19 Sep 2005 09:44:01 +0000
To: koffice
Subject: Re: Kspread working with time calculations
Message-Id: <432E8861.4080302 () raveworld ! org>
X-MARC-Message: https://marc.info/?l=koffice&m=112712664630497

Tomas Mecir wrote:

>On 9/18/05, R.M. Langbroek <rutger@raveworld.org> wrote:
>  
>
>>I recently upgraden koffice to the latest version but now my former
>>kspread sheet doesn't work anymore (parse errors all around)
>>    
>>
>
>Latest version ? That means, 1.4.1 ?
>
>  
>
Yep 1.4.1

>>Is there something changed according to working with times?
>>    
>>
>
>There were some changes in the parsing, aye.
>
>  
>
>>on cell a1 I put :   18:00
>>on cell a2 I put :   13:00
>>on cell a3 I put : =A1 + A2 and this gives a parse error
>>on previous versions it always worked perfectly
>>    
>>
>
>Works perfectly here, but I have the latest development snapshot, not
>1.4.1 - and I made some quite big changes to the formula handler
>there.
>
>Is 18:00 and 13:00 properly detected as time values - does it get
>automatically right-aligned upon entering it ? If not, then the parser
>fails to detect the time value for some weird reason ... Which locale
>settings do you use ?
>
>  
>
Yeppers, i tried fiddling around with the cell format but they really 
are time values.
When i sum() them it works, or =a1 - a2 works also..... just seems very 
very strange

I have my locale set on netherlands.

Let me try dev release....

>/ Tomas
>

____________________________________
koffice mailing list
koffice@kde.org
To unsubscribe please visit:
https://mail.kde.org/mailman/listinfo/koffice