Created attachment 184222 [details] DBRange_disappears.ods The attached file has sheets Sheet1 and Sheet2. There is a Database Range named d_1 which refers to the range $Sheet1.$A$1. After deleting Sheet2, range d_1 "disappears": Menu / Data / Define Range... does not show ranges.
Reproducible even putting some data on a1:a2 Version: 7.4.3.2 (x64) / LibreOffice Community Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 9b46020c262045aed0beace4708565235c2523cc CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threadedCalc: CL
Last working for me: Version: 7.1.8.1 (x86) / LibreOffice Community Build ID: e1f30c802c3269a1d052614453f260e49458c82c CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: es-AR (es_ES); UI: es-ES Calc: CL
This seems to have begun at the below commit. Adding Cc: to Tünde Tóth ; Could you possibly take a look at this one? Thanks c7baa2dd3209b9db60ee0699536135109918915d is the first bad commit commit c7baa2dd3209b9db60ee0699536135109918915d Author: Jenkins Build User <tdf@pollux.tdf> Date: Wed Aug 18 01:46:13 2021 +0200 source 957d1e977d25385151c99e401124ad58217e53dd https://gerrit.libreoffice.org/c/core/+/120235
Tünde Tóth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/b88d11ba05085002cf847d4828ded52a3dfb3b09 tdf#152577 sc DBData: fix regression of database ranges It will be available in 7.6.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.
No lost of the data range when deleting Sheet2 Verified. Fixed in Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: b88d11ba05085002cf847d4828ded52a3dfb3b09 CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded Was bad in Version: 7.5.2.1 (X86_64) / LibreOffice Community Build ID: e8bf3b441b8370f8440b0339fd9490765a8d57ca CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
You can mark as Resolved, if everything is done.
Verified. Fixed in Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: b88d11ba05085002cf847d4828ded52a3dfb3b09 CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
Tünde Tóth committed a patch related to this issue. It has been pushed to "libreoffice-7-5": https://git.libreoffice.org/core/commit/3f778cbad0b3f00a09a9b2fbd60762c81eab1b41 tdf#152577 sc DBData: fix regression of database ranges It will be available in 7.5.4. 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.
Colleagues, thank you very much for fixing and verifying the bug!
Tünde Tóth committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/core/commit/d9650695d30bcd1a885636984881603ed64ad6df tdf#152577 sc DBData: fix regression of database ranges It will be available in 7.4.8. 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.
Tünde Tóth committed a patch related to this issue. It has been pushed to "libreoffice-7-4-7": https://git.libreoffice.org/core/commit/203ad95d0a7a0c8224ce58c0c3e90b417ae06de9 tdf#152577 sc DBData: fix regression of database ranges It will be available in 7.4.7. 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.