As you can see there are some parts of the pasted formular which are not colored anymore. It seems as the text there got truncated.
Any idea what the cause of this is?
when this has happened to me it has been a big pain, and happens more often than I would think, even copy/pasting from Apple's own templates after I've filled them out.
Sometimes it is because of the 'relativity' of the function.
Sometimes however, the cause has to do with what the 'Cell Format' is in the relative cells in question that the pasted formula would reference
I can sometimes, but not always seem to solve my pasted formula woes by one or both of the above.