Try making "Use Excel Formatting" default for your system. This can be done by:
Select Use Excel Formatting and Save as default ("Drop Down button on OK button).
Thanks for the pointer, I try that and still the formating is not carried over on cascaded worksheet, does this work for you on 18.104.22.168 smartview?
Try in 22.214.171.124. It did.