https://bugs.freedesktop.org/show_bug.cgi?id=59712
--- Comment #2 from Owen Genat <[email protected]> --- Created attachment 89610 --> https://bugs.freedesktop.org/attachment.cgi?id=89610&action=edit ODS showing difference in ISNUMBER() behaviour for external / local references. Tested under Crunchbang 11 x86_64 running v4.1.3.2 Build ID: 70feb7d99726f064edab4605a8ab840c50ec57a. The two files in the attached should be self-explanatory, but basically: - a.ods references source data in b.ods and compares against local references. - b.ods source data (B1:B4) containing some basic numeric and non-numeric data. External references of the type =ISNUMBER('file:///path/to/file.ods'#$Sheet1.B1) appear to return FALSE regardless of data type, while local references of the type =ISNUMBER(B1) return TRUE or FALSE as expected i.e., according to data type. -- 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
