Bug 159343 - Function wizard breaks formula reference to database range
Summary: Function wizard breaks formula reference to database range
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX-DataRange
  Show dependency tree / graph
 
Reported: 2024-01-23 16:00 UTC by Gabor Kelemen (allotropia)
Modified: 2024-01-24 01:45 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
The example file in Excel 2016 and Calc master while in the Wizard (111.49 KB, image/png)
2024-01-23 16:00 UTC, Gabor Kelemen (allotropia) 		Details
The example file after closing the wizard (74.47 KB, image/png)
2024-01-23 16:01 UTC, Gabor Kelemen (allotropia) 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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