https://bugs.freedesktop.org/show_bug.cgi?id=53274
--- Comment #12 from Nikos <[email protected]> 2012-08-27 09:31:21 UTC --- IF(ISNA(expression),0,expression) I would not recommend that with massive columns of vlookups (which is my use-case) as it significantly slows down the overall performance of the spreadsheet (at least on our less powerful desktops). There are also other workarounds ([e.g. using countif (=IF(COUNTIF(A1:A100,"Searchterm"),VLOOKUP("Searchterm",A1:D100,2,FALSE),0) or using an additional column (which seems to be the solution with the least impact on performance but the least elegant one)... ...but they are, workarounds (more difficult to read for the user and less efficient). However, the real problem is backwards compatibility. Most of these files are used for long period of times... and having to change them is very time consuming. I also understand your standpoint as a developer, and I understand that standards compliance must be a high priority, as it is the best protection against any kind of vendor lock-in be it proprietary or open-source. However, I also think that for software to be a serious alternative for businesses, a certain decree of continuity is at least as important.(And I do not think that an office suite not aiming at the business market could be successful at the home market). Anyway, I guess a new function would not be such an easy thing to get...so we probably will have to learn to live with tis -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
