https://bugs.documentfoundation.org/show_bug.cgi?id=174141
--- Comment #4 from yabuki <[email protected]> --- I tested both formulas in Excel, version 2609: =ISLOGICAL(TRUE()) returns TRUE =LET(a,TRUE(),ISLOGICAL(a)) returns TRUE This differs from Calc 26.8.1.1, where the second formula returns FALSE (displayed as 0). The direct ISLOGICAL(TRUE()) formula returns TRUE in both applications. Therefore, the ISLOGICAL result for a logical value assigned to a LET variable is inconsistent between Excel and Calc in these tested versions. -- You are receiving this mail because: You are the assignee for the bug.
