https://bugs.documentfoundation.org/show_bug.cgi?id=96923
GerardF <gerard.farg...@orange.fr> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |gerard.farg...@orange.fr --- Comment #2 from GerardF <gerard.farg...@orange.fr> --- Not easy to search with such a big file... But I saw the difference of calculation. On sheet 'ESC. ANT. VANYA' (Sheet 82 on 109 Column F for example), You have the following formula in F11 : =SUMIFS($'12-14'.D:D;$'12-14'.C:C;1;$'12-14'.A:A;B11)-SUMIFS($'12-14-LS'.D:D;$'12-14-LS'.C:C;1;$'12-14-LS'.A:A;B11) The part of the formula causes the problem is $'12-14'.C:C;1 the formula search for the numeric criterion 1 in column C of sheet '12-14' but this column contains the text '1. Calc don't count the text 1 with SUMIFS having creterion 1 (as number). If I select column C on sheet '12-14' and make Data > Text to colums, data is converted to numeric. The same for sheet '12-14-LS'. Now I get the correct values. But I'm not sure this is really a bug... should we count all the 1 whatever they are text or numeric ? -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs