Not all formatting from an excel template shows in the output excel report

  • KM03694988
  • 31-Aug-2020
  • 31-Aug-2020

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

.

Question

Why layout does not keep all the formatting after the execution of the report?

Answer

This usually happens with the formatting at the last row of the template.

If the cells are empty and are at the end of the file, no formatting will work on them.

You can bypass this by adding some text(dot is enough) at the next line.