https://bugs.documentfoundation.org/show_bug.cgi?id=164054
Bug ID: 164054
Summary: Libre Calc Named Ranges
Product: LibreOffice
Version: 24.8.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When creating Named Ranges using Sheet>Named Ranges & Expressions>Manage there
is no was to specify multiple ranges. This is straight forward in Excel.
While moving a sheet from Excel to Libre I notice this, a sheet button which
referenced cells $J$16, $C$20 and $B$27:$I47 no longer high lighted those sells
when pressed. The reason for selecting these sells with the button is to delete
cell data ready for next input without using Macros. The example code used by
Excel is.
=Sheet!$J$16,Sheet!$C$20,Sheet!$I$20,Sheet!$B$27:$I$47
While this may be by current Libre design its one area of incompatibility that
would be nice to fix as we are all safer without Macros enabled. ;>)
Steps to Reproduce:
1.Create a new Named Range
2.In the Range or Formula expression field type: $sheet.$J$16,$sheet.$C$20
3.Click ok and add this Named Range to a button.
Actual Results:
The Range Errors as its is invalid as only one range can be entered.
Expected Results:
When Pressed the button should select (highlight) all the cells defined in the
ranges.
Reproducible: Always
User Profile Reset: No
Additional Info:
When Pressed the button should select (highlight) all the cells defined in the
ranges.
--
You are receiving this mail because:
You are the assignee for the bug.
