[BUG] Spreadsheet Copy Multiple Cells Causes Crash

[Han]

(12-19-2013 04:53 PM)Tim Wessman Wrote:  Well, the way spreadsheets work(all? or most?) is an undefined item has a "special 0" that is in an "empty" cell. Try the same thing in excel or other spreadsheets.

The question here is are you concerned that it doesn't show anything for =A1? Or that the 0 only appears with =A1*1? Or what is the item of discussion. Feeling a bit confused.

Aside from the crashes reported by Michael, the =A1 issue is simply that it does not behave in the same way as =A1*1 when cell A1 is undefined. =A1 leaves the contents blank whereas =A1*1 inserts a zero. So the issue is that there is some inconsistency (I personally don't have a preference one way or the other).