| /************************************************************** |
| * |
| * Licensed to the Apache Software Foundation (ASF) under one |
| * or more contributor license agreements. See the NOTICE file |
| * distributed with this work for additional information |
| * regarding copyright ownership. The ASF licenses this file |
| * to you under the Apache License, Version 2.0 (the |
| * "License"); you may not use this file except in compliance |
| * with the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the 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 ; |
| }; |
| }; |
| |