[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #52 from Commit Notification --- Marco Cecchetti committed a patch related to this issue. It has been pushed to "libreoffice-5-1":

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 Commit Notification changed: What|Removed |Added Whiteboard| target:5.2.0

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #51 from Commit Notification --- Marco Cecchetti committed a patch related to this issue. It has been pushed to "master":

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #50 from Commit Notification --- Marco Cecchetti committed a patch related to this issue. It has been pushed to "master":

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 Jean-Baptiste Faure changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #46 from Commit Notification --- Tor Lillqvist committed a patch related to this issue. It has been pushed to "libreoffice-5-1":

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 Commit Notification changed: What|Removed |Added Whiteboard| target:5.2.0

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 Jan Holesovsky changed: What|Removed |Added Status|NEW |RESOLVED

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 Jan Holesovsky changed: What|Removed |Added Status|RESOLVED|VERIFIED

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #47 from Cor Nouws --- Hi Tor! Thanks for all the effort you've put into this - and fun (.., now and then) to read the log with surprises and cry outs ;) Now testing in Version: 5.2.0.0.alpha0+ Build ID:

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 Commit Notification changed: What|Removed |Added Whiteboard|

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #45 from Commit Notification --- Tor Lillqvist committed a patch related to this issue. It has been pushed to "master":

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #44 from Tor Lillqvist --- https://gerrit.libreoffice.org/#/c/22153/ -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #41 from Tor Lillqvist --- When trying the above change, just delete the contents of cells A1:A4, for instance, to see another bug. You get a bunch of #VALUE! errors. What should happen is that the empty cells

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #42 from Tor Lillqvist --- Note that for empty cells, the corresponding entries in the mpNumericArray is set to NaNs. If I understand correctly, if such a value is used then in normal additions or other

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #43 from Tor Lillqvist --- Sigh, and turning the NaNs into zeros in the ArraySumFunctor constructor isn't easy either because of constness: the mpNumericArray member of VectorRefArray is a pointer to const

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #37 from Ljiljan --- In new file, if you delete content of any row (complete content) and press SHIFT + F9 it works until that empty row. Could it be that software interpreter misinterpret when it should

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #39 from Tor Lillqvist --- Hmm. Simply removing this bit: if (mnRowStart >= mpToken->GetRefRowSize()) { return ScMatrix::IterateResult(0.0, 0.0, 0); } else makes the calculations in the B

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #38 from Tor Lillqvist --- One problem seems to be that in ScVectorRefMatrix::Sum() for the rows that are after the first n, where n is the number of rows affected by the formula, the function just returns some

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #40 from Tor Lillqvist --- Changing the GetRefRowSize() to GetArrayLength() in ScVectorRefMatrix::Sum() has some beneficial effects, but then introduces other kinds of breakage for some corner cases (empty cells).

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 Tor Lillqvist changed: What|Removed |Added Attachment #122327|0 |1 is

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #31 from Tor Lillqvist --- Created attachment 122325 --> https://bugs.documentfoundation.org/attachment.cgi?id=122325=edit More minimal test file that exhibits the problem. Slimmed down from original bugdoc --

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #33 from Tor Lillqvist --- Or actually, the trick works only for rows 3 and higher. -- You are receiving this mail because: You are the assignee for the bug. ___

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #32 from Tor Lillqvist --- Also for the above tdf97369-minimal.ods does the "trick" in comment #30 work (for any row, as far as I see, does not have to be 4, or 8). -- You are receiving this mail because: You

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #34 from Tor Lillqvist --- Created attachment 122327 --> https://bugs.documentfoundation.org/attachment.cgi?id=122327=edit Even simpler example Here the formulas sum cells in the same column. In the B column

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #35 from Tor Lillqvist --- ("relative addressing" is a concept that is used inside Calc when a bunch of similar formulas in the same column, on successive rows, are turned into a so-called formula group. These

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 Tor Lillqvist changed: What|Removed |Added OS|Linux (All) |All -- You are

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #29 from Tor Lillqvist --- I meant E column, of course -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #30 from Tor Lillqvist --- I have no idea why, but if I, in the original document: - Select row 8, right-click:Insert Rows Above - (a new row 8 with empty cells appears) - Press Ctrl+Shift+F9 - (the cells E4:E7

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #28 from Tor Lillqvist --- There is something mysterious with the document that I can't figure out. If I clean out everything except the rows and columns on the first sheet that contains the columns A-D of numbers

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #27 from Ljiljan --- > Actually this is not an OpenCL bug, but related to the Software Interpreter, > I > think. Probably could be resolved as duplicate of bug #97204. Yes, when software interpreter is

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 Tor Lillqvist changed: What|Removed |Added Blocks||97391 -- You are

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 Tor Lillqvist changed: What|Removed |Added Blocks|97391 | -- You are

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #26 from Tor Lillqvist --- Actually this is not an OpenCL bug, but related to the Software Interpreter, I think. Probably could be resolved as duplicate of bug #97204. -- You are receiving this mail because: You

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #22 from Cor Nouws --- (In reply to Ljiljan from comment #19) > I run "clinfo" and this is the output. I don't find it useful. > > "Number of platforms 0" Same for me. >

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #25 from Cor Nouws --- Created attachment 122238 --> https://bugs.documentfoundation.org/attachment.cgi?id=122238=edit openCL test file 32 bits ubuntu Version: 5.2.0.0.alpha0+ Build ID:

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #23 from Cor Nouws --- Would the test file, resulting from .. Options > Calc > Formula .. Detailed Calculation settings .. Details be useful? (showing many cells with Err:509) -- You are receiving this

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #24 from Tor Lillqvist --- (In reply to Cor Nouws from comment #23) > Would the test file, resulting from > .. Options > Calc > Formula .. Detailed Calculation settings .. Details > be useful? (showing many

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #21 from Ljiljan --- Another observation: If I insert an empty row (row number 8) and empty row (row number 15), all formulas are working between these two empty rows (CTRL + SHIFT + F9 is required)... then

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #16 from Tor Lillqvist --- Works for me on Windows, AMD A10-7800, latest drivers. -- You are receiving this mail because: You are the assignee for the bug. ___

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #20 from Ljiljan --- What I've observed as well: In attached ODS file, the results of SUM function is "0" for many rows. However, if I type again "=SUM(" and then select the previous three columns + ")"...

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #18 from Tor Lillqvist --- (side rant: I was not able to open the video. Attaching videos to bug reports is in most cases fairly useless. It is much easier to read a good textual description of a problem. And if

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #17 from Tor Lillqvist --- What OpenCL software do you have on the Linux box where the problem happens? Do you have the clinfo program? (Should be available as a package in most distros, I assume.) Run clinfo and

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #19 from Ljiljan --- I run "clinfo" and this is the output. I don't find it useful. "Number of platforms 0" However, this is the output from Tools-> Options -> LibreOffice ->

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 Cor Nouws changed: What|Removed |Added Summary|SUM formulas, in the cell |SUM formulas, in

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #13 from Jean-Baptiste Faure --- Ctrl+Shift+F9 works for me if I disable OpenCL and if I disable the use of Software Interpreter. Disabling only OpenCL is not enough. Cor: 100 is the minimal data size

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 --- Comment #14 from Ljiljan --- Some info (I don't know if this is useful): Original ODS file was created by Moodle (I downloaded list of students from Moodle by selecting Export to ODS) and then I created the table in

[Libreoffice-bugs] [Bug 97369] SUM formulas, in the cell below one with the same formula (and maybe more?) are not calculate correctly in 5.1 (with more then ~100 rows)

https://bugs.documentfoundation.org/show_bug.cgi?id=97369 Eike Rathke changed: What|Removed |Added CC|