https://bugs.documentfoundation.org/show_bug.cgi?id=160299
Stéphane Guillou (stragu) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |stephane.guillou@libreoffic | |e.org --- Comment #3 from Stéphane Guillou (stragu) <[email protected]> --- Created attachment 193545 --> https://bugs.documentfoundation.org/attachment.cgi?id=193545&action=edit sample ODS The behaviour is inherited from OOo, I see the same in OOo 3.3. >From what ady explained, I think the current distinction makes some sense. However, there is some inconsistency between the result of the function in cell and the status bar: Average() and Sum() always return numeric data, even for a single TRUE value as input. Shouldn't the status bar always match that? Another inconsistency is that the status bar returns boolean values if a range is selected with the cell cursor on a FALSE cell (see attached spreadsheet, select range B1:B2 starting from B2). Why not numeric, if a 0 is shown when a single FALSE cell is selected? I think I am leaning toward the most transparent, consistent and useful: always show a numeric value in the status bar. (e.g. M1:N2 sum in sample ODS should be 4 in status bar) -- You are receiving this mail because: You are the assignee for the bug.
