/*************************************************************************
 *
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
 *
 * Copyright 2000, 2010 Oracle and/or its affiliates.
 *
 * OpenOffice.org - a multi-platform office productivity suite
 *
 * This file is part of OpenOffice.org.
 *
 * OpenOffice.org is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Lesser General Public License version 3
 * only, as published by the Free Software Foundation.
 *
 * OpenOffice.org is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Lesser General Public License version 3 for more details
 * (a copy is included in the LICENSE file that accompanied this code).
 *
 * You should have received a copy of the GNU Lesser General Public License
 * version 3 along with OpenOffice.org.  If not, see
 * <http://www.openoffice.org/license.html>
 * for a copy of the LGPLv3 License.
 *
 ************************************************************************/
#include "consdlg.hrc"
ModelessDialog RID_SCDLG_CONSOLIDATE
{
    OutputSize = TRUE ;
    HelpId = CMD_SID_OPENDLG_CONSOLIDATE ;
    Hide = TRUE ;
    SVLook = TRUE ;
    Size = MAP_APPFONT ( 280 , 154 ) ;
    Text [ en-US ] = "Consolidate" ;
    Moveable = TRUE ;
    Closeable = FALSE ;
    ListBox LB_FUNC
    {
        HelpID = "sc:ListBox:RID_SCDLG_CONSOLIDATE:LB_FUNC";
        Border = TRUE ;
        Pos = MAP_APPFONT ( 6 , 17 ) ;
        Size = MAP_APPFONT ( 212 , 90 ) ;
        TabStop = TRUE ;
        DropDown = TRUE ;
        StringList [ en-US ] =
        {
            < "Sum" ; Default ; > ;
            < "Count" ; Default ; > ;
            < "Average" ; Default ; > ;
            < "Max" ; Default ; > ;
            < "Min" ; Default ; > ;
            < "Product" ; Default ; > ;
            < "Count (numbers only)" ; Default ; > ;
            < "StDev (sample)" ; Default ; > ;
            < "StDevP (population)" ; Default ; > ;
            < "Var (sample)" ; Default ; > ;
            < "VarP (population)" ; Default ; > ;
        };
    };
    Edit ED_DATA_AREA
    {
        HelpID = "sc:Edit:RID_SCDLG_CONSOLIDATE:ED_DATA_AREA";
        Border = TRUE ;
        Pos = MAP_APPFONT ( 100 , 106 ) ;
        Size = MAP_APPFONT ( 104 , 12 ) ;
        TabStop = TRUE ;
    };
    Edit ED_DEST_AREA
    {
        HelpID = "sc:Edit:RID_SCDLG_CONSOLIDATE:ED_DEST_AREA";
        Border = TRUE ;
        Pos = MAP_APPFONT ( 100 , 135 ) ;
        Size = MAP_APPFONT ( 104 , 12 ) ;
        TabStop = TRUE ;
    };
    ImageButton RB_DATA_AREA
    {
        HelpID = "sc:ImageButton:RID_SCDLG_CONSOLIDATE:RB_DATA_AREA";
        Pos = MAP_APPFONT ( 206 , 105 ) ;
        Size = MAP_APPFONT ( 13 , 15 ) ;
        TabStop = TRUE ;
        QuickHelpText [ en-US ] = "Shrink" ;
    };
    ImageButton RB_DEST_AREA
    {
        HelpID = "sc:ImageButton:RID_SCDLG_CONSOLIDATE:RB_DEST_AREA";
        Pos = MAP_APPFONT ( 206 , 134 ) ;
        Size = MAP_APPFONT ( 13 , 15 ) ;
        TabStop = TRUE ;
        QuickHelpText [ en-US ] = "Shrink" ;
    };
    ListBox LB_DATA_AREA
    {
        HelpID = "sc:ListBox:RID_SCDLG_CONSOLIDATE:LB_DATA_AREA";
        Border = TRUE ;
        Pos = MAP_APPFONT ( 6 , 106 ) ;
        Size = MAP_APPFONT ( 90 , 90 ) ;
        TabStop = TRUE ;
        DropDown = TRUE ;
    };
    ListBox LB_DEST_AREA
    {
        HelpID = "sc:ListBox:RID_SCDLG_CONSOLIDATE:LB_DEST_AREA";
        Border = TRUE ;
        Pos = MAP_APPFONT ( 6 , 135 ) ;
        Size = MAP_APPFONT ( 90 , 90 ) ;
        TabStop = TRUE ;
        DropDown = TRUE ;
    };
    MultiListBox LB_CONSAREAS
    {
        HelpID = "sc:MultiListBox:RID_SCDLG_CONSOLIDATE:LB_CONSAREAS";
        SimpleMode = TRUE ;
        Border = TRUE ;
        Pos = MAP_APPFONT ( 6 , 46 ) ;
        Size = MAP_APPFONT ( 212 , 43 ) ;
        TabStop = TRUE ;
    };
    FixedText FT_FUNC
    {
        Pos = MAP_APPFONT ( 6 , 6 ) ;
        Size = MAP_APPFONT ( 212 , 8 ) ;
        Text [ en-US ] = "~Function" ;
    };
    FixedText FT_CONSAREAS
    {
        Pos = MAP_APPFONT ( 6 , 35 ) ;
        Size = MAP_APPFONT ( 212 , 8 ) ;
        Text [ en-US ] = "~Consolidation ranges" ;
    };
    FixedText FT_DATA_AREA
    {
        Pos = MAP_APPFONT ( 6 , 95 ) ;
        Size = MAP_APPFONT ( 212 , 8 ) ;
        Text [ en-US ] = "~Source data range" ;
    };
    FixedText FT_DEST_AREA
    {
        Pos = MAP_APPFONT ( 6 , 124 ) ;
        Size = MAP_APPFONT ( 212 , 8 ) ;
        Text [ en-US ] = "Copy results ~to" ;
    };
    CheckBox BTN_BYROW
    {
        HelpID = "sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_BYROW";
        Pos = MAP_APPFONT ( 12 , 165 ) ;
        Size = MAP_APPFONT ( 94 , 10 ) ;
        Text [ en-US ] = "~Row labels" ;
        TabStop = TRUE ;
    };
    CheckBox BTN_BYCOL
    {
        HelpID = "sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_BYCOL";
        Pos = MAP_APPFONT ( 12 , 179 ) ;
        Size = MAP_APPFONT ( 94 , 10 ) ;
        TabStop = TRUE ;
        Text [ en-US ] = "C~olumn labels" ;
    };
    FixedLine FL_CONSBY
    {
        Pos = MAP_APPFONT ( 6 , 154 ) ;
        Size = MAP_APPFONT ( 103 , 8 ) ;
        Text [ en-US ] = "Consolidate by" ;
    };
    FixedLine FL_SEP
    {
        Pos = MAP_APPFONT ( 112 , 165 ) ;
        Size = MAP_APPFONT ( 1 , 24 ) ;
    };
    FixedLine FL_OPTIONS
    {
        Hide = TRUE ;
        Pos = MAP_APPFONT ( 115 , 154 ) ;
        Size = MAP_APPFONT ( 103 , 8 ) ;
        Text [ en-US ] = "Options" ;
    };
    CheckBox BTN_REFS
    {
        HelpID = "sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_REFS";
        Pos = MAP_APPFONT ( 121 , 165 ) ;
        Size = MAP_APPFONT ( 94 , 10 ) ;
        Text [ en-US ] = "~Link to source data" ;
        TabStop = TRUE ;
    };
    OKButton BTN_OK
    {
        Pos = MAP_APPFONT ( 224 , 6 ) ;
        Size = MAP_APPFONT ( 50 , 14 ) ;
        TabStop = TRUE ;
        DefButton = TRUE ;
    };
    CancelButton BTN_CANCEL
    {
        Pos = MAP_APPFONT ( 224 , 23 ) ;
        Size = MAP_APPFONT ( 50 , 14 ) ;
        TabStop = TRUE ;
    };
    HelpButton BTN_HELP
    {
        Pos = MAP_APPFONT ( 224 , 43 ) ;
        Size = MAP_APPFONT ( 50 , 14 ) ;
        TabStop = TRUE ;
    };
    MoreButton BTN_MORE
    {
        HelpID = "sc:MoreButton:RID_SCDLG_CONSOLIDATE:BTN_MORE";
        Pos = MAP_APPFONT ( 224 , 134 ) ;
        Size = MAP_APPFONT ( 50 , 14 ) ;
        TabStop = TRUE ;
        MapUnit = MAP_APPFONT ;
        Delta = 41 ;
    };
    PushButton BTN_REMOVE
    {
        HelpID = "sc:PushButton:RID_SCDLG_CONSOLIDATE:BTN_REMOVE";
        Pos = MAP_APPFONT ( 224 , 114 ) ;
        Size = MAP_APPFONT ( 50 , 14 ) ;
        Text [ en-US ] = "~Delete" ;
        TabStop = TRUE ;
    };
    PushButton BTN_ADD
    {
        HelpID = "sc:PushButton:RID_SCDLG_CONSOLIDATE:BTN_ADD";
        Pos = MAP_APPFONT ( 224 , 96 ) ;
        Size = MAP_APPFONT ( 50 , 14 ) ;
        Text [ en-US ] = "~Add" ;
        TabStop = TRUE ;
    };
};