https://bugs.freedesktop.org/show_bug.cgi?id=74547
Matthew Francis <fdb...@neosheffield.co.uk> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |fdb...@neosheffield.co.uk
--- Comment #2 from Matthew Francis <fdb...@neosheffield.co.uk> ---
(In reply to comment #1)
Thanks for the suggestion.
I'm afraid that option doesn't appear to make any difference to either the
original spreadsheet or the simplified formula I reported. If it's supposed to
then perhaps that should be looked at further.
I found a different workaround for the expression I need, which is to wrap the
first argument with N(...) to cast the column values explicitly to numbers,
which includes making "" equal to 0 (all the values in question are numbers or
"").
If ""=1 is going to be the default in this context in future, I think it will
make sense to stick with this, and adding the extra function doesn't appear to
diminish the otherwise massive (and highly welcome) speedup I've seen with 4.2.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
