Entering content frameSyntax documentationset_format Locate the document in its SAP Library structure

You can set the formatting of the cells in a range by specifying a currency using its ISO standard code. This code is also used within the R/3 System, which means that you can normally simply pass the currency code from R/3. You can also specify the currency formatting using a type. The digits in the cell are then displayed according to the specified type.

CALL METHOD spreadsheet->set_format
       EXPORTING rangename = rangename
                 typ       = typ
                 currency  = currency
                 decimals  = decimals
                 no_flush  = no_flush
       IMPORTING error     = error
                 retcode   = retcode.

Description of parameters

Parameter

Optional

Description

rangename

  

Area name

typ

  

Type for currency formatting:

  • 0: Display as text
  • 1: Display as a simple number
  • 2: Scientific display
  • 3: Display as a percentage
  • -1: The system determines the display type by analyzing the currency parameter.

currency

  

ISO standard currency code

decimals

X

The number of decimal places

Note

Desktop Office Integration uses the lowest common denominator of the various formatting options in the spreadsheet packages that it supports. Consequently, there are fewer formatting options available than in the spreadsheets themselves.

 

 

Leaving content frame