Try pasting without formatting (Shift+Ctrl+Alt+V in Writer, Shift+Ctrl+V and select Unformatted text in Calc). This will allow the inserted text to get the formatting taken from the place where it is being inserted to.