| Summary: | [EDITING] Named range gives an ERR result when deleting a row/column of their range, but the named reference erroneously remains fine. | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | m_a_riosv <miguelangelrv> |
| Component: | Calc | Assignee: | Eike Rathke <erack> |
| Status: | VERIFIED FIXED | ||
| Severity: | normal | Keywords: | regression |
| Priority: | medium | ||
| Version: | 5.0.5.2 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | target:6.0.0 target:5.4.0.1 target:5.3.5 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Test file | ||
|
Description
m_a_riosv
2017-06-21 11:23:42 UTC
Created attachment 134185 [details]
Test file
The #REF! is correct, as the cell is deleted which NamedRange refers. That NamedRange maintains the original reference is not correct, it should be #REF! as well. Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=6580e171ad054dca38f55822e67a400191cecdf5 Resolves: tdf#108671 mark named expression single reference #REF! if deleted It will be available in 6.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Pending review https://gerrit.libreoffice.org/39071 for 5-4 https://gerrit.libreoffice.org/39072 for 5-3 Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e074090cea379716096d7025a62ad1c756b4d14f&h=libreoffice-5-4 Resolves: tdf#108671 mark named expression single reference #REF! if deleted It will be available in 5.4.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://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 "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=2522bbeecc628bb16ee17286e11b54613f78b195 Unit test for named single reference pointing to deleted row, tdf#108671 It will be available in 6.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Tested with Version: 6.0.0.0.alpha0+ Build ID: 438c0ed5ea4116e93eb2167a53a740ba5097565f CPU threads: 4; OS: Windows 6.19; UI render: GL; TinderBox: Win-x86@42, Branch:master, Time: 2017-06-22_11:26:54 Locale: es-ES (es_ES); Calc: group Selecting the whole sheet1 and deleting all the columns/rows doesn't touch the name range reference ¿Is it ok? Tested with: Version: 6.0.0.0.alpha0+ Build ID: 4493f983d511990684588fbd141ec4f6ff0b40b6 CPU threads: 4; OS: Windows 6.19; UI render: GL; TinderBox: Win-x86@42, Branch:master, Time: 2017-06-24_00:22:15 Locale: es-ES (es_ES); Calc: group (In reply to m.a.riosv from comment #7) > Selecting the whole sheet1 and deleting all the columns/rows doesn't touch > the name range reference ¿Is it ok? Doesn't sound ok. I created bug 108788 for that. Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=777103737f9b20f680d9c9f3d0610e91383f7499&h=libreoffice-5-3 Resolves: tdf#108671 mark named expression single reference #REF! if deleted It will be available in 5.3.5. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. |