sc/uiconfig/scalc/ui/pivotfilterdialog.ui

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <!-- Generated with glade 3.36.0 -->
   3 <interface domain="sc">
   4   <requires lib="gtk+" version="3.20"/>
   5   <object class="GtkDialog" id="PivotFilterDialog">
   6     <property name="can_focus">False</property>
   7     <property name="border_width">6</property>
   8     <property name="title" translatable="yes" context="pivotfilterdialog|PivotFilterDialog">Filter</property>
   9     <property name="modal">True</property>
  10     <property name="default_width">0</property>
  11     <property name="default_height">0</property>
  12     <property name="type_hint">dialog</property>
  13     <child internal-child="vbox">
  14       <object class="GtkBox" id="dialog-vbox1">
  15         <property name="can_focus">False</property>
  16         <property name="hexpand">True</property>
  17         <property name="vexpand">True</property>
  18         <property name="orientation">vertical</property>
  19         <property name="spacing">12</property>
  20         <child internal-child="action_area">
  21           <object class="GtkButtonBox" id="dialog-action_area1">
  22             <property name="can_focus">False</property>
  23             <property name="layout_style">end</property>
  24             <child>
  25               <object class="GtkButton" id="ok">
  26                 <property name="label" translatable="yes" context="stock">_OK</property>
  27                 <property name="visible">True</property>
  28                 <property name="can_focus">True</property>
  29                 <property name="can_default">True</property>
  30                 <property name="has_default">True</property>
  31                 <property name="receives_default">True</property>
  32                 <property name="use-underline">True</property>
  33               </object>
  34               <packing>
  35                 <property name="expand">False</property>
  36                 <property name="fill">True</property>
  37                 <property name="position">0</property>
  38               </packing>
  39             </child>
  40             <child>
  41               <object class="GtkButton" id="cancel">
  42                 <property name="label" translatable="yes" context="stock">_Cancel</property>
  43                 <property name="visible">True</property>
  44                 <property name="can_focus">True</property>
  45                 <property name="can_default">True</property>
  46                 <property name="receives_default">True</property>
  47                 <property name="use-underline">True</property>
  48               </object>
  49               <packing>
  50                 <property name="expand">False</property>
  51                 <property name="fill">True</property>
  52                 <property name="position">1</property>
  53               </packing>
  54             </child>
  55             <child>
  56               <object class="GtkButton" id="help">
  57                 <property name="label" translatable="yes" context="stock">_Help</property>
  58                 <property name="visible">True</property>
  59                 <property name="can_focus">True</property>
  60                 <property name="can_default">True</property>
  61                 <property name="receives_default">True</property>
  62                 <property name="use-underline">True</property>
  63               </object>
  64               <packing>
  65                 <property name="expand">False</property>
  66                 <property name="fill">True</property>
  67                 <property name="position">2</property>
  68                 <property name="secondary">True</property>
  69               </packing>
  70             </child>
  71           </object>
  72           <packing>
  73             <property name="expand">False</property>
  74             <property name="fill">True</property>
  75             <property name="pack_type">end</property>
  76             <property name="position">0</property>
  77           </packing>
  78         </child>
  79         <child>
  80           <object class="GtkFrame" id="frame1">
  81             <property name="visible">True</property>
  82             <property name="can_focus">False</property>
  83             <property name="hexpand">True</property>
  84             <property name="label_xalign">0</property>
  85             <property name="shadow_type">none</property>
  86             <child>
  87               <!-- n-columns=1 n-rows=1 -->
  88               <object class="GtkGrid" id="grid1">
  89                 <property name="visible">True</property>
  90                 <property name="can_focus">False</property>
  91                 <property name="hexpand">True</property>
  92                 <property name="vexpand">True</property>
  93                 <property name="row_spacing">6</property>
  94                 <property name="column_spacing">12</property>
  95                 <property name="margin-start">12</property>
  96                 <property name="margin-top">6</property>
  97                 <child>
  98                   <object class="GtkComboBoxText" id="connect1">
  99                     <property name="visible">True</property>
 100                     <property name="can_focus">False</property>
 101                     <items>
 102                       <item translatable="yes" context="pivotfilterdialog|connect1">AND</item>
 103                       <item translatable="yes" context="pivotfilterdialog|connect1">OR</item>
 104                     </items>
 105                     <accessibility>
 106                       <relation type="labelled-by" target="label2"/>
 107                     </accessibility>
 108                     <child internal-child="accessible">
 109                       <object class="AtkObject" id="connect1-atkobject">
 110                         <property name="AtkObject::accessible-description" translatable="yes" context="pivotfilterdialog|extended_tip|connect1">Select a logical operator for the filter.</property>
 111                       </object>
 112                     </child>
 113                   </object>
 114                   <packing>
 115                     <property name="left_attach">0</property>
 116                     <property name="top_attach">2</property>
 117                   </packing>
 118                 </child>
 119                 <child>
 120                   <object class="GtkComboBoxText" id="connect2">
 121                     <property name="visible">True</property>
 122                     <property name="can_focus">False</property>
 123                     <items>
 124                       <item translatable="yes" context="pivotfilterdialog|connect2">AND</item>
 125                       <item translatable="yes" context="pivotfilterdialog|connect2">OR</item>
 126                     </items>
 127                     <child internal-child="accessible">
 128                       <object class="AtkObject" id="connect2-atkobject">
 129                         <property name="AtkObject::accessible-description" translatable="yes" context="pivotfilterdialog|extended_tip|connect2">Select a logical operator for the filter.</property>
 130                       </object>
 131                     </child>
 132                   </object>
 133                   <packing>
 134                     <property name="left_attach">0</property>
 135                     <property name="top_attach">3</property>
 136                   </packing>
 137                 </child>
 138                 <child>
 139                   <object class="GtkLabel" id="label2">
 140                     <property name="visible">True</property>
 141                     <property name="can_focus">False</property>
 142                     <property name="label" translatable="yes" context="pivotfilterdialog|label2">Operator</property>
 143                   </object>
 144                   <packing>
 145                     <property name="left_attach">0</property>
 146                     <property name="top_attach">0</property>
 147                   </packing>
 148                 </child>
 149                 <child>
 150                   <object class="GtkLabel" id="label3">
 151                     <property name="visible">True</property>
 152                     <property name="can_focus">False</property>
 153                     <property name="label" translatable="yes" context="pivotfilterdialog|label3">Field name</property>
 154                   </object>
 155                   <packing>
 156                     <property name="left_attach">1</property>
 157                     <property name="top_attach">0</property>
 158                   </packing>
 159                 </child>
 160                 <child>
 161                   <object class="GtkLabel" id="label4">
 162                     <property name="visible">True</property>
 163                     <property name="can_focus">False</property>
 164                     <property name="label" translatable="yes" context="pivotfilterdialog|label4">Condition</property>
 165                   </object>
 166                   <packing>
 167                     <property name="left_attach">2</property>
 168                     <property name="top_attach">0</property>
 169                   </packing>
 170                 </child>
 171                 <child>
 172                   <object class="GtkLabel" id="label5">
 173                     <property name="visible">True</property>
 174                     <property name="can_focus">False</property>
 175                     <property name="label" translatable="yes" context="pivotfilterdialog|label5">Value</property>
 176                   </object>
 177                   <packing>
 178                     <property name="left_attach">3</property>
 179                     <property name="top_attach">0</property>
 180                   </packing>
 181                 </child>
 182                 <child>
 183                   <object class="GtkComboBoxText" id="field1">
 184                     <property name="visible">True</property>
 185                     <property name="can_focus">False</property>
 186                     <accessibility>
 187                       <relation type="labelled-by" target="label3"/>
 188                     </accessibility>
 189                     <child internal-child="accessible">
 190                       <object class="AtkObject" id="field1-atkobject">
 191                         <property name="AtkObject::accessible-description" translatable="yes" context="pivotfilterdialog|extended_tip|field1">Select the field that you want to use in the filter. If field names are not available, the column labels are listed.</property>
 192                       </object>
 193                     </child>
 194                   </object>
 195                   <packing>
 196                     <property name="left_attach">1</property>
 197                     <property name="top_attach">1</property>
 198                   </packing>
 199                 </child>
 200                 <child>
 201                   <object class="GtkComboBoxText" id="field2">
 202                     <property name="visible">True</property>
 203                     <property name="can_focus">False</property>
 204                     <accessibility>
 205                       <relation type="labelled-by" target="label3"/>
 206                     </accessibility>
 207                     <child internal-child="accessible">
 208                       <object class="AtkObject" id="field2-atkobject">
 209                         <property name="AtkObject::accessible-description" translatable="yes" context="pivotfilterdialog|extended_tip|field2">Select the field that you want to use in the filter. If field names are not available, the column labels are listed.</property>
 210                       </object>
 211                     </child>
 212                   </object>
 213                   <packing>
 214                     <property name="left_attach">1</property>
 215                     <property name="top_attach">2</property>
 216                   </packing>
 217                 </child>
 218                 <child>
 219                   <object class="GtkComboBoxText" id="field3">
 220                     <property name="visible">True</property>
 221                     <property name="can_focus">False</property>
 222                     <accessibility>
 223                       <relation type="labelled-by" target="label3"/>
 224                     </accessibility>
 225                     <child internal-child="accessible">
 226                       <object class="AtkObject" id="field3-atkobject">
 227                         <property name="AtkObject::accessible-description" translatable="yes" context="pivotfilterdialog|extended_tip|field3">Select the field that you want to use in the filter. If field names are not available, the column labels are listed.</property>
 228                       </object>
 229                     </child>
 230                   </object>
 231                   <packing>
 232                     <property name="left_attach">1</property>
 233                     <property name="top_attach">3</property>
 234                   </packing>
 235                 </child>
 236                 <child>
 237                   <object class="GtkComboBoxText" id="cond1">
 238                     <property name="visible">True</property>
 239                     <property name="can_focus">False</property>
 240                     <items>
 241                       <item>=</item>
 242                       <item>&lt;</item>
 243                       <item>&gt;</item>
 244                       <item>&lt;=</item>
 245                       <item>&gt;=</item>
 246                       <item>&lt;&gt;</item>
 247                     </items>
 248                     <accessibility>
 249                       <relation type="labelled-by" target="label4"/>
 250                     </accessibility>
 251                     <child internal-child="accessible">
 252                       <object class="AtkObject" id="cond1-atkobject">
 253                         <property name="AtkObject::accessible-description" translatable="yes" context="pivotfilterdialog|extended_tip|cond1">Select an operator to compare the Field name and Value entries.</property>
 254                       </object>
 255                     </child>
 256                   </object>
 257                   <packing>
 258                     <property name="left_attach">2</property>
 259                     <property name="top_attach">1</property>
 260                   </packing>
 261                 </child>
 262                 <child>
 263                   <object class="GtkComboBoxText" id="cond2">
 264                     <property name="visible">True</property>
 265                     <property name="can_focus">False</property>
 266                     <items>
 267                       <item>=</item>
 268                       <item>&lt;</item>
 269                       <item>&gt;</item>
 270                       <item>&lt;=</item>
 271                       <item>&gt;=</item>
 272                       <item>&lt;&gt;</item>
 273                     </items>
 274                     <accessibility>
 275                       <relation type="labelled-by" target="label4"/>
 276                     </accessibility>
 277                     <child internal-child="accessible">
 278                       <object class="AtkObject" id="cond2-atkobject">
 279                         <property name="AtkObject::accessible-description" translatable="yes" context="pivotfilterdialog|extended_tip|cond2">Select an operator to compare the Field name and Value entries.</property>
 280                       </object>
 281                     </child>
 282                   </object>
 283                   <packing>
 284                     <property name="left_attach">2</property>
 285                     <property name="top_attach">2</property>
 286                   </packing>
 287                 </child>
 288                 <child>
 289                   <object class="GtkComboBoxText" id="cond3">
 290                     <property name="visible">True</property>
 291                     <property name="can_focus">False</property>
 292                     <items>
 293                       <item>=</item>
 294                       <item>&lt;</item>
 295                       <item>&gt;</item>
 296                       <item>&lt;=</item>
 297                       <item>&gt;=</item>
 298                       <item>&lt;&gt;</item>
 299                     </items>
 300                     <accessibility>
 301                       <relation type="labelled-by" target="label4"/>
 302                     </accessibility>
 303                     <child internal-child="accessible">
 304                       <object class="AtkObject" id="cond3-atkobject">
 305                         <property name="AtkObject::accessible-description" translatable="yes" context="pivotfilterdialog|extended_tip|cond3">Select an operator to compare the Field name and Value entries.</property>
 306                       </object>
 307                     </child>
 308                   </object>
 309                   <packing>
 310                     <property name="left_attach">2</property>
 311                     <property name="top_attach">3</property>
 312                   </packing>
 313                 </child>
 314                 <child>
 315                   <object class="GtkComboBoxText" id="val1">
 316                     <property name="visible">True</property>
 317                     <property name="can_focus">False</property>
 318                     <property name="hexpand">True</property>
 319                     <property name="has_entry">True</property>
 320                     <child internal-child="entry">
 321                       <object class="GtkEntry" id="comboboxtext-entry2">
 322                         <property name="can_focus">True</property>
 323                         <property name="truncate-multiline">True</property>
 324                         <property name="activates_default">True</property>
 325                       </object>
 326                     </child>
 327                     <accessibility>
 328                       <relation type="labelled-by" target="label5"/>
 329                     </accessibility>
 330                     <child internal-child="accessible">
 331                       <object class="AtkObject" id="val1-atkobject">
 332                         <property name="AtkObject::accessible-description" translatable="yes" context="pivotfilterdialog|extended_tip|val1">Select the value that you want to compare to the selected field.</property>
 333                       </object>
 334                     </child>
 335                   </object>
 336                   <packing>
 337                     <property name="left_attach">3</property>
 338                     <property name="top_attach">1</property>
 339                   </packing>
 340                 </child>
 341                 <child>
 342                   <object class="GtkComboBoxText" id="val2">
 343                     <property name="visible">True</property>
 344                     <property name="can_focus">False</property>
 345                     <property name="hexpand">True</property>
 346                     <property name="has_entry">True</property>
 347                     <child internal-child="entry">
 348                       <object class="GtkEntry" id="comboboxtext-entry4">
 349                         <property name="can_focus">True</property>
 350                         <property name="truncate-multiline">True</property>
 351                         <property name="activates_default">True</property>
 352                       </object>
 353                     </child>
 354                     <accessibility>
 355                       <relation type="labelled-by" target="label5"/>
 356                     </accessibility>
 357                     <child internal-child="accessible">
 358                       <object class="AtkObject" id="val2-atkobject">
 359                         <property name="AtkObject::accessible-description" translatable="yes" context="pivotfilterdialog|extended_tip|val2">Select the value that you want to compare to the selected field.</property>
 360                       </object>
 361                     </child>
 362                   </object>
 363                   <packing>
 364                     <property name="left_attach">3</property>
 365                     <property name="top_attach">2</property>
 366                   </packing>
 367                 </child>
 368                 <child>
 369                   <object class="GtkComboBoxText" id="val3">
 370                     <property name="visible">True</property>
 371                     <property name="can_focus">False</property>
 372                     <property name="hexpand">True</property>
 373                     <property name="has_entry">True</property>
 374                     <child internal-child="entry">
 375                       <object class="GtkEntry" id="comboboxtext-entry6">
 376                         <property name="can_focus">True</property>
 377                         <property name="truncate-multiline">True</property>
 378                         <property name="activates_default">True</property>
 379                       </object>
 380                     </child>
 381                     <accessibility>
 382                       <relation type="labelled-by" target="label5"/>
 383                     </accessibility>
 384                     <child internal-child="accessible">
 385                       <object class="AtkObject" id="val3-atkobject">
 386                         <property name="AtkObject::accessible-description" translatable="yes" context="pivotfilterdialog|extended_tip|val3">Select the value that you want to compare to the selected field.</property>
 387                       </object>
 388                     </child>
 389                   </object>
 390                   <packing>
 391                     <property name="left_attach">3</property>
 392                     <property name="top_attach">3</property>
 393                   </packing>
 394                 </child>
 395                 <child>
 396                   <placeholder/>
 397                 </child>
 398               </object>
 399             </child>
 400             <child type="label">
 401               <object class="GtkLabel" id="label1">
 402                 <property name="visible">True</property>
 403                 <property name="can_focus">False</property>
 404                 <property name="label" translatable="yes" context="pivotfilterdialog|label1">Filter Criteria</property>
 405                 <attributes>
 406                   <attribute name="weight" value="bold"/>
 407                 </attributes>
 408               </object>
 409             </child>
 410           </object>
 411           <packing>
 412             <property name="expand">False</property>
 413             <property name="fill">True</property>
 414             <property name="position">1</property>
 415           </packing>
 416         </child>
 417         <child>
 418           <object class="GtkExpander" id="more">
 419             <property name="visible">True</property>
 420             <property name="can_focus">True</property>
 421             <property name="hexpand">True</property>
 422             <property name="resize_toplevel">True</property>
 423             <child>
 424               <!-- n-columns=1 n-rows=1 -->
 425               <object class="GtkGrid" id="grid2">
 426                 <property name="visible">True</property>
 427                 <property name="can_focus">False</property>
 428                 <property name="margin_top">6</property>
 429                 <property name="hexpand">True</property>
 430                 <property name="vexpand">True</property>
 431                 <property name="row_spacing">6</property>
 432                 <child>
 433                   <!-- n-columns=1 n-rows=1 -->
 434                   <object class="GtkGrid" id="grid3">
 435                     <property name="visible">True</property>
 436                     <property name="can_focus">False</property>
 437                     <property name="hexpand">True</property>
 438                     <property name="vexpand">True</property>
 439                     <property name="row_spacing">6</property>
 440                     <property name="column_spacing">12</property>
 441                     <child>
 442                       <object class="GtkCheckButton" id="case">
 443                         <property name="label" translatable="yes" context="pivotfilterdialog|case">_Case sensitive</property>
 444                         <property name="visible">True</property>
 445                         <property name="can_focus">True</property>
 446                         <property name="receives_default">False</property>
 447                         <property name="hexpand">True</property>
 448                         <property name="use_underline">True</property>
 449                         <property name="draw_indicator">True</property>
 450                         <child internal-child="accessible">
 451                           <object class="AtkObject" id="case-atkobject">
 452                             <property name="AtkObject::accessible-description" translatable="yes" context="pivotfilterdialog|extended_tip|case">Distinguishes between uppercase and lowercase letters.</property>
 453                           </object>
 454                         </child>
 455                       </object>
 456                       <packing>
 457                         <property name="left_attach">0</property>
 458                         <property name="top_attach">0</property>
 459                       </packing>
 460                     </child>
 461                     <child>
 462                       <object class="GtkCheckButton" id="regexp">
 463                         <property name="label" translatable="yes" context="pivotfilterdialog|regexp">Regular _expressions</property>
 464                         <property name="visible">True</property>
 465                         <property name="can_focus">True</property>
 466                         <property name="receives_default">False</property>
 467                         <property name="hexpand">True</property>
 468                         <property name="use_underline">True</property>
 469                         <property name="draw_indicator">True</property>
 470                         <child internal-child="accessible">
 471                           <object class="AtkObject" id="regexp-atkobject">
 472                             <property name="AtkObject::accessible-description" translatable="yes" context="pivotfilterdialog|extended_tip|regexp">Allows you to use regular expressions in the filter definition.</property>
 473                           </object>
 474                         </child>
 475                       </object>
 476                       <packing>
 477                         <property name="left_attach">1</property>
 478                         <property name="top_attach">0</property>
 479                       </packing>
 480                     </child>
 481                     <child>
 482                       <object class="GtkCheckButton" id="unique">
 483                         <property name="label" translatable="yes" context="pivotfilterdialog|unique">_No duplications</property>
 484                         <property name="visible">True</property>
 485                         <property name="can_focus">True</property>
 486                         <property name="receives_default">False</property>
 487                         <property name="hexpand">True</property>
 488                         <property name="use_underline">True</property>
 489                         <property name="draw_indicator">True</property>
 490                         <child internal-child="accessible">
 491                           <object class="AtkObject" id="unique-atkobject">
 492                             <property name="AtkObject::accessible-description" translatable="yes" context="pivotfilterdialog|extended_tip|unique">Excludes duplicate rows in the list of filtered data.</property>
 493                           </object>
 494                         </child>
 495                       </object>
 496                       <packing>
 497                         <property name="left_attach">0</property>
 498                         <property name="top_attach">1</property>
 499                       </packing>
 500                     </child>
 501                     <child>
 502                       <placeholder/>
 503                     </child>
 504                   </object>
 505                   <packing>
 506                     <property name="left_attach">0</property>
 507                     <property name="top_attach">0</property>
 508                   </packing>
 509                 </child>
 510                 <child>
 511                   <!-- n-columns=1 n-rows=1 -->
 512                   <object class="GtkGrid" id="grid5">
 513                     <property name="sensitive">False</property>
 514                     <property name="can_focus">False</property>
 515                     <property name="column_spacing">12</property>
 516                     <child>
 517                       <object class="GtkLabel" id="dbarealabel">
 518                         <property name="sensitive">False</property>
 519                         <property name="can_focus">False</property>
 520                         <property name="label" translatable="yes" context="pivotfilterdialog|dbarealabel">Data range:</property>
 521                         <property name="xalign">0</property>
 522                       </object>
 523                       <packing>
 524                         <property name="left_attach">0</property>
 525                         <property name="top_attach">0</property>
 526                       </packing>
 527                     </child>
 528                     <child>
 529                       <object class="GtkLabel" id="dbarea">
 530                         <property name="sensitive">False</property>
 531                         <property name="can_focus">False</property>
 532                         <property name="hexpand">True</property>
 533                         <property name="label" translatable="yes" context="pivotfilterdialog|dbarea">dummy</property>
 534                         <property name="xalign">0</property>
 535                         <child internal-child="accessible">
 536                           <object class="AtkObject" id="dbarea-atkobject">
 537                             <property name="AtkObject::accessible-description" translatable="yes" context="pivotfilterdialog|extended_tip|dbarea">Displays the name of the filtered data range in the table.</property>
 538                           </object>
 539                         </child>
 540                       </object>
 541                       <packing>
 542                         <property name="left_attach">1</property>
 543                         <property name="top_attach">0</property>
 544                       </packing>
 545                     </child>
 546                   </object>
 547                   <packing>
 548                     <property name="left_attach">0</property>
 549                     <property name="top_attach">1</property>
 550                   </packing>
 551                 </child>
 552               </object>
 553             </child>
 554             <child type="label">
 555               <object class="GtkLabel" id="label6">
 556                 <property name="visible">True</property>
 557                 <property name="can_focus">False</property>
 558                 <property name="label" translatable="yes" context="pivotfilterdialog|label6">Op_tions</property>
 559                 <property name="use_underline">True</property>
 560               </object>
 561             </child>
 562           </object>
 563           <packing>
 564             <property name="expand">False</property>
 565             <property name="fill">True</property>
 566             <property name="position">2</property>
 567           </packing>
 568         </child>
 569       </object>
 570     </child>
 571     <action-widgets>
 572       <action-widget response="-5">ok</action-widget>
 573       <action-widget response="-6">cancel</action-widget>
 574       <action-widget response="-11">help</action-widget>
 575     </action-widgets>
 576     <child type="titlebar">
 577       <placeholder/>
 578     </child>
 579   </object>
 580 </interface>