[Libreoffice-bugs] [Bug 31577] Calc "INDIRECT" range intermittently fails
https://bugs.documentfoundation.org/show_bug.cgi?id=31577 Eike Rathke changed: What|Removed |Added Status|NEW |ASSIGNED Assignee|libreoffice-b...@lists.free |er...@redhat.com |desktop.org | -- 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
[Libreoffice-bugs] [Bug 31577] Calc "INDIRECT" range intermittently fails
https://bugs.documentfoundation.org/show_bug.cgi?id=31577 Matthew Francis changed: What|Removed |Added CC||fdb...@neosheffield.co.uk Hardware|x86 (IA32) |All Version|3.3.0 Beta3 |Inherited From OOo OS|Linux (All) |All --- Comment #21 from Matthew Francis --- Also occurs in OOo 3.3.0 -> Version: Inherited from OOo -- 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
[Libreoffice-bugs] [Bug 31577] Calc "INDIRECT" range intermittently fails
https://bugs.documentfoundation.org/show_bug.cgi?id=31577 --- Comment #20 from Phil Hibbs --- Confirming that this bug is still present in 4.4.0.3, both the original example that returns a blank, and the example from comment 19 that returns the wrong value from a VLOOKUP. -- 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
[Libreoffice-bugs] [Bug 31577] Calc "INDIRECT" range intermittently fails
https://bugs.freedesktop.org/show_bug.cgi?id=31577 --- Comment #19 from Phil Hibbs --- Created attachment 108349 --> https://bugs.freedesktop.org/attachment.cgi?id=108349&action=edit Step 1 for incorrect result demonstration I have isolated a set of steps that result in the WRONG value being returned, which I consider much more serious than a blank value (it would be embarrassing to send out an invoice with a blank value, but if I invoice a customer with an incorrect value then that would be much worse). 1. Load the attached file 2. Delete row 5 3. Observe that the result in B3 for the VLOOKUP of "g" changes from 7 to 8, which is the value that "h" would have returned As with the earlier symptoms, saving the file after the delete and re-loading does not exhibit the problem. It occurs to me that the root cause of the problem appears to be that the results of the VLOOKUP are being held in the form of a cell reference, i.e. the VLOOKUP of "g" is stored in the form of "The contents of Cell D7", and the deletion of the row is not causing this cell reference to be re-assessed. -- 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
[Libreoffice-bugs] [Bug 31577] Calc "INDIRECT" range intermittently fails
https://bugs.freedesktop.org/show_bug.cgi?id=31577 --- Comment #18 from Phil Hibbs --- The same behaviour is also observed with the OFFSET function instead of INDIRECT in step 4: 4. Put formula in B1 =VLOOKUP(A1,OFFSET($C$1,0,0,1048576,2),2,0) -- 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
[Libreoffice-bugs] [Bug 31577] Calc "INDIRECT" range intermittently fails
https://bugs.freedesktop.org/show_bug.cgi?id=31577 --- Comment #17 from Phil Hibbs --- Created attachment 108347 --> https://bugs.freedesktop.org/attachment.cgi?id=108347&action=edit Screenshot of an incorrect result being returned -- 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
[Libreoffice-bugs] [Bug 31577] Calc "INDIRECT" range intermittently fails
https://bugs.freedesktop.org/show_bug.cgi?id=31577 --- Comment #16 from Phil Hibbs --- The same thing happens if I delete row 3 first and then type in the formula with the INDIRECT function call - any row beyond the row that was deleted is not found by the VLOOKUP. While experimenting, I have also managed to get it to return the wrong result. The A column contains "h", the C and D columns on Row 6 contain "h" and 7 respectively, but the VLOOKUP in the B column returns 8. I will upload a screenshot showing the problem, as saved files ODS do not exhibit the problem when re-opened. -- 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
[Libreoffice-bugs] [Bug 31577] Calc "INDIRECT" range intermittently fails
https://bugs.freedesktop.org/show_bug.cgi?id=31577 --- Comment #15 from Phil Hibbs --- Bug is still present. Libre Office version: 4.3.2.2 Operating System: Windows 7 Enterprise SP1 I installed LiO fresh from the web site onto a new Windows 7 VM, followed my original instructions on a new blank workbook, and experienced the same behaviour. The formula in B2 stops working (returns blank instead of 26) when row 3 is deleted. -- 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
[Libreoffice-bugs] [Bug 31577] Calc "INDIRECT" range intermittently fails
https://bugs.freedesktop.org/show_bug.cgi?id=31577 --- Comment #14 from QA Administrators --- Please read this message in its entirety before responding. Your bug was confirmed at least 1 year ago and has not had any activity on it for over a year. Your bug is still set to NEW which means that it is open and confirmed. It would be nice to have the bug confirmed on a newer version than the version reported in the original report to know that the bug is still present -- sometimes a bug is inadvertently fixed over time and just never closed. If you have time please do the following: 1) Test to see if the bug is still present on a currently supported version of LibreOffice (preferably 4.2 or newer). 2) If it is present please leave a comment telling us what version of LibreOffice and your operating system. 3) If it is NOT present please set the bug to RESOLVED-WORKSFORME and leave a short comment telling us your version and Operating System Please DO NOT 1) Update the version field 2) Reply via email (please reply directly on the bug tracker) 3) Set the bug to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link: https://wiki.documentfoundation.org/QA/BugTriage There are also other ways to get involved including with marketing, UX, documentation, and of course developing - http://www.libreoffice.org/get-help/mailing-lists/. Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material -- 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
[Libreoffice-bugs] [Bug 31577] Calc "INDIRECT" range intermittently fails
https://bugs.freedesktop.org/show_bug.cgi?id=31577 Michael Stahl changed: What|Removed |Added Attachment #40805|application/octet-stream|application/vnd.oasis.opend mime type||ocument.spreadsheet -- 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
[Libreoffice-bugs] [Bug 31577] Calc "INDIRECT" range intermittently fails
https://bugs.freedesktop.org/show_bug.cgi?id=31577 Kohei Yoshida changed: What|Removed |Added Assignee|kohei.yosh...@suse.de |libreoffice-b...@lists.free ||desktop.org -- 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