[Bug 130722] Can't use "Multiple Operations" with a DSUM function
https://bugs.documentfoundation.org/show_bug.cgi?id=130722 --- Comment #11 from QA Administrators --- Dear Dan Chall, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130722] Can't use "Multiple Operations" with a DSUM function
https://bugs.documentfoundation.org/show_bug.cgi?id=130722 --- Comment #10 from Dan Chall --- (In reply to Mike Kaganski from comment #8) Nice workaround. Confirming that I updated the excel spreadsheet with the recommended fix, and that the formulas compute correctly when the sheet is opened in LibreOffice. Thanks. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130722] Can't use "Multiple Operations" with a DSUM function
https://bugs.documentfoundation.org/show_bug.cgi?id=130722 --- Comment #9 from Mike Kaganski --- Eike: it *seems* to me that the replacement of the input cell's value should be implemented as if the input cell had formula '=', right? Not by modifying something else? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130722] Can't use "Multiple Operations" with a DSUM function
https://bugs.documentfoundation.org/show_bug.cgi?id=130722 --- Comment #8 from Mike Kaganski --- (In reply to Dan Chall from comment #5) A *workaround* would be to make the input cell be outside of the range mentioned in the formula cell. Namely, DSUM formula (used in the MULTIPLE.OPERATION and Excel's table) refer to F4:F5 range; and the input cell (the variable which value gets changed in the MULTIPLE.OPERATIONS/table) is F5 which is part of the mentioned range. If instead you put "Bill" to, say, G5; and change B5 to '=G5'; and change input cell of the MULTIPLE.OPERATIONS/table to G5 (so it's not part of resulting formula's ranges), then it would work. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130722] Can't use "Multiple Operations" with a DSUM function
https://bugs.documentfoundation.org/show_bug.cgi?id=130722 Mike Kaganski changed: What|Removed |Added Status|NEEDINFO|NEW --- Comment #7 from Mike Kaganski --- Thanks Dan; your sample is really helpful! -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130722] Can't use "Multiple Operations" with a DSUM function
https://bugs.documentfoundation.org/show_bug.cgi?id=130722 Mike Kaganski changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||8983 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130722] Can't use "Multiple Operations" with a DSUM function
https://bugs.documentfoundation.org/show_bug.cgi?id=130722 --- Comment #6 from Dan Chall --- My original report two years ago showed an ODS file that demonstrated the failure of a calculation. I just added an Excel file that computes correctly in Excel, but when I open it in LibreOffice, there's an error. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130722] Can't use "Multiple Operations" with a DSUM function
https://bugs.documentfoundation.org/show_bug.cgi?id=130722 --- Comment #5 from Dan Chall --- Created attachment 17 --> https://bugs.documentfoundation.org/attachment.cgi?id=17&action=edit This excel file shows how the computations work in Excel I don't remember much about this issue but it has resurfaced so I'm doing my best to show what works in Excel but not LibreOffice. I don't remember whether I had to tweak the formulas to reflect application differences, but the computations were straightforward analogues. I'm unable to demonstrate the problem by opening the ods file in Excel and showing the success, but when I open this XLS file in ODS it demonstrates the problem in LibreOffice. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130722] Can't use "Multiple Operations" with a DSUM function
https://bugs.documentfoundation.org/show_bug.cgi?id=130722 Mike Kaganski changed: What|Removed |Added CC||er...@redhat.com Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130722] Can't use "Multiple Operations" with a DSUM function
https://bugs.documentfoundation.org/show_bug.cgi?id=130722 Mike Kaganski changed: What|Removed |Added Resolution|DUPLICATE |--- Status|RESOLVED|UNCONFIRMED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130722] Can't use "Multiple Operations" with a DSUM function
https://bugs.documentfoundation.org/show_bug.cgi?id=130722 --- Comment #4 from Mike Kaganski --- (In reply to Mike Kaganski from comment #3) > So it *looks like* an interoperability issue. It would be nice to check what > Excel does in this case. Note that trying to re-create the calculation using Excel 2016's What-If analysis (one-variable data table [1]) on the data from attachment 157933, moving F4:F5 to F10:F11, I4 to H10, clearing H11:H13, selecting G10:H13, running the Excel's "Data Table", and selecting G11 as "Column input cell", I get "Input cell reference not valid" error from Excel. Indeed, I might do it all wrong; a sample spreadsheet doing this from Excel would hopefully clarify. [1] https://support.microsoft.com/en-us/office/calculate-multiple-results-by-using-a-data-table-e95e2487-6ca6-4413-ad12-77542a5ea50b -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130722] Can't use "Multiple Operations" with a DSUM function
https://bugs.documentfoundation.org/show_bug.cgi?id=130722 --- Comment #3 from Mike Kaganski --- (In reply to Alex Thurgood from comment #2) > This seems like a DUP of bug 105683 to me. bug 105683 is about inline arrays in general, while this one is about something different, and no inline arrays are involved here in any way. Additionally, OP has mentioned in [1]: > What I did was to buy an MS Office subscription So it *looks like* an interoperability issue. It would be nice to check what Excel does in this case. [1] https://ask.libreoffice.org/t/why-multiple-operations-only-supports-simple-arithmetic-operations-but-not-some-complex-built-in-functions-in-libreoffice-calc/48096/6 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130722] Can't use "Multiple Operations" with a DSUM function
https://bugs.documentfoundation.org/show_bug.cgi?id=130722 Alex Thurgood changed: What|Removed |Added Resolution|--- |DUPLICATE Status|UNCONFIRMED |RESOLVED --- Comment #2 from Alex Thurgood --- This seems like a DUP of bug 105683 to me. See for example https://bugs.documentfoundation.org/show_bug.cgi?id=105683#c2 *** This bug has been marked as a duplicate of bug 105683 *** -- 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 130722] Can't use "Multiple Operations" with a DSUM function
https://bugs.documentfoundation.org/show_bug.cgi?id=130722 --- Comment #1 from Dan Chall --- Created attachment 157933 --> https://bugs.documentfoundation.org/attachment.cgi?id=157933&action=edit The simple spreadsheet illustrates the problem. I checked ask.libreoffice.org first and found one entry that seemed nominally to describe the sort of problem I found, and one of the comments suggested a posting of a bug report. That's why I came here. -- 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
