Once again I did it: I sent my reply directly to the OP, not to the list. Sorry. *Sigh…*
Here's what I wrote, in case someone is interested: <Message> 2012/10/20 Johnny Rosenberg <[email protected]>: > 2012/10/20 Luuk <[email protected]>: >> When i go to >> Tools/Macros/Organize Macros/LibreOffice Basic >> >> Than i see i macro called 'CallUsLeapYear' under: >> Libreoffice Macros/Tools/Misc >> >> How can this macro be used a cell? > > Can't find it. I only find ”CalIsLeapYear”. > > It returns "True" if the number inside the parenthesis is a leapyear, > otherwise "False". > > First you need to move or copy it to, I think it's called ”MyMacros & > Dialogs”. > > Now, for example: > =IF(CALISLEAPYEAR(A15)="True";A15 & " is very much a leapyear!”;A15 & > "is certainly not a leapyear, idiot!") > > The tricky part here is that CALISLEAPYEAR doesn't return the Boolean > values TRUE or FALSE, it returns ”True” or "False" as text! This is > particularly odd since the macro code looks like this: > Function CalIsLeapYear(ByVal iYear as Integer) as Boolean > CalIsLeapYear = ((iYear Mod 4 = 0) And ((iYear Mod 100 <> 0) > Or (iYear Mod 400 = 0))) > End Function > > So it looks like it returns a Boolean value, but obviously Calc is > converting it to text somehow. I can't really see the point by doing > this, it just looks stupid to me. > > And you don't need this macro very much anyway, since there is a Calc > function called ISLEAPYEAR(), ready to be used: > =IF(ISLEAPYEAR("1984-01-01");"Yes";"No") > > Note that you must use the date format of your locale settings. > > > Kind regards > > Johnny Rosenberg > ジョニー・ローゼンバーグ </Message> Now, let's move on to the last message in the thread: <Message> On 20-10-2012 14:11, Johnny Rosenberg wrote: 2012/10/20 Luuk <[email protected]>: When i go to Tools/Macros/Organize Macros/LibreOffice Basic Than i see i macro called 'CallUsLeapYear' under: Libreoffice Macros/Tools/Misc How can this macro be used a cell? Can't find it. I only find ”CalIsLeapYear”. oops, typo... ;) It returns "True" if the number inside the parenthesis is a leapyear, otherwise "False". First you need to move or copy it to, I think it's called ”MyMacros & Dialogs”. What is the use of the macros in the place i mentioned, if they cannot be used directly? </Message> I would guess that they are supposed to be called from other Basic subroutines. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
