Show TOC

Syntax documentationset_format Locate this document in the navigation 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 SAP system, which means that you can normally simply pass the currency code from the SAP system. You can also specify the currency formatting using a type. The digits in the cell are then displayed according to the specified type.

Syntax Syntax

  1. CALL METHOD spreadsheet->set_format
EXPORTING rangename = rangename
typ = typ
currency = currency
decimals = decimals
no_flush = no_flush
IMPORTING error = error
retcode = retcode.
End of the code.
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 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.

End of the note.