Translations:ReleaseNotes/7.0/79/en

    From The Document Foundation Wiki
    • TEXT() now allows the second argument to be an empty format string for interoperability with other implementations. If the first argument is numeric or a text string that could be converted to a number (according to formula detailed settings) then an empty string is returned. If the first argument is a text string that can not be converted to number then that text string is returned. In previous releases an empty format string always results in Err:502 (invalid argument) error. tdf#131536 (Eike Rathke (Red Hat, Inc.))