Pivot Charts By Toma Vajngerl www.collaboraoffjce.co C o l l a - PowerPoint PPT Presentation

C o l l a b o r a P r o d u c t i v i t y Pivot Charts By Tomaž Vajngerl www.collaboraoffjce.co C o l l a b o r a P r o d u c t i v i t y m

Pivot Charts Work sponsored by Nantes New feature added in LibreOffjce 5.4 www.collaboraoffjce.com C o l l a b o r a P r o d u c t i v i t y

What are pivot charts... Pivot tables are used to extract informatjon from a (large) data set, pivot chart are then used to visualize the data. Chart using data from the pivot table... www.collaboraoffjce.com C o l l a b o r a P r o d u c t i v i t y

Pivot table data mapping www.collaboraoffjce.com C o l l a b o r a P r o d u c t i v i t y

Pivot table data provider Separate from “spreadsheet” data provider Takes pivot table data and maps it to the chart’s data sequences www.collaboraoffjce.com C o l l a b o r a P r o d u c t i v i t y

Synchronisatjon ● When the pivot table changes, the pivot chart must refresh the data ● Callback when the pivot table changes – already exists ● Rebuild the whole pivot chart ● charts only rebuild the data series www.collaboraoffjce.com C o l l a b o r a P r o d u c t i v i t y

Pivot chart types www.collaboraoffjce.com C o l l a b o r a P r o d u c t i v i t y

Additjon to charts: fjeld butuons ● To show the layout of the pivot table www.collaboraoffjce.com C o l l a b o r a P r o d u c t i v i t y

Data fjltering and the pop-up widget bridge To show the fjlter pop-up menu from pivot table Chart doesn’t have direct access to Calc so a bridge is needed www.collaboraoffjce.com C o l l a b o r a P r o d u c t i v i t y

ODF support ● Just needed the identjfjer of the pivot table ● Extended the “chart” element ● additjonal aturibute “loext:data-pilot-source” ● Currently in loext namespace ● Fallback when no pivot charts support: ● Use the available table data www.collaboraoffjce.com C o l l a b o r a P r o d u c t i v i t y

Copy/paste behaviour ● Same document, connects to the existjng pivot table ● Difgerent document, uses table data www.collaboraoffjce.com C o l l a b o r a P r o d u c t i v i t y

TODO OOXML support Creatjon of pivot table and chart together – menu item www.collaboraoffjce.com C o l l a b o r a P r o d u c t i v i t y

C o l l a b o r a P r o d u c t i v i t y Thanks for listening! By Tomaž Vajngerl