https://bugs.documentfoundation.org/show_bug.cgi?id=89373
--- Comment #6 from andis.lazd...@gmail.com ---
Hello!
It's funny, but when I tried to reconstruct formulas in example file using
another worksheet instead of linked file, I was able to repeat the error.
Result of the experiments is attached to the bug report.
It is interesting, that some values are causing error ("220", "945") and some
values are calculated as they should be ("375"). No problems found in version
4.3.6.2. So there is working example of the problem.
Regarding use of Libreoffice in complex calculations. I would say, that it is
much, much better than excel, when there is need to use lot of sumif(),
lookup(), hlookup() and other array functions. Statistical functions like
ttest() are not limited to equal number of values in compared ranges and so on.
I can't imagine returning to Excel now; the worst case would be returning to
openoffice.org, which is much better and faster with large data ranges, because
CPU use is another madness introduced somewhere with 3.5.x version.
Some time ago there was something wrong with calculations in pivot tables and
since that I'm always checking results of calculations. But this is very
uncommon that mistakes appear in basic functions.
Best regards
--
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
