Ranges can't be found when worksheet title contains spaces

[ivanfemia]

When a range is defined in a worksheet with a title i.e. "value table" that contains spaces, then it is not found when i.e. it is used in a data validation referring to the range.

[ivanfemia]

The sheet name is directly taken in the SET_VALUE method of class ZCL_EXCEL_RANGE. I've added ' before and after the name when it contains a space. Demo report ZDEMO_EXCEL9 is adjusted to test this functionality.

[ivanfemia]

Merged into issue #46

Gregor can we invalidate this one?

[ivanfemia]

Perhaps it would be a good idea to move the coding in the SET_VALUE method of class ZCL_EXCEL_RANGE:

  IF ip_sheet_name CP '* *'.
    CONCATENATE `'` ip_sheet_name `'` INTO me->value.
  ELSE.
    me->value = ip_sheet_name.
  ENDIF.

to a GET_ESCAPED_SHEET_NAME Method of Class ZCL_EXCEL_COMMON.

[ivanfemia]

Yep this is the purpose....

[ivanfemia]

Merged into issue #46