[sc-dev] Functions with bTextAsZero (was: [sc-dev] GCD/LCM in other spreadsheet)

2008-02-22 Thread Eike Rathke
Hi Lvyue, On Friday, 2008-02-22 15:37:42 +0800, Lvyue wrote: > About i86171, I find 7 functions using bTextAsZero. > They are MIN, MAX, AVERAGE, VAR, VARP, STDEV and STDEVP. > They all have the same result as MINA(range)=MIN(range), > and it's not right. As expected.. > I made some change, and

Re: [sc-dev] GCD/LCM in other spreadsheet

2008-02-22 Thread Eike Rathke
Hi Lvyue, On Friday, 2008-02-22 15:37:42 +0800, Lvyue wrote: > Happy to hear from you. > So we can decide what to do on i71158. > And there are no other differences between the first and > the last version. So I think I'll apply the firt patch then. Thank you! > My sc has been updated. :) Go

Re: Re: [sc-dev] GCD/LCM in other spreadsheet

2008-02-21 Thread Lvyue
Eike Rathke 发送时间: 2008-02-22 02:25:33 收件人: dev@sc.openoffice.org 抄送: 主题: Re: [sc-dev] GCD/LCM in other spreadsheet Hi Lvyue, On Wednesday, 2008-02-20 14:19:13 +0800, Lvyue wrote: > In Excel: > Negative will cause error, no matter how small it is. > I have tried -1.00E-307, GCD still return

Re: [sc-dev] GCD/LCM in other spreadsheet

2008-02-21 Thread Eike Rathke
Hi Lvyue, On Wednesday, 2008-02-20 14:19:13 +0800, Lvyue wrote: > In Excel: > Negative will cause error, no matter how small it is. > I have tried -1.00E-307, GCD still return err. > > And in Gnumeric: > The handle of negative is the same to Excel. > > Shall we be consistent with them, or keep

[sc-dev] GCD/LCM in other spreadsheet

2008-02-19 Thread Lvyue
Hi Eike, I have checked how Excel and Gnumeric behave. In Excel: Negative will cause error, no matter how small it is. I have tried -1.00E-307, GCD still return err. And in Gnumeric: The handle of negative is the same to Excel. Shall we be consistent with them, or keep our direction? I'm looki