Created attachment 192124 [details] The example file in Excel 2016 and Calc master while in the Wizard If a formula containing table reference / database range is edited in the formula wizard, the range name is replaced with #NAME? upon closing the wizard. 1. Open attachment 192122 [details] from bug 159341 2. Go to cell H6, open the Formula Wizard 3. Close the Formula Wizard with the OK button -> the formula is changed, the Animals range name is replaced by #NAME? and the value of the formula becomes Err:507. Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d49b0c3654e50ff9b74545140e6f19e008009c33 CPU threads: 15; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: threaded Seems to be like this since 5.0 when importing Excel tables started to be supported.
Created attachment 192125 [details] The example file after closing the wizard
Reproducible Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d49b0c3654e50ff9b74545140e6f19e008009c33 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/0b683547bbb22cab46e92dfd65c129630bd9ca94 Related: tdf#159343 Handle TableRef separator in brackets for Function Wizard It will be available in 25.2.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.
That commit does not solve the problem, but only keeps the table structured reference together for one argument of a function's parameter in the wizard, not splitting it at the embedded separator. The actual problem of the name being lost is caused by the ocTableRef token not being implemented in the API token conversion. More work to do.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/4c3f65ea3b1f2e7f6d92c732f72936fecc017b29 Resolves: tdf#159343 Implement TableRef API token conversion It will be available in 25.2.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 "master": https://git.libreoffice.org/core/commit/6e12713a7938e464b55a54b9dfd662000057a85f Do not assert TableRef inner reference for dumb sequence, tdf#159343 It will be available in 25.2.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.