https://bugs.freedesktop.org/show_bug.cgi?id=80260
--- Comment #10 from pierre-yves samyn <pierre-yves.sa...@laposte.net> --- (In reply to comment #7) > For me it doesn't matter whether values are created before or after the > formatting is created. This is not what I said. There are no *values* but name ranges in my example. > Putting the onus on the user to use double quotes when the field is simply > value is misleading. There is no warning or information as to why this is > required. Yes, I understood your point of view. I just tried to explain better... 1. File> New> Spreadsheet 2. Select B1, type: =IF(A1=y;"yes";"no") Actual result : =IF(A1='y';"yes";"no") and the cell displays #REF Here we also expect the user to type the quotes... Regards Pierre-Yves -- 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