Max Depth:

Bug 103381 depends on 126 open bugs:

view as bug list

•    103381: [META] Pivot table (aka Data Pilot) bugs and enhancements [NEW; assigned to libreoffice-bugs]
  •    34107: Put pivot table on current sheet when the sheet name is not given. [NEW; assigned to libreoffice-bugs]
  •    37268: Data Pilot and sheet local defined named range insert menu entry inactive [NEW; assigned to libreoffice-bugs]
  •    40472: FORMATTING: Cannot format the DataPilot headers [NEW; assigned to libreoffice-bugs]
  •    41645: Pivot table formatting/sorting disappears on refresh (with no undo) [NEW; assigned to libreoffice-bugs]
  •    42378: UI: Clicking on data pilot table's top-left cell should show data field settings [NEW; assigned to libreoffice-bugs]
  •    43609: failing c++ based subsequenttest: ScDataPilotFieldObj::XDataPilotFieldGrouping::createDateGrouping [NEW; assigned to libreoffice-bugs]
  •    44763: Cell styles with localized names, in Pivot Table, replaced with en-US named styles, if pivot changed in en-US UI [NEW; assigned to libreoffice-bugs]
  •    46381: PIVOTTABLE: Display / Edit Source Ranges in case of DB Tables / Queries [NEW; assigned to libreoffice-bugs]
  •    47489: PIVOTTABLE:Weighted average in pivottable? [NEW; assigned to libreoffice-bugs]
  •    47523: Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source [ASSIGNED; assigned to felipelema]
  •    49095: PivotTable sort drop down should hide members that are filtered by another field. [NEW; assigned to libreoffice-bugs]
  •    51732: PIVOTTABLE: Formating Pivot Tables [NEW; assigned to libreoffice-bugs]
  •    60163: PIVOTTABLE: Highlight the destination area when overwriting non-empty cells [NEW; assigned to libreoffice-bugs]
  •    61700: PIVOTTABLE: Median and other functions in pivot table data fields [NEW; assigned to libreoffice-bugs]
  •    61793: PIVOTTABLE: (option to) auto refresh Pivot Table after changes in source [NEW; assigned to libreoffice-bugs]
  •    62930: PIVOTTABLE: Add multiple filter criteria to Pivot Table [NEW; assigned to libreoffice-bugs]
  •    71111: PIVOTTABLE: Possible confusions with pivot table function names (updated behaviour in Comment 8) [NEW; assigned to libreoffice-bugs]
  •    78486: Feature Request: Add Calculated Field in PIVOT TABLE [NEW; assigned to libreoffice-bugs]
  •    79332: self-contained pivot table. Implement pivot cache. [NEW; assigned to libreoffice-bugs]
  •    80177: Date values from registered database appear as numbers when using them in a Pivot table data [NEW; assigned to libreoffice-bugs]
  •    84425: PIVOTTABLE: Dynamic Table column field filter drop down menu not activated [NEW; assigned to libreoffice-bugs]
  •    88749: Edit>Delete Contents should not allow to delete Pivot Table [NEW; assigned to libreoffice-bugs]
  •    89102: PIVOTTABLE wont work if heading ends with asterisk [NEW; assigned to libreoffice-bugs]
  •    90665: PIVOTTABLE: Add possibility to "count distinct values" [NEW; assigned to libreoffice-bugs]
  •    92616: PIVOTTABLE: Grouped Column Fields problems including with drill to details [NEW; assigned to libreoffice-bugs]
  •    94487: Pivot Table: Fields list doesn't update [NEW; assigned to libreoffice-bugs]
  •    97513: In Pivot tables, compute sum for numbers and counts for other formats by default [NEW; assigned to libreoffice-bugs]
  •    98947: PIVOTTABLE: Drilling after sorting returns unsorted "drill" results [NEW; assigned to libreoffice-bugs]
  •    100244: CRASH: Pivot table seems to cause massive memory leak [NEW; assigned to libreoffice-bugs]
  •    104780: Impossible to copy and paste a Pivot Tables [NEW; assigned to libreoffice-bugs]
  •    106238: UI - pivot table - Custom sorting list dialog doesn't appear [NEW; assigned to libreoffice-bugs]
  •    106622: PIVOT TABLE: wrong selected fields of Page Fields after updating table [NEW; assigned to libreoffice-bugs]
  •    108235: Pivot table update on undo lags a step behind [NEW; assigned to libreoffice-bugs]
  •    108834: PIVOTTABLE: empty values filtering works incorrectly for Date type columns [NEW; assigned to libreoffice-bugs]
  •    109521: Refresh status of pivot tables is not clear [NEW; assigned to libreoffice-bugs]
  •    111511: PIVOT TABLE: Group renaming after undoing occurs an invalid name error [NEW; assigned to libreoffice-bugs]
  •    112171: Visible criteria not visible as caption when EDITING using FILTER in PIVOTTABLE [NEW; assigned to libreoffice-bugs]
  •    112416: [META] XLSX (OOXML) pivot table bugs [NEW; assigned to libreoffice-bugs]
    •    46535: VIEWING: No support for graphs from Office 2007 (function GETPIVOTDATA not works correctly) [NEW; assigned to libreoffice-bugs]
    •    81999: FILEOPEN: XLSX: self-contained filtered pivot table. Lost pivot table. [NEW; assigned to libreoffice-bugs]
    •    120931: FILEOPEN XLSX Total result is added to Pivot chart as value in Excel-made spreadsheet [NEW; assigned to libreoffice-bugs]
    •    122462: FILEOPEN XLSX, Xlsx cells have border in LO while they do not in MSO. (Example in comment #8) [NEW; assigned to libreoffice-bugs]
    •    122463: FILEOPEN XLSX, Word wrap is lost from pivot table labels in LO. [NEW; assigned to libreoffice-bugs]
    •    122465: FILEOPEN XLSX, Extra Data line and button appears in pivot table in Calc. [NEW; assigned to libreoffice-bugs]
    •    122468: FILEOPEN XLSX, Pivot table gets an extra empty column in LO. [NEW; assigned to libreoffice-bugs]
    •    122469: FILESAVE XLSX, A total result line appears in pivot table after saving [NEW; assigned to libreoffice-bugs]
    •    122470: FILEOPEN XLSX, Column and line labels in pivot table changes when opened in LO [NEW; assigned to libreoffice-bugs]
    •    122472: FILEOPEN XLSX, Pivot table’s cells lose all their formatting in LO [NEW; assigned to libreoffice-bugs]
    •    122473: FILEOPEN XLSX, Pivot table’s labels lose their orientation in LO [NEW; assigned to libreoffice-bugs]
    •    122474: FILEOPEN XLSX, Pivot table gets refreshed automatically when opened in LO [NEW; assigned to libreoffice-bugs]
    •    122476: FILEOPEN XLSX, Pivot table with extendable line gets distorted and its pivot diagram messed up [NEW; assigned to libreoffice-bugs]
    •    123225: Loss of functions in XLSX pivot table's context menu until refreshed (see comment 18) [NEW; assigned to libreoffice-bugs]
    •    124716: Pivot table's page field's cell data type does not match type of value in data source [NEW; assigned to libreoffice-bugs]
    •    124766: Exported pivot table crashes Excel when modifying years filter [NEW; assigned to libreoffice-bugs]
    •    126702: XLSX FILEOPEN Issues with partially grouped pivot table fields in Calc [NEW; assigned to libreoffice-bugs]
    •    130829: XLSX: Pivot Table has two-row headings while in Excel there is only one row, thus causes interoperative issues when formulas are referenced to the pivot table data [NEW; assigned to libreoffice-bugs]
    •    141410: Calc Pivot Table "% of Total" Display Value Setting not getting saved permanently for .XLSX format files [NEW; assigned to libreoffice-bugs]
    •    150954: Pivot table is gone after the file is saved in xlsx file [NEW; assigned to libreoffice-bugs]
    •    150961: Pivot table sorting option is gone after resaving in LO in xlsx format [NEW; assigned to libreoffice-bugs]
    •    151841: LO Calc Conditional Formatting Not Saved on Pivot Table When Saving to .xlsx [NEW; assigned to libreoffice-bugs]
    •    157399: The dynamic tables are not saved in XLSX format files [NEW; assigned to libreoffice-bugs]
    •    157989: FILEOPEN XLSX Pivot table filter field hides text next to it [UNCONFIRMED; assigned to libreoffice-bugs]
    •    158921: Exported pivot table with custom name field yields corrupt XLSX when opened in MSO [NEW; assigned to libreoffice-bugs]
    •    159264: FILEOPEN XLSX Pivot table style is not applied [NEW; assigned to libreoffice-bugs]
      •    66377: Support Table Styles / formatting coming from Excel's "Format As Table" [NEW; assigned to libreoffice-bugs]
    •    160310: FILEOPEN FILESAVE import and export xlsx with Pivot Table and Chart, errors [UNCONFIRMED; assigned to libreoffice-bugs]
    •    160404: FILEOPEN XLSX Pivot table is not imported if sheet protection has Pivot table editing enabled [NEW; assigned to libreoffice-bugs]
    •    160515: FILEOPEN XLSX Formula referencing Pivot table cells leaves incorrect result after pivot table resizing [UNCONFIRMED; assigned to libreoffice-bugs]
  •    112773: UI: EDITING Pivot Table Layout closed upon closing warning message [NEW; assigned to libreoffice-bugs]
  •    113002: LibreOfficeCalc: Pivot Table recurring data field name will added a simple quotation marks before number [NEW; assigned to libreoffice-bugs]
  •    114120: PIVOT TABLE : dimension bug [NEW; assigned to libreoffice-bugs]
  •    115935: PIVOT TABLE: add the option to link several tables as source on one pivot table. [NEW; assigned to libreoffice-bugs]
  •    116338: PIVOT TABLE: Filter in drop-down list stops working after ungrouping or regrouping values [NEW; assigned to libreoffice-bugs]
  •    117043: PIVOT TABLE: refresh bug [NEW; assigned to libreoffice-bugs]
  •    117853: The pivot table does not update when renaming a column [NEW; assigned to libreoffice-bugs]
  •    119807: Add slicers to tables and Pivot tables in Calc [NEW; assigned to libreoffice-bugs]
  •    120311: Pivot table filter locked empty when zero rows returned [NEW; assigned to libreoffice-bugs]
  •    122022: PIVOTTABLE : Drill details filter whole row instead of one cell [NEW; assigned to libreoffice-bugs]
  •    123226: Pivot table if Filter is used and then turned off, then column filter stops working [NEW; assigned to libreoffice-bugs]
  •    123358: Pivot Table default setting should be Count not Sum [NEW; assigned to libreoffice-bugs]
  •    123638: Pivot Refresh to be included in the Recalculate Hard(CTRL+SHIFT+F9) [NEW; assigned to libreoffice-bugs]
  •    124012: EDITING Pivot table row field sort direction is not applied [NEW; assigned to libreoffice-bugs]
  •    124629: Filtering a pivot table group field may hide all group fields, including the filtered one [NEW; assigned to libreoffice-bugs]
  •    124632: Pivot table: impossible to undo grouped field filtering [NEW; assigned to libreoffice-bugs]
  •    124812: [META] XLS pivot table bugs [NEW; assigned to libreoffice-bugs]
    •    60169: PIVOTTABLE Custom grand total name is not persistent when saved in xls [NEW; assigned to libreoffice-bugs]
  •    125836: Extend context menu in a pivot table with direct change actions [NEW; assigned to libreoffice-bugs]
  •    125837: Use table control for data field listing in pivot table layout dialogue [NEW; assigned to libreoffice-bugs]
  •    125853: Improve indications for folded data groups in a pivot table [UNCONFIRMED; assigned to libreoffice-bugs]
  •    125854: Customised sort order for a pivot table [NEW; assigned to libreoffice-bugs]
  •    125857: Improve indications for excluded data in a pivot table [NEW; assigned to libreoffice-bugs]
  •    128131: PIVOTTABLE: (option to) make Pivot Table refresh after opening a file [NEW; assigned to libreoffice-bugs]
  •    129088: Add opportunity to create a custom name for field in the Pivot table [NEW; assigned to libreoffice-bugs]
  •    129795: PIVOTTABLE - Can't change pivot table destination (overlapping destination) [NEW; assigned to libreoffice-bugs]
  •    131654: Rework the pivot table dialog and provide a preview [NEW; assigned to libreoffice-bugs]
  •    132518: PIVOTTABLE: Filter by year in Drop-down filter window doesn't work [NEW; assigned to libreoffice-bugs]
  •    132886: Pivot table refresh does not work [REOPENED; assigned to libreoffice-bugs]
  •    133173: Calc creates a wrong result when I use "Drill to details" option in Pivot table [NEW; assigned to libreoffice-bugs]
  •    135818: pivot table layout: hidden options not expanded when dialog maximized [NEW; assigned to libreoffice-bugs]
  •    135825: PIVOTTABLE: unintuitive referencing in copying sheets [NEW; assigned to libreoffice-bugs]
  •    137420: Pivot Table named range does not list database ranges [NEW; assigned to libreoffice-bugs]
  •    140027: EDITING inserting rows before pivot table in row 1 copies format and images from headings [NEW; assigned to libreoffice-bugs]
  •    140510: Pivot table changes the case (upper/lower) of the PivotTable sheet from the original sheet [NEW; assigned to libreoffice-bugs]
  •    140760: (PIVOTTABLE) selection of invalid constraint values possible and probably this irreversibly results in an empty pivot table [NEW; assigned to libreoffice-bugs]
  •    140806: FORMATTING: Pivot table style number format is ignored when source number format is set [NEW; assigned to libreoffice-bugs]
  •    145966: [PIVOTTABLE] Add =GETPIVOTDATA(...) formula when referencing data inside a pivot table [NEW; assigned to libreoffice-bugs]
  •    148100: Clarify the pivot tables dialog instructions label to mention double-clicking to edit the properties of a field item [NEW; assigned to libreoffice-bugs]
  •    149931: Allow multiple columns to be dragged when making pivot table [NEW; assigned to libreoffice-bugs]
  •    150182: Pivot Table Filter is inaccessible from main menu, and its label in context menu doesn't distinguish it from e.g. Standard Filter [NEW; assigned to libreoffice-bugs]
  •    150734: Filter to exclude empty cells on Pivot Table still shows empty cells when deselected [NEW; assigned to libreoffice-bugs]
  •    150981: Pivot table broken after cut/paste of the area containing the filter (and after undo) [NEW; assigned to libreoffice-bugs]
  •    153217: Pivot grouping expands to all pivots [NEW; assigned to libreoffice-bugs]
  •    153930: Pivot Table options discoverability [NEW; assigned to libreoffice-bugs]
  •    154197: Pivot Table with column named "Data" does not show in Data Fields pane -EDITING [NEW; assigned to libreoffice-bugs]
  •    155073: Calc doesn't save pivot table compact layout to ODS file format [ASSIGNED; assigned to dennisfrancis.in]
  •    155089: No way to create pivot table compact layout from scratch [NEW; assigned to libreoffice-bugs]
  •    156207: Pivot table compact layout icons placed at wrong place [NEW; assigned to libreoffice-bugs]
  •    157418: EDITING: when you copy sheets with a Pivot table to another spreadsheet, the copy is not a Pivot table [NEW; assigned to libreoffice-bugs]
  •    160107: FORMATTING: Pivot Row field with Compact layout supports only Standard Format [NEW; assigned to libreoffice-bugs]
  •    160178: [LOCALHELP] missing help pages for Calc pivot table grouping [NEW; assigned to libreoffice-bugs]
  •    160393: PIVOTTABLE: with Grouping: no Drilldown and Datasets missing [UNCONFIRMED; assigned to libreoffice-bugs]
  •    160394: PIVOTTABLE: Grouping in a 2nd table removes grouping in the first table [UNCONFIRMED; assigned to libreoffice-bugs]
  •    160395: PIVOTTABLE: Result Field can be deleted with the Del key [NEW; assigned to libreoffice-bugs]
  •    160396: PIVOTTABLE: Row Field's drop down menus missing when last Row Field set to Compact layout [UNCONFIRMED; assigned to libreoffice-bugs]
  •    160397: PIVOTTABLE: Compact layout missing Text values in Row Field [NEW; assigned to libreoffice-bugs]
  •    160750: PivotTable expand/show buttons overlap with row title/header [NEW; assigned to libreoffice-bugs]

Bug 103381 does not block any open bugs.

Max Depth:

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