This method adjusts the width the cells in an area to the width of the widest cell contents.
CALL METHOD spreadsheet->fit_widest
EXPORTING name = name
no_flush = no_flush
IMPORTING error = error
retcode = retcode.
Description of parameters
Parameter |
Optional |
Description |
name |
Name of the range you want to change |
If you do not specify a range name, the function applies to the entire worksheet.
If you called the method
set_ranges_data and the entries had leading spaces, the results may be unsatisfactory.