Showing the results for something like =SUM(A:E) would show 5 million empty values. We need to limit the number of cells to something useful.
@Ben: One for you.
Benjamin Ni committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=774085dbe5c332f2be757f5f6a0324280dd72651 tdf#92548, limit number of characters shown in formula wizard It will be available in 5.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.