https://bugs.freedesktop.org/show_bug.cgi?id=71974
Ady <ady...@hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO --- Comment #2 from Ady <ady...@hotmail.com> --- > 6_ B1: =CELL(FORMAT,A1) -> #NAME? > > So LO Calc is not recognizing the CELL() function (this is an additional > bug). Sorry, that part is not a bug, as the correct syntax is CELL("FORMAT",A1). Yet, in the fraction format part, there is indeed a bug as I wrote before. The cell A2: 1 1/4 is already formatted as fraction, so it shouldn't be treated as text. But, the behavior of the rest of the cells seems correct: fractions are displayed as fractions, not with decimals. @fcannon, May I suggest updating LO and testing again? Please report back your results. -- 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