https://bugs.documentfoundation.org/show_bug.cgi?id=160356
Bug ID: 160356
Summary: Calc should support Named Expressions as well
Product: LibreOffice
Version: 24.8.0.0 alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 193295
--> https://bugs.documentfoundation.org/attachment.cgi?id=193295&action=edit
Test file
Since bug 154449 was fixed, Calc now supports hidden named ranges. However,
named expressions were not considered in the patch and it would be useful to
support them as well.
Steps to reproduce
1) Open the "Test file"; it has no named ranges/expressions
2) Click the button "Create". It will run a macro that creates 2 hidden named
ranges:
Name1 -> Points to cell "D1" (since D1 is a reference, this is saved as a named
range to the file)
Name2 -> Points to the value "100" (since "100" is a value, this is saved as a
named expression to the file)
3) Open the Manage Names dialog (Sheet - Named Ranges - Manage)
4) Notice that nothing is shown, as expected, since both named ranges were
created as Hidden
5) Save the file and reload it (or close and reopen)
6) Open the Manage Names dialog again; Name1 will be hidden (as expected);
Name2 will not be hidden (this is the problem)
This is caused because Named Expressions still do not support the Hidden flag
for import/export.
System info
Version: 24.2.1.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 16; OS: Linux 6.5; UI render: default; VCL: kf5 (cairo+xcb)
Locale: pt-BR (pt_BR.UTF-8); UI: en-US
Ubuntu package version: 4:24.2.1~rc2-0ubuntu0.23.10.1~lo1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
