https://bugs.documentfoundation.org/show_bug.cgi?id=59712
Beluga <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #5 from Beluga <[email protected]> --- (In reply to Owen Genat (retired) from comment #2) > Created attachment 89610 [details] > 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. Confirmed. Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+ Build ID: 01a189abcd9a4ca472a74b3b2c000c9338fc2c91 TinderBox: Win-x86@39, Branch:master, Time: 2015-06-14_07:46:28 Locale: fi-FI (fi_FI) -- 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
