Hi, i found out something new:
The function only works fine, if the "then" argument is true, otherwise the error " :#name? " oocures. eg: formula: IF(D8<8;5;9) value of D8: 1 --> 5 value of D8: 10 --> #name? Anyone having to deal with the same problem?!? Am Freitag, 22. August 2014 12:56:07 UTC+2 schrieb paul...@gulli.com: > > HI, > > hm, there is another aspect which may proof the OO-bug. When I select the > cell in which I wrote the formula and press the "=" on top in the > "function-line", the formula works fine... > > Am Donnerstag, 21. August 2014 18:31:19 UTC+2 schrieb ILM: >> >> Le 27/07/2014 19:47, paul...@gulli.com a écrit : >> > Everything works fine execpt the formula as it is written in small >> letters >> > "if" and not, as proposed, in capital IF. >> > >> > The content of cell (1,1) is =if(C8<8;5;9) and OO 4.1 displays an >> error >> > "#name?" >> > >> > This seems to be very strange as the "C8" is set correctly in capital >> > letters... >> >> Hi, >> >> Looking at the code, the setFormula() argument is directly set to >> the OpenDocument attribute. So >> this looks like an LibreOffice bug. >> >> Cheers, >> Sylvain >> >> -- --- You received this message because you are subscribed to the Google Groups "jOpenDocument" group. To unsubscribe from this group and stop receiving emails from it, send an email to jopendocument+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.