Re: [libreoffice-users] Unexpected behavior while writing Calc Functions

2012-07-16 Thread Regina Henschel
Hi Andrew, Andrew Douglas Pitonyak schrieb: I wrote a simple function Function mydate As Date mydate = CDate(100) End Function I then called this function from a Calc document =myDate() Finally, I directly accessed the cells with the dates from a macro similar to the following code:

Re: [libreoffice-users] Unexpected behavior while writing Calc Functions

2012-07-16 Thread Tom Davies
rb.hensc...@t-online.de wrote: From: Regina Henschel rb.hensc...@t-online.de Subject: Re: [libreoffice-users] Unexpected behavior while writing Calc Functions To: users@global.libreoffice.org Date: Monday, 16 July, 2012, 13:07 Hi Andrew, Andrew Douglas Pitonyak schrieb: I wrote a simple

Re: [libreoffice-users] Unexpected behavior while writing Calc Functions

2012-07-16 Thread Johnny Rosenberg
from Tom :) Nobody is never wrong. Not even me… :P Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ --- On Mon, 16/7/12, Regina Henschel rb.hensc...@t-online.de wrote: From: Regina Henschel rb.hensc...@t-online.de Subject: Re: [libreoffice-users] Unexpected behavior while writing Calc Functions

Re: [libreoffice-users] Unexpected behavior while writing Calc Functions

2012-07-16 Thread Joe Conner
On 7/16/2012 6:20 AM, Johnny Rosenberg wrote: SNIP Nobody is never wrong. Not even me… :P Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ snip Cute. Joe Conner, Poulsbo, WA USA -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] Unexpected behavior while writing Calc Functions

2012-07-16 Thread Regina Henschel
Hi Tom, Tom Davies schrieb: Hi :) I am pretty sure that Date is an Sql data-type, just like double or text but perhaps it got tweaked-off somewhere in the embedded HsqlDb? This is not about HSQL but about Basic. Andrew is almost never wrong and Regina is never wrong so i'm at a loss about

Re: [libreoffice-users] Unexpected behavior while writing Calc Functions

2012-07-16 Thread Andrew Douglas Pitonyak
On 07/16/2012 02:58 PM, Regina Henschel wrote: Hi Tom, Tom Davies schrieb: Hi :) I am pretty sure that Date is an Sql data-type, just like double or text but perhaps it got tweaked-off somewhere in the embedded HsqlDb? This is not about HSQL but about Basic. Andrew is almost never wrong

[libreoffice-users] Unexpected behavior while writing Calc Functions

2012-07-15 Thread Andrew Douglas Pitonyak
I wrote a simple function Function mydate As Date mydate = CDate(100) End Function I then called this function from a Calc document =myDate() Finally, I directly accessed the cells with the dates from a macro similar to the following code: Print