/*************************************************************************
 *
 * 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 ;
	};
};

