diff options
Diffstat (limited to 'sc/uiconfig/scalc/ui/advancedfilterdialog.ui')
| -rw-r--r-- | sc/uiconfig/scalc/ui/advancedfilterdialog.ui | 488 |
1 files changed, 488 insertions, 0 deletions
diff --git a/sc/uiconfig/scalc/ui/advancedfilterdialog.ui b/sc/uiconfig/scalc/ui/advancedfilterdialog.ui new file mode 100644 index 000000000..ce5b9ecaa --- /dev/null +++ b/sc/uiconfig/scalc/ui/advancedfilterdialog.ui @@ -0,0 +1,488 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- Generated with glade 3.36.0 --> +<interface domain="sc"> + <requires lib="gtk+" version="3.20"/> + <object class="GtkDialog" id="AdvancedFilterDialog"> + <property name="can_focus">False</property> + <property name="border_width">6</property> + <property name="title" translatable="yes" context="advancedfilterdialog|AdvancedFilterDialog">Advanced Filter</property> + <property name="resizable">False</property> + <property name="default_width">0</property> + <property name="default_height">0</property> + <property name="type_hint">dialog</property> + <child internal-child="vbox"> + <object class="GtkBox" id="dialog-vbox1"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="hexpand">True</property> + <property name="vexpand">True</property> + <property name="orientation">vertical</property> + <property name="spacing">12</property> + <child internal-child="action_area"> + <object class="GtkButtonBox" id="dialog-action_area1"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="hexpand">True</property> + <property name="layout_style">end</property> + <child> + <object class="GtkButton" id="ok"> + <property name="label" translatable="yes" context="stock">_OK</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="can_default">True</property> + <property name="has_default">True</property> + <property name="receives_default">True</property> + <property name="use-underline">True</property> + <child internal-child="accessible"> + <object class="AtkObject" id="ok-atkobject"> + <property name="AtkObject::accessible-description" translatable="yes" context="advancedfilterdialog|extended_tip|ok">Saves all changes and closes dialog.</property> + </object> + </child> + </object> + <packing> + <property name="expand">False</property> + <property name="fill">True</property> + <property name="position">0</property> + </packing> + </child> + <child> + <object class="GtkButton" id="cancel"> + <property name="label" translatable="yes" context="stock">_Cancel</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="can_default">True</property> + <property name="receives_default">True</property> + <property name="use-underline">True</property> + <child internal-child="accessible"> + <object class="AtkObject" id="cancel-atkobject"> + <property name="AtkObject::accessible-description" translatable="yes" context="advancedfilterdialog|extended_tip|cancel">Closes dialog and discards all changes.</property> + </object> + </child> + </object> + <packing> + <property name="expand">False</property> + <property name="fill">True</property> + <property name="position">1</property> + </packing> + </child> + <child> + <object class="GtkButton" id="help"> + <property name="label" translatable="yes" context="stock">_Help</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="can_default">True</property> + <property name="receives_default">True</property> + <property name="use-underline">True</property> + </object> + <packing> + <property name="expand">False</property> + <property name="fill">True</property> + <property name="position">2</property> + <property name="secondary">True</property> + </packing> + </child> + </object> + <packing> + <property name="expand">False</property> + <property name="fill">True</property> + <property name="pack_type">end</property> + <property name="position">1</property> + </packing> + </child> + <child> + <object class="GtkFrame" id="filterframe"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="hexpand">True</property> + <property name="label_xalign">0</property> + <property name="shadow_type">none</property> + <child> + <!-- n-columns=1 n-rows=1 --> + <object class="GtkGrid" id="grid1"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="hexpand">True</property> + <property name="vexpand">True</property> + <property name="column_spacing">12</property> + <property name="margin-start">12</property> + <property name="margin-top">6</property> + <child> + <object class="GtkButton" id="rbfilterarea"> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">True</property> + <child> + <placeholder/> + </child> + <child internal-child="accessible"> + <object class="AtkObject" id="rbfilterarea-atkobject"> + <property name="AtkObject::accessible-description" translatable="yes" context="advancedfilterdialog|extended_tip|rbfilterarea">Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.</property> + </object> + </child> + </object> + <packing> + <property name="left_attach">2</property> + <property name="top_attach">0</property> + </packing> + </child> + <child> + <object class="GtkComboBoxText" id="lbfilterarea"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <child internal-child="accessible"> + <object class="AtkObject" id="lbfilterarea-atkobject"> + <property name="AtkObject::accessible-description" translatable="yes" context="advancedfilterdialog|extended_tip|lbfilterarea">Select the named range, or enter the cell range that contains the filter criteria that you want to use.</property> + </object> + </child> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">0</property> + </packing> + </child> + <child> + <object class="GtkEntry" id="edfilterarea"> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="hexpand">True</property> + <property name="activates_default">True</property> + <property name="width_chars">30</property> + <property name="truncate-multiline">True</property> + <child internal-child="accessible"> + <object class="AtkObject" id="edfilterarea-atkobject"> + <property name="AtkObject::accessible-description" translatable="yes" context="advancedfilterdialog|extended_tip|edfilterarea">Select the named range, or enter the cell range that contains the filter criteria that you want to use.</property> + </object> + </child> + </object> + <packing> + <property name="left_attach">1</property> + <property name="top_attach">0</property> + </packing> + </child> + </object> + </child> + <child type="label"> + <object class="GtkLabel" id="label1"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="label" translatable="yes" context="advancedfilterdialog|label1">Read _Filter Criteria From</property> + <property name="use_underline">True</property> + <property name="mnemonic_widget">lbfilterarea</property> + <attributes> + <attribute name="weight" value="bold"/> + </attributes> + </object> + </child> + </object> + <packing> + <property name="expand">False</property> + <property name="fill">True</property> + <property name="position">0</property> + </packing> + </child> + <child> + <object class="GtkExpander" id="more"> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="hexpand">True</property> + <property name="resize_toplevel">True</property> + <child> + <!-- n-columns=1 n-rows=1 --> + <object class="GtkGrid" id="grid2"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="margin-start">12</property> + <property name="margin_top">6</property> + <property name="hexpand">True</property> + <property name="vexpand">True</property> + <property name="row_spacing">6</property> + <child> + <!-- n-columns=1 n-rows=1 --> + <object class="GtkGrid" id="grid3"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="hexpand">True</property> + <property name="vexpand">True</property> + <property name="row_spacing">6</property> + <property name="column_spacing">12</property> + <child> + <object class="GtkCheckButton" id="case"> + <property name="label" translatable="yes" context="advancedfilterdialog|case">_Case sensitive</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="hexpand">True</property> + <property name="use_underline">True</property> + <property name="draw_indicator">True</property> + <child internal-child="accessible"> + <object class="AtkObject" id="case-atkobject"> + <property name="AtkObject::accessible-description" translatable="yes" context="advancedfilterdialog|extended_tip|case">Distinguishes between uppercase and lowercase letters when filtering the data.</property> + </object> + </child> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">0</property> + </packing> + </child> + <child> + <object class="GtkCheckButton" id="header"> + <property name="label" translatable="yes" context="advancedfilterdialog|header">Range c_ontains column labels</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="hexpand">True</property> + <property name="use_underline">True</property> + <property name="draw_indicator">True</property> + <child internal-child="accessible"> + <object class="AtkObject" id="header-atkobject"> + <property name="AtkObject::accessible-description" translatable="yes" context="advancedfilterdialog|extended_tip|header">Includes the column labels in the first row of a cell range.</property> + </object> + </child> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">1</property> + </packing> + </child> + <child> + <object class="GtkCheckButton" id="regexp"> + <property name="label" translatable="yes" context="advancedfilterdialog|regexp">Regular _expressions</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="hexpand">True</property> + <property name="use_underline">True</property> + <property name="draw_indicator">True</property> + <child internal-child="accessible"> + <object class="AtkObject" id="regexp-atkobject"> + <property name="AtkObject::accessible-description" translatable="yes" context="advancedfilterdialog|extended_tip|regexp">Allows you to use regular expressions in the filter definition.</property> + </object> + </child> + </object> + <packing> + <property name="left_attach">1</property> + <property name="top_attach">0</property> + </packing> + </child> + <child> + <object class="GtkCheckButton" id="unique"> + <property name="label" translatable="yes" context="advancedfilterdialog|unique">_No duplications</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="hexpand">True</property> + <property name="use_underline">True</property> + <property name="draw_indicator">True</property> + <child internal-child="accessible"> + <object class="AtkObject" id="unique-atkobject"> + <property name="AtkObject::accessible-description" translatable="yes" context="advancedfilterdialog|extended_tip|unique">Excludes duplicate rows in the list of filtered data.</property> + </object> + </child> + </object> + <packing> + <property name="left_attach">1</property> + <property name="top_attach">1</property> + </packing> + </child> + <child> + <object class="GtkCheckButton" id="copyresult"> + <property name="label" translatable="yes" context="advancedfilterdialog|copyresult">Co_py results to:</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="hexpand">True</property> + <property name="use_underline">True</property> + <property name="draw_indicator">True</property> + <accessibility> + <relation type="label-for" target="lbcopyarea"/> + <relation type="label-for" target="edcopyarea"/> + </accessibility> + <child internal-child="accessible"> + <object class="AtkObject" id="copyresult-atkobject"> + <property name="AtkObject::accessible-description" translatable="yes" context="advancedfilterdialog|extended_tip|copyresult">Select the check box, and then select the cell range where you want to display the filter results.</property> + </object> + </child> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">2</property> + </packing> + </child> + <child> + <object class="GtkCheckButton" id="destpers"> + <property name="label" translatable="yes" context="advancedfilterdialog|destpers">_Keep filter criteria</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="hexpand">True</property> + <property name="use_underline">True</property> + <property name="draw_indicator">True</property> + <child internal-child="accessible"> + <object class="AtkObject" id="destpers-atkobject"> + <property name="AtkObject::accessible-description" translatable="yes" context="advancedfilterdialog|extended_tip|destpers">Select the Copy results to check box, and then specify the destination range where you want to display the filtered data. If this box is checked, the destination range remains linked to the source range. You must have defined the source range under Data - Define range as a database range.</property> + </object> + </child> + </object> + <packing> + <property name="left_attach">1</property> + <property name="top_attach">2</property> + </packing> + </child> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">0</property> + </packing> + </child> + <child> + <!-- n-columns=1 n-rows=1 --> + <object class="GtkGrid" id="grid4"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="margin-start">12</property> + <property name="hexpand">True</property> + <property name="column_spacing">12</property> + <child> + <object class="GtkComboBoxText" id="lbcopyarea"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <accessibility> + <relation type="labelled-by" target="copyresult"/> + </accessibility> + <child internal-child="accessible"> + <object class="AtkObject" id="lbcopyarea-atkobject"> + <property name="AtkObject::accessible-name" translatable="yes" context="advancedfilterdialog|lbcopyarea-atkobject">Copy results to:</property> + <property name="AtkObject::accessible-description" translatable="yes" context="advancedfilterdialog|extended_tip|lbcopyarea">Select the check box, and then select the cell range where you want to display the filter results.</property> + </object> + </child> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">0</property> + </packing> + </child> + <child> + <object class="GtkEntry" id="edcopyarea"> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="margin_bottom">1</property> + <property name="hexpand">True</property> + <property name="width_chars">30</property> + <accessibility> + <relation type="labelled-by" target="copyresult"/> + </accessibility> + <property name="truncate-multiline">True</property> + <child internal-child="accessible"> + <object class="AtkObject" id="edcopyarea-atkobject"> + <property name="AtkObject::accessible-name" translatable="yes" context="advancedfilterdialog|edcopyarea-atkobject">Copy results to:</property> + <property name="AtkObject::accessible-description" translatable="yes" context="advancedfilterdialog|extended_tip|edcopyarea">Select the check box, and then select the cell range where you want to display the filter results.</property> + </object> + </child> + </object> + <packing> + <property name="left_attach">1</property> + <property name="top_attach">0</property> + </packing> + </child> + <child> + <object class="GtkButton" id="rbcopyarea"> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">True</property> + <child> + <placeholder/> + </child> + <child internal-child="accessible"> + <object class="AtkObject" id="rbcopyarea-atkobject"> + <property name="AtkObject::accessible-description" translatable="yes" context="advancedfilterdialog|extended_tip|rbcopyarea">Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.</property> + </object> + </child> + </object> + <packing> + <property name="left_attach">2</property> + <property name="top_attach">0</property> + </packing> + </child> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">1</property> + </packing> + </child> + <child> + <!-- n-columns=1 n-rows=1 --> + <object class="GtkGrid" id="grid5"> + <property name="sensitive">False</property> + <property name="can_focus">False</property> + <property name="column_spacing">12</property> + <child> + <object class="GtkLabel" id="dbarealabel"> + <property name="sensitive">False</property> + <property name="can_focus">False</property> + <property name="label" translatable="yes" context="advancedfilterdialog|dbarealabel">Data range:</property> + <property name="xalign">0</property> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">0</property> + </packing> + </child> + <child> + <object class="GtkLabel" id="dbarea"> + <property name="sensitive">False</property> + <property name="can_focus">False</property> + <property name="hexpand">True</property> + <property name="label" translatable="yes" context="advancedfilterdialog|dbarea">dummy</property> + <property name="xalign">0</property> + </object> + <packing> + <property name="left_attach">1</property> + <property name="top_attach">0</property> + </packing> + </child> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">2</property> + </packing> + </child> + </object> + </child> + <child type="label"> + <object class="GtkLabel" id="label2"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="label" translatable="yes" context="advancedfilterdialog|label2">Op_tions</property> + <property name="use_underline">True</property> + </object> + </child> + <child internal-child="accessible"> + <object class="AtkObject" id="more-atkobject"> + <property name="AtkObject::accessible-description" translatable="yes" context="advancedfilterdialog|extended_tip|more">Shows additional filter options.</property> + </object> + </child> + </object> + <packing> + <property name="expand">False</property> + <property name="fill">True</property> + <property name="position">2</property> + </packing> + </child> + </object> + </child> + <action-widgets> + <action-widget response="-5">ok</action-widget> + <action-widget response="-6">cancel</action-widget> + <action-widget response="-11">help</action-widget> + </action-widgets> + <child type="titlebar"> + <placeholder/> + </child> + <child internal-child="accessible"> + <object class="AtkObject" id="AdvancedFilterDialog-atkobject"> + <property name="AtkObject::accessible-description" translatable="yes" context="advancedfilterdialog|extended_tip|AdvancedFilterDialog">Defines an advanced filter.</property> + </object> + </child> + </object> +</interface> |