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 220.127.116.11 smartview?
Try in 18.104.22.168. It did.