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
