Max Depth:

Bug 115775 depends on 46 bugs:

view as bug list

•    115775: [META] Database Range and Consolidate bugs and enhancements [NEW; assigned to libreoffice-bugs]
  •    42196: Automatically extend the chart data source range when adding rows at the end [NEW; assigned to libreoffice-bugs]
  •    45862: [EDITING] Menu/Data/Consolidate, Only the last range to consolidate is saved in the file. [NEW; assigned to libreoffice-bugs]
  •    60167: Database ranges don't get saved when saving to Excel 97/XP/2003 [NEW; assigned to libreoffice-bugs]
  •    92981: Wrong error in bracketing from xls file [NEW; assigned to libreoffice-bugs]
  •    94048: Calc is too restrictive with naming cell ranges [NEW; assigned to libreoffice-bugs]
  •    117346: color of Auto-FILTER-▼-Button does not switch back from blue to black after Filter RESET, still shows old filter settings [NEW; assigned to libreoffice-bugs]
  •    122318: Not possible to create a dynamic Named Range with a calculated reference (like with OFFSET) and use it as a Print Range, like Excel can. [NEW; assigned to libreoffice-bugs]
  •    127419: EDITING: Database range is extended automatically against my wishes when filtering [NEW; assigned to libreoffice-bugs]
  •    132191: Refreshing a range applies the first data row's background color to all the other data rows [NEW; assigned to libreoffice-bugs]
  •    133529: Calc: ui: filesave: conflict between sort and filter, unclear use of tag 'table:orientation' [NEW; assigned to libreoffice-bugs]
  •    136363: calc: database-range definition broken on save-load cycle, (tag / attribute table:orientation="column" inserted) [NEW; assigned to libreoffice-bugs]
  •    137805: [META] XLSX (OOXML) Data range / Format as Table issues [NEW; assigned to libreoffice-bugs]
    •    66377: Support Table Styles / formatting coming from Excel's "Format As Table" [NEW; assigned to libreoffice-bugs]
    •    116331: XLSX FILEOPEN Reference to an external *.xlsx file’s data table results an Error:508 [NEW; assigned to libreoffice-bugs]
    •    122897: FILESAVE XLSX Spreadsheet with Database Range is incorrect when the document is opened in Excel [NEW; assigned to libreoffice-bugs]
    •    130577: FILEOPEN: XLSX import looses defined range definitions [NEW; assigned to libreoffice-bugs]
    •    132780: Feature Request: Add Calc Tables with functionality similar to Excel's "Format as tables" [NEW; assigned to libreoffice-bugs]
    •    136541: Fileopen XLSX and XLS: Some filter cells have no color [NEW; assigned to libreoffice-bugs]
    •    137846: FILEOPEN XLSX Defined name pointing to data table does not resolve source file name [NEW; assigned to libreoffice-bugs]
    •    137847: FILESAVE XLSX Named range pointing to data range in external file breaks [NEW; assigned to libreoffice-bugs]
    •    138704: FILEOPEN XLSX AutoFilter in Table imported incorrectly, interacts weirdly with normal autofilter [NEW; assigned to libreoffice-bugs]
    •    139499: FILESAVE XLSX Mangled structured references in Data Validity cell range criterion (column name saved in lowercase) [NEW; assigned to libreoffice-bugs]
    •    143058: FILEOPEN XSLX following SAVE from ODS when Range Names are "large: [NEW; assigned to libreoffice-bugs]
    •    159341: FILEOPEN XLSX Item references to table are not imported correctly [NEW; assigned to libreoffice-bugs]
    •    159343: Function wizard breaks formula reference to database range [NEW; assigned to libreoffice-bugs]
    •    126926: Extra filter icon appears on deleting sheet columns [VERIFIED FIXED; assigned to tundeth]
    •    131424: FILEOPEN XLSX Table reference broken if named table header contains comma [RESOLVED FIXED; assigned to erack]
    •    132519: CELL("ADDRESS";...) to other sheet from Workbook imported from Excel may let INDIRECT() fail with #REF! if string reference setting forces different syntax than current formula syntax (comment 9). [RESOLVED FIXED; assigned to erack]
    •    137091: XLSX: Error 507 when opened with Turkish locale [VERIFIED FIXED; assigned to erack]
    •    144786: FILEOPEN XLSX Hidden status of Table/Data range filter button not imported [RESOLVED FIXED; assigned to libreoffice-bugs]
    •    147096: XLSX - Calc validity dropdown selection doesn't work, a range name is missing [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
  •    144048: Calc: Define Range doesn't set selected range [NEW; assigned to libreoffice-bugs]
  •    147082: Copying Sheet should also copy Range [NEW; assigned to libreoffice-bugs]
  •    148679: Database range (and its column labels / totals settings) is not considered when expanding the range for sorting [NEW; assigned to libreoffice-bugs]
  •    152095: Enhancement request : adding 'Data - Refresh all ranges' command [NEW; assigned to libreoffice-bugs]
  •    153221: FILESAVE ODS Cell Validation source as structured reference is saved as absolute cell reference [NEW; assigned to libreoffice-bugs]
  •    155881: Saving causes consolidate dialog to fill up with garbage ranges [NEW; assigned to libreoffice-bugs]
  •    157211: EDITING: cell range selection modified when opening Calc's "Define Database Range" dialog [NEW; assigned to libreoffice-bugs]
  •    160018: Defined Ranges in a single column with delimiting row corrupted by 7.6.5 (STR comment 5) [NEW; assigned to libreoffice-bugs]
  •    59312: AUTOFILTER: in non functional after 'Copy Sheet' in new sheet [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    97907: Sort extends database range (user is asked if the selection has to be extended with ...) [RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
  •    113585: Auto Filter Columns are Treated Separately in the Attached ODS File [RESOLVED NOTABUG; assigned to libreoffice-bugs]
  •    115520: Define Database Range shouldn't close after having a false name [VERIFIED FIXED; assigned to tundeth]
  •    123598: Autofilter removed from output range after save & reload [VERIFIED FIXED; assigned to tundeth]
  •    152577: Database range disappears when deleting a sheet it doesn't belong to [VERIFIED FIXED; assigned to tundeth]
  •    155369: Formula Calculation: Indirect() returns #REF! [VERIFIED FIXED; assigned to dennisfrancis.in]

Bug 115775 blocks 2 bugs:

view as bug list

•    115775: [META] Database Range and Consolidate 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]

Max Depth:

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    [x]
  • | Forgot Password
    Login: [x]