| Summary: | In Calc ver 7.3.0.3. =Sum covering a range of cells fails to adjust when additional values are added within the range | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | John Murphy <mhdpd1> |
| Component: | Calc | Assignee: | Eike Rathke <erack> |
| Status: | RESOLVED FIXED | ||
| Severity: | major | CC: | herbb623, lo, mhdpd1, miguelangelrv |
| Priority: | high | Keywords: | bibisectNotNeeded, regression |
| Version: | 7.3.0.1 rc | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=119083 https://bugs.documentfoundation.org/show_bug.cgi?id=147298 |
||
| Whiteboard: | target:7.4.0 target:7.3.1 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | ODS of 2 sheets each displaying the same issue slightly differently. | ||
|
Description
John Murphy
2022-02-12 21:24:56 UTC
Created attachment 178247 [details]
ODS of 2 sheets each displaying the same issue slightly differently.
Sheet 1 is a multi column data range with an =Sum and an =CountA at the top. In this sheet the column Sum and Count appear to work correctly when additional data is added to the range covered. However when the totals of the Sum and Count of all the columns is used in a simple =Sum(*:*)/Sum(*:*) to give an overall average it works initially but will not readjust if additional data is addte to other cells covered in the range.
Sheet 2 Is a simple two column data range set up as per Sheet 1. However I have noticed that when initially created, if data is added to the Left Hand column the overall average will not update, while data added to the RH column did update the O/A Avg. However having saved and closed the file, upon reopening it now does the same as Sheet 1 above.
I can't repro. Version: 7.3.0.3 (x64) / LibreOffice Community Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3 CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: default; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL Please test with a clean profile, Menu/Help/Restart in Safe Mode I can reproduce. Already changing values in column Sheet2.E does not trigger recalculation of Sheet2.I7, or similar any value on Sheet1 of Sheet1.M7 Version: 7.3.2.0.0+ / LibreOffice Community Build ID: a9f6d98859321e1b9029acc0c6e9347f4c1cf3b7 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-US Calc: threaded and Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 0bf0feb40ae5c394a14cdfe4f94fb98dd9053597 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-US Calc: threaded but not in Version: 7.2.5.2.0+ / LibreOffice Community Build ID: 9c01d1c680939900bb2ff564a6c999fd8c8bb8c1 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-US Calc: threaded Odd enough, on Sheet2 that happened only on one load, but reproducible on Sheet1. Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/a1f21d7094deb6f1ae5388718f2bc28eecd5737a Resolves: tdf#147398 Test Intersects() instead of Contains(), tdf#119083 It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Pending review https://gerrit.libreoffice.org/c/core/+/130012 for 7-3 https://gerrit.libreoffice.org/c/core/+/130013 for 7-3-1 Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-3": https://git.libreoffice.org/core/commit/963330b5605e2350a34405c4752989c43c223b78 Resolves: tdf#147398 Test Intersects() instead of Contains(), tdf#119083 It will be available in 7.3.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/51648c8de8dc060abc8dff1af105acfccadab77d tdf#147398: sc_ucalc_formula: Add unittest It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-3-1": https://git.libreoffice.org/core/commit/eb07d94074cbc06cea4d938068161bbb25442d0a Resolves: tdf#147398 Test Intersects() instead of Contains(), tdf#119083 It will be available in 7.3.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. *** Bug 147298 has been marked as a duplicate of this bug. *** |