>>
APLDN Home

>>
Events

>>
Trainings

>>
APL Books

>>
APLDN Links

>>
Discussion Groups

>>
Downloads

>>
Articles

>>
Library

>>
Learning Tools

>>
APLDN User IO

>>
APL2000.com




General

Author Thread: Currency Formatting in the Grid
Doug.Ostien
Currency Formatting in the Grid
Posted: Thursday, August 31, 2006 2:55 PM (EST)

I am writing a financial application in which I make extensive use of the APL Grid.  Up till now I have been handle all my formatting requirements with the help of the discussions in the section of the Grid documentation titled "Details on the xFormat Property."

 

One type of currency formatting now has me stymied, however, and I can find nothing about it in the documentation.  This is the commonly used accounting currency format that keeps the dollar sign left justified in the cell and the numerals right justified.  The nice thing about this format is that all the dollar signs line up in the column without regard to the fluctuating size of the dollar figures in the cells.  For example:

 

$         250

$      2,500

$    25,000

$  250,000

 

This format can be set up in Excel with a custom format, and I am wondering if anybody out there knows how or if it can be done in the APL grid.

 

Thanks,

Doug Ostien




APL2000 Official Web Site

There is no such thing in anyone's life as an unimportant day.
--- Alexander Woollcott

APLDN Home   |    |  Events   |  Trainings   |  APL Books   |  APLDN Links   |    |  Discussion Groups   |    |  Downloads   |  Articles   |  Library   |  Learning Tools   |  APLDN User IO   |  APL2000.com   |