>How about String(number;"|yourPreferredFormat") and set it right justified?
>Not sure, but try non breakable space instead of char32.
Thanks for the suggestions. Alas, the problem remains. Interesting result in
testing:
ARRAY REAL(aNum;0)
ARRAY TEXT(aText;0)
C_LONGINT($i)
//create two arrays for display in a list box
SELECTION TO ARRAY([Table_1]amount;aNum)
For ($i;1;Size of array(aNum))
APPEND TO ARRAY(aText;String(aNum{$i};"###,##0.00 ;(###,##0.00);0.00 "))
//If (aNum{$i}>0)
//aText{$i}:=aText{$i}+"."
//end if
End for
Looking at the aText column (horizontal alignment = right):
Without that commented section, it’s the same old problem - no space after
positive numbers.
Uncomment, run again, the period is preceded by a space when displayed in a
list box. A positive number is displayed “123.45 ."
Conclusion: the space is there but the listbox (or form, or QR) won’t render it!
I fear that even if the string conversion worked, footer (and other)
calculation would be more complicated.
Malcolm
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
