[Issue 128533] New: The BASIC function Str inserts a space before negative numbers

[bugzilla]

https://bz.apache.org/ooo/show_bug.cgi?id=128533

          Issue ID: 128533
        Issue Type: DEFECT
           Summary: The BASIC function Str inserts a space before negative
                    numbers
           Product: App Dev
           Version: 3.3.0 or older (OOo)
          Hardware: PC
                OS: Windows, all
            Status: CONFIRMED
          Severity: Minor
          Priority: P5 (lowest)
         Component: scripting
          Assignee: issues@openoffice.apache.org
          Reporter: czeslaw.wolan...@gmail.com
  Target Milestone: ---

AOO Help on the Str function:

 "The Str function converts a numeric variable,
  or the result of a calculation into a string.
  Negative numbers are preceded by a minus sign.
  Positive numbers are preceded by a space
  (instead of the plus sign)."

So for a value of 1 and -1 the Str function shall return,
respectively, ' 1' and '-1' (single quotes here are not part
of the returned strings). Nonetheless the following code

sub test_Str
  MsgBox "'" & Str(1) & "'" & Chr(13) &_
         "'" & Str(-1) & "'"
end sub

displays:

' 1'
' -1'

Only with    Option VBASupport 1
or           CompatibilityMode(True)
one gets the _expected_ value, i.e. ' 1' and '-1'


And one more inaccuracy - AOO Help on the Format function:

Syntax:
Format (Number [, Format As String])

Format: String that specifies the format code for the number.
        If Format is omitted, the Format function works
        like the Str function.


Thus Format(Number) should yield the same result as Str(Number)
The following code:

sub test_Format

  MsgBox "'" & Format(1) & "'" & Chr(13) &_
         "'" & Format(-1) & "'"

end sub


shows:

'1'
'-1'

-- 
You are receiving this mail because:
You are the assignee for the issue.