To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=113820
                 Issue #|113820
                 Summary|TEXT function not working as expected - com.sun.star.s
                        |heet.FunctionAccess is broken
               Component|Spreadsheet
                 Version|OOO330m3
                Platform|Unknown
                     URL|
              OS/Version|All
                  Status|UNCONFIRMED
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P2
            Subcomponent|code
             Assigned to|spreadsheet
             Reported by|brinzing





------- Additional comments from brinz...@openoffice.org Wed Aug 11 17:26:02 
+0000 2010 -------
steps to reproduce: 

run macro provided below

OO 1.1.5/3.2/3.2.1 will show "--04" 
OOO330m3 will show "4"

so i think this is a regression ...

REM  *****  BASIC  *****
OPTION EXPLICIT

Sub Main

        Dim oService as Object
        Dim mArgs(1)
        Dim res as Variant
        
        oService = createUNOService("com.sun.star.sheet.FunctionAccess")

        mArgs(0) = "4"
        mArgs(1) = "--0#"
        ' example: convert the given value to a "xs:gMonth" ...
        res = oService.callFunction("TEXT", mArgs())
        
        MsgBox res
End Sub

---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org


---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

Reply via email to