https://bugs.documentfoundation.org/show_bug.cgi?id=159343
Bug ID: 159343
Summary: Function wizard breaks formula reference to database
range
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 137805
Created attachment 192124
--> https://bugs.documentfoundation.org/attachment.cgi?id=192124&action=edit
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 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.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=137805
[Bug 137805] [META] XLSX (OOXML) Data range / Format as Table issues
--
You are receiving this mail because:
You are the assignee for the bug.
