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 and

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 th

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: <> > Nobody is never wrong. Not even me… :P > Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ <> Cute. Joe Conner, Poulsbo, WA USA -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/

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

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

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

2012-07-16 Thread Tom Davies
schel wrote: From: Regina Henschel 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 function > > Function mydate As

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: Pri

[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 ThisComponent.Sheets(0).getCellByPosition(