Bugzilla – Dependency tree for
Bug 109178
[META] Named Cell Ranges and Formula Expressions bugs and enhancements
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
Max Depth:
Bug 109178
depends on 51 bugs:
view as bug list
109178:
[META] Named Cell Ranges and Formula Expressions bugs and enhancements
[NEW; assigned to libreoffice-bugs]
35296:
Defining Name to multiple selection in Calc
[NEW; assigned to libreoffice-bugs]
72594:
File links to range names don't work after re-opening file (unable to create VLOOKUP named range in another file)
[NEW; assigned to libreoffice-bugs]
60170:
Extend ODF to allow import and export of external range names.
[NEW; assigned to libreoffice-bugs]
87058:
column label functions do not update after inserting rows below title - needs save and reload including a hard recalc
[NEW; assigned to libreoffice-bugs]
94627:
FILEOPEN: CALC do not recognise cell names on .xlsb files
[NEW; assigned to libreoffice-bugs]
97967:
Highlighting of cell range just flash and disappear
[NEW; assigned to libreoffice-bugs]
103711:
The Eurosign € is not allowed in the name of an area inside the table
[NEW; assigned to libreoffice-bugs]
104990:
Named ranges do not follow the sort order.
[NEW; assigned to libreoffice-bugs]
108516:
Enhancement Request: allow for comments when defining named range
[NEW; assigned to libreoffice-bugs]
113237:
UI: autocomplete / suggest cell (range) names in cell range pickers
[NEW; assigned to libreoffice-bugs]
113680:
FILEOPEN XLS Named Ranges in form controls are dropped on open
[NEW; assigned to libreoffice-bugs]
123004:
EDITING: Sheet/Named ranges/Insert - Paste all, only pastes named ranges with global scope
[NEW; assigned to libreoffice-bugs]
127300:
[META] Issues with import/export/display of Excel built-in defined names
[NEW; assigned to libreoffice-bugs]
113596:
Default name of XLSX print ranges is displayed as _xlnm.Print_Area
[NEW; assigned to libreoffice-bugs]
118592:
FILEOPEN XLSX AutoFilter import erroneously requires FilterDatabase defined name
[NEW; assigned to libreoffice-bugs]
100034:
Impossible to persistently remove print-range restrictions in .xlsx spreadsheet
[VERIFIED FIXED; assigned to czeber.laszloadam]
109240:
FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing compatibility issue with Excel 2016 (file cannot be opened in Excel 2016)
[RESOLVED FIXED; assigned to libreoffice-bugs]
112567:
FILESAVE XLSX Rows to Repeat and Columns to Repeat properties in XLSX files created with Calc are saved as incorrect Named ranges (w Hungarian locale)
[VERIFIED FIXED; assigned to libreoffice-bugs]
112571:
FILESAVE XLSX New named range is created every time an Excel made spreadsheet that contains print ranges is saved as XLSX
[RESOLVED FIXED; assigned to aron.budea]
115159:
FILESAVE XLSX Print Titles are duplicated every time we export an XLSX file
[RESOLVED FIXED; assigned to libreoffice-bugs]
127301:
FILESAVE XLSX Adjusting autofilter range creates extra name range
[VERIFIED FIXED; assigned to varga.balazs3]
154449:
Calc should support hidden Named Ranges for better MSO compatibility
[RESOLVED FIXED; assigned to rafael.palma.lima]
131938:
If a data range is defined in a document, it is partly translated in formulas into the normal cell range after saving and re-opening the document
[REOPENED; assigned to libreoffice-bugs]
132358:
Part of content of window "Manage Names" not refreshed after deletion of named ranges
[NEW; assigned to libreoffice-bugs]
137577:
UI: resolve ambiguity for 'named ranges' with identical name and different scope
[NEW; assigned to libreoffice-bugs]
145185:
Name box -> Manage Names -> Range Options -> 'Filter' is not persisted when saved in xlsx format (Steps in comment 6)
[NEW; assigned to libreoffice-bugs]
145994:
references to named ranges in external files do not update on document open
[NEW; assigned to libreoffice-bugs]
156673:
Merged cells defined name display and creation differs in version 7.x to previous versions
[NEW; assigned to libreoffice-bugs]
159432:
Sort and/or filter Named Ranges And Expressions from Manager
[NEW; assigned to libreoffice-bugs]
159633:
UI: tables in which items can be "matched" by typing characters don't allow hyphen or underscore searches (- and _)
[NEW; assigned to libreoffice-bugs]
160255:
Named Ranges Should Be Able to be Used in Conditional Formatting Dialog Box
[UNCONFIRMED; assigned to libreoffice-bugs]
64086:
Fileopen: named cell ranges from MSO are not imported in charts (because not supported in LO)
[VERIFIED FIXED; assigned to varga.balazs3]
64595:
: When importing an Excel file named ranges duplicated across sheets corrupted
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
64885:
EDITING: range name completion doesn't understand that names can contain underscores
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
66250:
Use a Named range as data source for Chart
[VERIFIED FIXED; assigned to libreoffice-bugs]
67007:
UI: Name Box does not show a name in sheet scope when selecting a range
[VERIFIED FIXED; assigned to erack]
67492:
No support for named range subaddressing
[CLOSED FIXED; assigned to libreoffice-bugs]
81293:
The dialog “manage names” forgets size and column width settings
[VERIFIED FIXED; assigned to libreoffice-bugs]
81295:
Name Scope Handling is Incorrect
[CLOSED WONTFIX; assigned to libreoffice-bugs]
81435:
Names lose reference information when copying cell ranges (re-open at comment 16)
[CLOSED FIXED; assigned to libreoffice-bugs]
82211:
Manage Names pop-up re-size re-sizes wrong element
[VERIFIED FIXED; assigned to andreas.heinisch]
94423:
UNO/Java: cannot retrieve Named Ranges from .ods, but can from .xls/.xlsx
[RESOLVED NOTOURBUG; assigned to libreoffice-bugs]
99991:
UI: dialog Manage Names loses set individual size when Range Options is chosen
[RESOLVED FIXED; assigned to andreas.heinisch]
108989:
Add contextual UNO commands for name ranges and data validity to context menu
[VERIFIED FIXED; assigned to gulsah.1004]
109240:
FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing compatibility issue with Excel 2016 (file cannot be opened in Excel 2016)
[RESOLVED FIXED; assigned to libreoffice-bugs]
(*)
113991:
Named ranges without sheet reference are exported as corrupted XLS(X)
[RESOLVED FIXED; assigned to jluth]
114487:
Importing HTML creates questionable named ranges
[RESOLVED FIXED; assigned to jluth]
116670:
Manage Names Dialog does not repaint after resize
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
123724:
EDITING: sheet local named ranges become corrupt during deletion of sheet
[VERIFIED FIXED; assigned to libreoffice-bugs]
148072:
Sheet-local named expression destroyed with Cut-Paste-Undo
[RESOLVED FIXED; assigned to erack]
157318:
Named ranges defined at the sheet level are not exported to XLSX
[RESOLVED FIXED; assigned to rafael.palma.lima]
160064:
Named ranges created by the Solver should be hidden by default
[RESOLVED FIXED; assigned to rafael.palma.lima]
Bug 109178
blocks 3 bugs:
view as bug list
109178:
[META] Named Cell Ranges and Formula Expressions bugs and enhancements
[NEW; assigned to libreoffice-bugs]
108252:
[META] Cell-related bugs and enhancements (including formatting)
[NEW; assigned to libreoffice-bugs]
127204:
[META] Formatting bugs and Improvements
[NEW; assigned to libreoffice-bugs]
108253:
[META] Calc cell formula bugs and enhancements
[NEW; assigned to libreoffice-bugs]
108252:
[META] Cell-related bugs and enhancements (including formatting)
[NEW; assigned to libreoffice-bugs]
(*)
Max Depth: