https://issues.apache.org/ooo/show_bug.cgi?id=122878
Bug ID: 122878
Issue Type: DEFECT
Summary: Define Names dialog enhancements
Product: Calc
Version: AOO 4.0.0
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: trivial
Priority: P3
Component: code
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Hi,
I am a heavy Define Names dialog user. I have a large number of inter-linked
large spreadsheets. The Define Names dialog is fantastic in that I can enter
hundreds of names columns, rows, cells, lookup table areas, and especially
formulas. Entering the formulas once and referencing them by name in multiple
spreadsheets has eliminated typo errors and significantly reduced the size of
the spreadsheet files.
Enhancement suggestions for the Define Names dialog:
1. Make the dialog window resizeable. The tiny text edit box for entering
formals makes editing extremely difficult.
2. Allow copy/paste or duplicating names with their formulas. Many times a
complex formula can have minor modifications, so duplicating would save time.
3. Allow changing a name and have it automatically changed where ever it is
used.
4. Allow deleting multiple names in the names list. Today only one name can be
selected and then pressing the Delete button.
5. Eliminate the need to close the Define Names dialog so that newly created
names become active for referencing in formulas.
6. When spreadsheet B is linked to spreadsheet A and the changes were made in
spreadsheet B's Define Names dialog (or a table size has changed), provide an
option to have all the referenced names in spreadsheet A be automatically
updated. Today they need to be either modified individually; or deleted one by
one in Spreadsheet A, close spreadsheet A, and reopen spreadsheet A. This is a
real pain when you have a large number of large spreadsheets!
Thank you,
Don
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
