Excellent. I have already updated the test database with table structures ( to mimic the spreadsheet structure ) and the test data from the OASIS document.
The functions I'll test then are: [ Date/Time functions ] Date DateDiff Time DateValue Now Today Day Month Year WeekDay. Hour [ Logical functions ] And False If Not Or True Xor [ Rounding functions ] Int [ Mathematical functions ] Sum Abs Average Odd Even [ Text functions ] Len Lower Upper Trim Text T Find Exact Rept Mid Left Right UrlEncode Replace Substitute Information functions HasChanged IsBlank Na IsNa IsLogical IsText IsErr IsError Choose IsRef IsNumber IsOdd IsEven IsNonText Null [ Operators ] (inFix) + Add. - Subtract * Multiply / Divide = Equal <> NotEqual < Lesser
Greater
<= LesserEqual
= GreaterEqual
& Concat ^ Power ( postFix ) % Percentage + Plus - Minus On 5/24/07, Ocke Janssen Sun Microsystems <[EMAIL PROTECTED]> wrote:
Hi Andrew, Andrew Jensen wrote: > Hi Ocke, > > Looking more closely at earlier email you said that the functions would > follow the follow the style described in the OASIS document. I take it > then > that it does not mean that any of the functions specifically mentioned in > that document are ( or will ) be supplied with Report Designer? > > In other words, the fact that I have found a couple of the functions > to work > in Report Designer is just coincidence and continuing work on my test > database for functions described in the OASIS document is not actually > productive use of time. Yes, it's only productive to have an end test. But I don't when all functions would be implemented. Here you'll find a link to the functions which should work http://jfreereport.cvs.sourceforge.net/jfreereport/libformula/source/org/jfree/formula/libformula.properties?view=markup > > A follow up question on that would be - When I find a function of the > same > name in Report Designer's function library, as one described in the OASIS > document, can I then expect it to work as described in the OASIS > document? Yes. If this is not the case guess what to do? :-) Yes, submit an issue. As owner you could set [EMAIL PROTECTED] and set me as cc. Thomas Morgner is the core developer of the report engine. > > Drew > - oj -- Ocke Janssen Tel: +49 40 23646 661, x66661 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] D-20097 Hamburg http://www.sun.com/staroffice Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Amtsgericht Muenchen: HRB 161028 Geschaeftsfuehrer: Marcel Schneider, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
