[Libreoffice-bugs] [Bug 97920] Strange behavior of simple integer sum() function
https://bugs.documentfoundation.org/show_bug.cgi?id=97920 --- Comment #2 from Franklin Weng --- Created attachment 122708 --> https://bugs.documentfoundation.org/attachment.cgi?id=122708&action=edit Formula in A9 cell (=sum(C9:I9)) -- 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 97920] Strange behavior of simple integer sum() function
https://bugs.documentfoundation.org/show_bug.cgi?id=97920 --- Comment #1 from Franklin Weng --- Created attachment 122707 --> https://bugs.documentfoundation.org/attachment.cgi?id=122707&action=edit The screenshot opening the file -- 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 97920] Strange behavior of simple integer sum() function
https://bugs.documentfoundation.org/show_bug.cgi?id=97920 Franklin Weng changed: What|Removed |Added Attachment #122708|Formula in A9 cell |Correct in A9 cell if I set description|(=sum(C9:I9)) |it to =sum(C9:H9) -- 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 97920] Strange behavior of simple integer sum() function
https://bugs.documentfoundation.org/show_bug.cgi?id=97920 --- Comment #3 from Franklin Weng --- Created attachment 122709 --> https://bugs.documentfoundation.org/attachment.cgi?id=122709&action=edit Sum was wrong if I set A9 to sum(C9:I9) -- 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 97920] Strange behavior of simple integer sum() function
https://bugs.documentfoundation.org/show_bug.cgi?id=97920 --- Comment #4 from Franklin Weng --- Created attachment 122710 --> https://bugs.documentfoundation.org/attachment.cgi?id=122710&action=edit Correct in A9 again if I set it to sum(C9:J9) -- 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 97920] Strange behavior of simple integer sum() function
https://bugs.documentfoundation.org/show_bug.cgi?id=97920 --- Comment #5 from Chris Mayfield --- Created attachment 122774 --> https://bugs.documentfoundation.org/attachment.cgi?id=122774&action=edit Incorrect sums in column J, correct percents in column K -- 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 97920] Strange behavior of simple integer sum() function
https://bugs.documentfoundation.org/show_bug.cgi?id=97920 --- Comment #6 from Chris Mayfield --- I am seeing this issue too -- it appears to affect horizontal sums. See attached sum_and_pct.ods, created using 1:5.1.0~rc3-0ubuntu1~trusty0. What's interesting is that the sums are 0, but the percentages in the next column are correct. When I open this file on my Mac using version 4.3.7.2, it displays the correct sums. -- 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 97920] Strange behavior of simple integer sum() function
https://bugs.documentfoundation.org/show_bug.cgi?id=97920 Beluga changed: What|Removed |Added CC||todven...@suomi24.fi --- Comment #7 from Beluga --- A9 is 45 for me in attachment 122706 Sums in J are not 0 for me in attachment 122774 Win 7 Pro 64-bit, Version: 5.1.0.3 (x64) Build ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; Locale: fi-FI (fi_FI) Version: 5.2.0.0.alpha0+ Build ID: ef02de2698d90fd874bddf3146165cbe85487bc5 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@39, Branch:master, Time: 2016-02-19_23:40:50 Locale: fi-FI (fi_FI) -- 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 97920] Strange behavior of simple integer sum() function
https://bugs.documentfoundation.org/show_bug.cgi?id=97920 raal changed: What|Removed |Added Keywords||regression Priority|medium |high Status|UNCONFIRMED |NEW CC||r...@post.cz Ever confirmed|0 |1 Severity|normal |major --- Comment #8 from raal --- Confirm. Version: 5.2.0.0.alpha0+ Build ID: ef02de2698d90fd874bddf3146165cbe85487bc5 CPU Threads: 1; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@39, Branch:master, Time: 2016-02-19_23:40:50 even CTRL+shift+F9 doesn't help. When rewrite the formula by drag formula from A8, then it works. When I delete formula and write formula again, the result is bad. Raise importance, because SUM is basic function. LibreOffice/5.1.0.3$Windows_x86 works correct in Version: 4.3.0.0.alpha1+, regression. -- 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 97920] Strange behavior of simple integer sum() function
https://bugs.documentfoundation.org/show_bug.cgi?id=97920 raal changed: What|Removed |Added Keywords||bibisected, bisected CC||ke...@collabora.com --- Comment #9 from raal --- This seems to have begun at the below commit. Adding Cc: to Jan Holesovsky; Could you possibly take a look at this one? Thanks 0e1c7b8968a73e15cd6b03dc5a99b31aa9c86f9a is the first bad commit commit 0e1c7b8968a73e15cd6b03dc5a99b31aa9c86f9a Author: Norbert Thiebaud Date: Wed Dec 9 00:28:54 2015 -0800 source sha:0bf39de7e54f041ade0f659db47cabcc6589ada7 source sha:0bf39de7e54f041ade0f659db47cabcc6589ada7 :04 04 bd5626b7099668d9f2edbea7cf3fc86b44758421 e8a0694e88355f9a10321ca4e78ee2669e7d366c M instdir authorJan Holesovsky 2015-11-30 11:32:16 (GMT) committerJan Holesovsky 2015-12-03 15:14:03 (GMT) commit0bf39de7e54f041ade0f659db47cabcc6589ada7 (patch) tree8367f986fdb0d8c4ebdb036c13761de7aba4aff0 parent361dfe0cced6e621eea7b6b5e087b1aec9c3ba4a (diff) sc interperter: Turn it on for a subset of operations by default. -- 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 97920] Strange behavior of simple integer sum() function
https://bugs.documentfoundation.org/show_bug.cgi?id=97920 --- Comment #10 from Markus Mohrhard --- Might be a duplicated of Bug 98657 which I just fixed by globally disabling the SW group interpreter. -- 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 97920] Strange behavior of simple integer sum() function
https://bugs.documentfoundation.org/show_bug.cgi?id=97920 --- Comment #11 from Jan Holesovsky --- Franklin, Raal: Unfortunately I am having trouble reproducing it :-( I tried in the recent master (and libreoffice-5-1), and the problem did not appear to me. I tried to revert the fix from bug 98657; and still I cannot reproduce the behaviour. Franklin, Raal: Can you please re-try with the recent libreoffice-5-1 nightly build? Is the behaviour Windows-only? (I tested on Linux.) If you still see the problem, can you provide me with detailed step-by-step instructions? Like * click mouse in A9 * press Delete * type =sum(C9:I9) * now you can see the wrong result Or something - that will help me to reproduce it. Thank you! -- 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 97920] Strange behavior of simple integer sum() function
https://bugs.documentfoundation.org/show_bug.cgi?id=97920 --- Comment #12 from Andrew Horsfield --- I have a similar problem with LO 5.1.0.3 on a Mac. I have a rectangular grid of numbers, and want to find the total for each row. If I put =sum(c4:r4) in the top cell of the column holding the sums, and then copy the formula to all cells below (ctrl-C, highlight cells, ctrl-V) then I get zero for each row. However, if I highlight the first half of the column (about 50 rows), and paste into that, then highlight the second half and paste into that, it works. -- 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 97920] Strange behavior of simple integer sum() function
https://bugs.documentfoundation.org/show_bug.cgi?id=97920 --- Comment #13 from Jan Holesovsky --- Andrew: Can you please try with this build: http://dev-builds.libreoffice.org/daily/libreoffice-5-1/MacOSX-x86_64@49-TDF/2016-03-30_12.19.43/ 5.1.0.3 is too old, I've pushed recently a fix that I'd need to know if it helped in this case, or not :-) Thank you! -- 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 97920] Strange behavior of simple integer sum() function
https://bugs.documentfoundation.org/show_bug.cgi?id=97920 Jan Holesovsky changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #15 from Jan Holesovsky --- Andrew: Thank you for confirming! Let's close this bug then :-) Franklin, Raal: Please feel free to re-open if you still see the problem in your use case; in that case please provide more info. -- 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 97920] Strange behavior of simple integer sum() function
https://bugs.documentfoundation.org/show_bug.cgi?id=97920 --- Comment #14 from Andrew Horsfield --- When I paste the sum formula into all cells in the column, it now behaves as expected. So your fix passes this test. Thank you for fixing it. -- 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 97920] Strange behavior of simple integer sum() function
https://bugs.documentfoundation.org/show_bug.cgi?id=97920 --- Comment #16 from raal --- (In reply to Jan Holesovsky from comment #15) > Andrew: Thank you for confirming! Let's close this bug then :-) > > Franklin, Raal: Please feel free to re-open if you still see the problem in > your use case; in that case please provide more info. Works for me with Version: 5.2.0.0.alpha0+ Build ID: 5a8cd51780eaf362536284ee8bd388916a172690 CPU Threads: 1; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@42, Branch:master, Time: 2016-03-24_06:51:09 -- 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