https://bugs.documentfoundation.org/show_bug.cgi?id=172996
Bug ID: 172996
Summary: EDITING: bug when adding several dependent named
expressions at once
Product: LibreOffice
Version: 26.2.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
It looks like when adding several named expressions at once, they do not get
linked together correctly and produce surprising "#NAME?" errors.
A simple workaround is to validate all the named expressions once. Then reopen
the "Named Ranges and Expressions" dialog (Ctrl+F3) and touch the affected
formula (click in the formula box) to make libreoffice re-parse it.
Steps to Reproduce:
1. Open the "Named Ranges and Expression" dialog
2. Add an expression `data1 = 1`
3. Add an expression `data2 = data1`
4. Validate
5. Insert them both in the spreadsheet
Actual Results:
"=data2" shows "#NAME?"
Expected Results:
1
Reproducible: Always
User Profile Reset: No
Additional Info:
Additional Info:
Version: 26.2.4.2 (X86_64)
Build ID: 620(Build:2)
CPU threads: 8; OS: Linux 6.19; UI render: default; VCL: x11
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Debian package version: 4:26.2.3.2-2
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
