[Libreoffice-bugs] [Bug 124454] Formula with SUMPRODUCT & MOD returns wrong value!
https://bugs.documentfoundation.org/show_bug.cgi?id=124454 GerardF changed: What|Removed |Added CC||gerard.farg...@orange.fr Status|NEEDINFO|NEW --- Comment #4 from GerardF --- Error is caused by double negative sign which returns négative number. Replacing "--" by "1*" gives expected results. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124454] Formula with SUMPRODUCT & MOD returns wrong value!
https://bugs.documentfoundation.org/show_bug.cgi?id=124454 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124454] Formula with SUMPRODUCT & MOD returns wrong value!
https://bugs.documentfoundation.org/show_bug.cgi?id=124454 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #3 from m.a.riosv --- Created attachment 150435 --> https://bugs.documentfoundation.org/attachment.cgi?id=150435=edit The example file with the formula cut into pieces. With the formula cut into pieces I can't see the error. I have not excel to test. Maybe excel gives negative values for MOD() function over negatives input. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124454] Formula with SUMPRODUCT & MOD returns wrong value!
https://bugs.documentfoundation.org/show_bug.cgi?id=124454 --- Comment #2 from dursoj...@gmail.com --- Sorry In original example, actual result is 4 and expected is 6. I attached a spreadsheet and can open up in excel and calc and enter values and see differences in results of two (Excel is calculating correctly) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124454] Formula with SUMPRODUCT & MOD returns wrong value!
https://bugs.documentfoundation.org/show_bug.cgi?id=124454 --- Comment #1 from dursoj...@gmail.com --- Created attachment 150427 --> https://bugs.documentfoundation.org/attachment.cgi?id=150427=edit Spreadsheet with formula -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs