[Libreoffice-bugs] [Bug 151909] Calc not including field (from other tab refer) in SUM
https://bugs.documentfoundation.org/show_bug.cgi?id=151909 ady changed: What|Removed |Added Resolution|--- |INSUFFICIENTDATA Status|UNCONFIRMED |RESOLVED --- Comment #16 from ady --- (In reply to TomC from comment #15) > (unless you want to try to figure out why Calc is not > automatically updating calculations). That would be great, but we would still need an example ods file. So for now, I'm closing this report. If the situation changes in a meaningful way, feel free to change the report back to "unconfirmed". -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151909] Calc not including field (from other tab refer) in SUM
https://bugs.documentfoundation.org/show_bug.cgi?id=151909 TomC changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 --- Comment #15 from TomC --- Regarding the request for a spreadsheet illustrating the error, EVERY TIME I have tried to "sanitize" my data, the error is no longer present aftwards, even though the column of figures is still using the total brought over from another tab. However, that might be a moot issue because I had completely forgotten something you told me previously: Hitting shift-ctrl-F9 will force a hard recalculation of the whole spreadsheet. When I remember to try this, the total reflects the correct amount. So, for whatever reason, Calc is not updating the calculations until forced. Since I have this workaround now, you can close the bug (unless you want to try to figure out why Calc is not automatically updating calculations). -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151909] Calc not including field (from other tab refer) in SUM
https://bugs.documentfoundation.org/show_bug.cgi?id=151909 ady changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #14 from ady --- @TomC, you changed the report from INSUFFICIENTDATA back to UNCONFIRMED, but you still have not provided a spreadsheet file. I would suggest making a copy of your file, and then modify the data and minimize the content of the spreadsheet file just enough to replicate the problem; eliminate anything unrelated. Please see https://wiki.documentfoundation.org/QA/Bugzilla/Sanitizing_Files_Before_Submission I'll mark this as NEEDINFO. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151909] Calc not including field (from other tab refer) in SUM
https://bugs.documentfoundation.org/show_bug.cgi?id=151909 --- Comment #13 from TomC --- I have the most recent version of Libre Office and am still experiencing the incorrect formula result. I have included 2 new screenshots, the 1st of which shows the formula used for the sum. The top # is a total brought over from another tab in the same file. That is the one not being used in the calculation. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151909] Calc not including field (from other tab refer) in SUM
https://bugs.documentfoundation.org/show_bug.cgi?id=151909 --- Comment #12 from TomC --- Created attachment 188113 --> https://bugs.documentfoundation.org/attachment.cgi?id=188113&action=edit Column of figures showing incorrect sum -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151909] Calc not including field (from other tab refer) in SUM
https://bugs.documentfoundation.org/show_bug.cgi?id=151909 --- Comment #11 from TomC --- Created attachment 188112 --> https://bugs.documentfoundation.org/attachment.cgi?id=188112&action=edit Column of figures with formula -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151909] Calc not including field (from other tab refer) in SUM
https://bugs.documentfoundation.org/show_bug.cgi?id=151909 TomC changed: What|Removed |Added Resolution|INSUFFICIENTDATA|--- Status|RESOLVED|UNCONFIRMED Ever confirmed|1 |0 --- Comment #10 from TomC --- Bug still present in version 7.3.7.2, under Linux Mint Mate 21.1 64-bit. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151909] Calc not including field (from other tab refer) in SUM
https://bugs.documentfoundation.org/show_bug.cgi?id=151909 QA Administrators changed: What|Removed |Added Resolution|--- |INSUFFICIENTDATA Status|NEEDINFO|RESOLVED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151909] Calc not including field (from other tab refer) in SUM
https://bugs.documentfoundation.org/show_bug.cgi?id=151909 --- Comment #9 from QA Administrators --- Dear TomC, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151909] Calc not including field (from other tab refer) in SUM
https://bugs.documentfoundation.org/show_bug.cgi?id=151909 --- Comment #8 from QA Administrators --- Dear TomC, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151909] Calc not including field (from other tab refer) in SUM
https://bugs.documentfoundation.org/show_bug.cgi?id=151909 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||79045_79...@mail.ru Ever confirmed|0 |1 --- Comment #7 from Roman Kuznetsov <79045_79...@mail.ru> --- (In reply to TomC from comment #3) > Unable to attach the spreadsheet in question because it contains most of my > personal financial information. Without example we can't do anything Set status to NEEDINFO while you can create some example without your "personal financial information" -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151909] Calc not including field (from other tab refer) in SUM
https://bugs.documentfoundation.org/show_bug.cgi?id=151909 --- Comment #6 from Eike Rathke --- If "once I make any kind of edit to the source tab/sheet" makes it recalculate properly then it may also help to force a hard recalculation with Shift+Ctrl+F9 once. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151909] Calc not including field (from other tab refer) in SUM
https://bugs.documentfoundation.org/show_bug.cgi?id=151909 --- Comment #5 from Eike Rathke --- Most likely the "number" you see is not numeric but text, SUM() and many other numeric functions working on cell ranges ignore text cells. Google Sheets is notoriously known to export bad documents. Without a sample there's nothing we can do. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151909] Calc not including field (from other tab refer) in SUM
https://bugs.documentfoundation.org/show_bug.cgi?id=151909 --- Comment #4 from TomC --- My theory is that something is happening to the file in passing it back & forth between LibreOffice and Google Sheets. Again, I usually edit the spreadsheet in the latter, but the totals in question are always correct. Then when I later open the spreadsheet in LibreOffice, the cell referencing the other tab/sheet is initially ignored in the SUM calculation. However, I'm finding that once I make any kind of edit to the source tab/sheet, then suddenly LibreOffice "sees" the total in that cell again, even if my edit made no change to the value. I attempted to create a sample spreadsheet that would reliably demonstrate the issue, but was unable to duplicate the problem, even after passing the test sheet back & forth between Google Sheets and LibreOffice. So I'm at a loss to explain the problem that I'm seeing in my Budget spreadsheet. Maybe something is just slightly different in the way the two pieces of software safe the spreadsheet file? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151909] Calc not including field (from other tab refer) in SUM
https://bugs.documentfoundation.org/show_bug.cgi?id=151909 --- Comment #3 from TomC --- Unable to attach the spreadsheet in question because it contains most of my personal financial information. The screenshot .jpg initially attached illustrates the issue. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151909] Calc not including field (from other tab refer) in SUM
https://bugs.documentfoundation.org/show_bug.cgi?id=151909 raal changed: What|Removed |Added CC||r...@post.cz --- Comment #2 from raal --- Please attach test file. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151909] Calc not including field (from other tab refer) in SUM
https://bugs.documentfoundation.org/show_bug.cgi?id=151909 --- Comment #1 from TomC --- Created attachment 183419 --> https://bugs.documentfoundation.org/attachment.cgi?id=183419&action=edit Attached screenshot shows the column of values w/the incorrect total -- You are receiving this mail because: You are the assignee for the bug.