make the worksheet functionality behave more like Excel 2007 and allow us to drag and drop formulas into the worksheet.
heard this comment at Summit 2010 - please add comments to help further this request!
Our analysts would find tremendous value with this. Most of our information is consumed in Microsoft Excel and it would be a natural extension for the worksheet functionality to continue to mimic or be better integrated with Excel.
If you're using templates, formatting should stay in place. This may be a bug, so please provide more details on the formulas portion of this request.