DOI spreadsheet set_frame

[Former Member]

hi !

we´re working with the spreadsheet interface to display several entries in excel.

for layout-reasons we want do draw vertical lines to separate the cells.

method SET_FRAME has an parameter called TYP.

we tried several combinations to use it, with strange results. the doi-print-file was no help either.

thanks for your help,

christiane

[Former Member]

Hello Christiane!

I've faced with the same problem and found the solution:

  DATA typ TYPE i.
  FIELD-SYMBOLS <fs> TYPE x.

  ASSIGN typ TO <fs> CASTING.
  SET BIT 1 OF <fs> TO 1. "thickness
  SET BIT 2 OF <fs> TO 1. "thickness
  SET BIT 3 OF <fs> TO 0. "horizontal lines
  SET BIT 4 OF <fs> TO 1. "vertical lines
  SET BIT 5 OF <fs> TO 1. "right margin
  SET BIT 6 OF <fs> TO 1. "bottom margin
  SET BIT 7 OF <fs> TO 1. "top margin
  SET BIT 8 OF <fs> TO 1. "left margin
  typ = <fs>(1).

  CALL METHOD i_spreadsheet->set_frame
    EXPORTING
      rangename = 'table2'
      typ       = typ
      color     = 13.

Reward it with points if it is helpful!

Kind regards,

Pavel Aleshko