https://bugs.documentfoundation.org/show_bug.cgi?id=158859
Bug ID: 158859
Summary: Allow names for irregular ranges
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: LibreOffice
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: sanipache...@outlook.com.ar
Description:
Currently, if we select irregular ranges and try to assign them a name in
LibreOffice Calc, it throws an error because it's not supported. However, in
spreadsheets in general, this action is supported, and by not allowing it in
Calc, it reduces interoperability between different programs.
Steps to Reproduce:
1. Open Calc.
2. Select an irregular range.
3. Type a name in the name box.
4. Press ENTER.
Actual Results:
You will receive an error indicating that the action is not allowed.
Expected Results:
* The range receives a name.
* When opening spreadsheets in other formats, they should be recognized and
managed (selected, edited, deleted, etc.) in LibreOffice Calc.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
In Excel, you can name discontinuous ranges by separating the different ranges
with the argument separator character (in Argentina, the semicolon [;]; in some
areas of Mexico and the United States, the comma [,]).
For example:
A1:B5;C8:D10;F1
In the case of Google Sheets, it doesn't support naming irregular ranges but
does allow working with Excel files containing irregular ranges.
--
You are receiving this mail because:
You are the assignee for the bug.
