From 4f1f8b8e993b98095bf50c9e432fb0400d318b1f Mon Sep 17 00:00:00 2001 From: Tomaž Vajngerl Date: Sun, 30 Mar 2014 21:12:27 +0200 Subject: pivot: new pivot table layout dialog This commit adds a new pivot table layout dialog which was implemented from scratch. Instead of custom controls this one uses list boxes for field entries which greatly reduces the code. It also fixes some visual and behaviour bugs and adds the possibility to edit the "Data" field. Change-Id: I6c01252acee5a2e8910e40e65904504d00e03057 --- sc/uiconfig/scalc/ui/pivottablelayoutdialog.ui | 789 +++++++++++++++++++++++++ 1 file changed, 789 insertions(+) create mode 100644 sc/uiconfig/scalc/ui/pivottablelayoutdialog.ui (limited to 'sc/uiconfig/scalc/ui/pivottablelayoutdialog.ui') diff --git a/sc/uiconfig/scalc/ui/pivottablelayoutdialog.ui b/sc/uiconfig/scalc/ui/pivottablelayoutdialog.ui new file mode 100644 index 000000000000..e1a7b9eb23d8 --- /dev/null +++ b/sc/uiconfig/scalc/ui/pivottablelayoutdialog.ui @@ -0,0 +1,789 @@ + + + + + + + False + Pivot Table Layout + dialog + 0 + + + False + vertical + 2 + + + False + end + + + gtk-ok + True + True + True + True + + + True + True + 0 + + + + + gtk-apply + True + True + True + True + + + True + True + 1 + + + + + gtk-close + True + True + True + True + + + True + True + 2 + + + + + False + True + end + 0 + + + + + True + False + True + True + 6 + 12 + + + True + False + 0 + 4 + Available Fields: + True + listbox-fields + + + + + + 2 + 0 + 1 + 1 + + + + + True + True + True + True + in + + + 200 + 100 + True + True + True + True + + + + + + + + 1 + 1 + 1 + 1 + + + + + True + True + True + True + in + + + 200 + 100 + True + True + True + True + + + + + + + + 1 + 3 + 1 + 1 + + + + + True + True + True + True + in + + + 200 + 100 + True + True + True + True + + + + + + + + 0 + 3 + 1 + 1 + + + + + True + True + True + True + in + + + 200 + 100 + True + True + True + True + + + + + + + + 0 + 1 + 1 + 1 + + + + + True + False + False + False + 0 + 0 + 4 + Page Fields: + True + listbox-page + + + + + + 0 + 0 + 1 + 1 + + + + + True + False + False + False + 0 + 0 + 4 + Column Fields: + True + listbox-column + + + + + + 1 + 0 + 1 + 1 + + + + + True + False + False + False + 0 + 0 + 4 + Row Fields: + True + listbox-row + + + + + + 0 + 2 + 1 + 1 + + + + + True + False + False + False + 0 + 0 + 4 + Data Fields: + True + listbox-data + + + + + + 1 + 2 + 1 + 1 + + + + + True + True + True + True + in + + + 200 + 150 + True + True + True + True + + + + + + + + 2 + 1 + 1 + 3 + + + + + True + False + False + False + Drag the items into the desired position + + + + + + 0 + 4 + 3 + 1 + + + + + True + True + + + True + False + True + True + 6 + 12 + + + True + False + True + True + 0 + none + + + True + False + 12 + + + True + False + True + True + 6 + 12 + + + New sheet + True + True + False + 0 + True + True + destination-radio-named-range + + + 0 + 0 + 3 + 1 + + + + + Selection + True + True + False + 0 + True + True + destination-radio-new-sheet + + + 0 + 2 + 1 + 1 + + + + + True + True + True + + + 1 + 2 + 1 + 1 + + + + + True + True + False + + + 2 + 2 + 1 + 1 + + + + + True + False + + + 1 + 1 + 2 + 1 + + + + + Named range + True + True + False + 0 + True + True + destination-radio-selection + + + 0 + 1 + 1 + 1 + + + + + + + + + True + False + Destination + + + + + + + + 0 + 1 + 1 + 1 + + + + + True + False + True + True + 0 + none + + + True + False + 12 + + + True + False + True + True + 6 + 12 + + + Selection + True + True + False + 0 + True + source-radio-named-range + + + 0 + 1 + 1 + 1 + + + + + True + True + True + + + 1 + 1 + 1 + 1 + + + + + True + True + False + + + 2 + 1 + 1 + 1 + + + + + Named range + True + True + False + 0 + True + source-radio-selection + + + 0 + 0 + 1 + 1 + + + + + True + False + + + 1 + 0 + 2 + 1 + + + + + + + + + True + False + Source + + + + + + + + 0 + 0 + 1 + 1 + + + + + + + True + False + Source and Destination + + + + + + + + 0 + 6 + 3 + 1 + + + + + True + False + True + True + 0 + none + + + True + False + 12 + + + True + False + 6 + 12 + + + Ignore empty rows + True + True + False + True + False + 0 + True + + + 0 + 0 + 1 + 1 + + + + + Identify categories + True + True + False + True + False + 0 + True + + + 1 + 0 + 1 + 1 + + + + + Total rows + True + True + False + True + False + 0 + True + + + 1 + 1 + 1 + 1 + + + + + Total columns + True + True + False + True + False + 0 + True + + + 0 + 1 + 1 + 1 + + + + + Add filter + True + True + False + True + False + 0 + True + + + 0 + 2 + 1 + 1 + + + + + Enable drill to details + True + True + False + True + False + 0 + True + + + 1 + 2 + 1 + 1 + + + + + + + + + True + False + Options + + + + + + + + 0 + 5 + 3 + 1 + + + + + False + True + 1 + + + + + + -- cgit v1.2.3