Bug 159343

Summary: Function wizard breaks formula reference to database range
Product: LibreOffice Reporter: Gabor Kelemen (allotropia) <kelemeng>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: miguelangelrv
Priority: medium    
Version: Inherited From OOo   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=159341
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 137805    
Attachments: The example file in Excel 2016 and Calc master while in the Wizard
The example file after closing the wizard

Description Gabor Kelemen (allotropia) 2024-01-23 16:00:58 UTC 
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.
Comment 1 Gabor Kelemen (allotropia) 2024-01-23 16:01:22 UTC 
Created attachment 192125 [details]
The example file after closing the wizard
Comment 2 m_a_riosv 2024-01-24 01:45:19 UTC 
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