xref: /aoo41x/main/sc/source/ui/dbgui/validate.src (revision c9093c9b)
1/**************************************************************
2 *
3 * Licensed to the Apache Software Foundation (ASF) under one
4 * or more contributor license agreements.  See the NOTICE file
5 * distributed with this work for additional information
6 * regarding copyright ownership.  The ASF licenses this file
7 * to you under the Apache License, Version 2.0 (the
8 * "License"); you may not use this file except in compliance
9 * with the License.  You may obtain a copy of the License at
10 *
11 *   http://www.apache.org/licenses/LICENSE-2.0
12 *
13 * Unless required by applicable law or agreed to in writing,
14 * software distributed under the License is distributed on an
15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16 * KIND, either express or implied.  See the License for the
17 * specific language governing permissions and limitations
18 * under the License.
19 *
20 *************************************************************/
21
22
23
24#include "validate.hrc"
25
26
27TabDialog TAB_DLG_VALIDATION
28{
29	OutputSize = TRUE ;
30	SVLook = TRUE ;
31	Size = MAP_APPFONT ( 289, 176 ) ;
32	Moveable = TRUE ;
33	TabControl 1
34	{
35		OutputSize = TRUE ;
36		Size = MAP_APPFONT ( 260, 135 ) ;
37		PageList =
38		{
39			PageItem
40			{
41				Identifier = TP_VALIDATION_VALUES ;
42				PageResID = TP_VALIDATION_VALUES ;
43				Text [ en-US ] = "Criteria" ;
44			};
45			PageItem
46			{
47				Identifier = TP_VALIDATION_INPUTHELP ;
48				PageResID = TP_VALIDATION_INPUTHELP ;
49				Text [ en-US ] = "Input Help" ;
50			};
51			PageItem
52			{
53				Identifier = TP_VALIDATION_ERROR ;
54				PageResID = TP_VALIDATION_ERROR ;
55				Text [ en-US ] = "Error Alert" ;
56			};
57		};
58	};
59	Text [ en-US ] = "Validity" ;
60};
61//<!--Added by PengYunQuan for Validity Cell Range Picker
62#define	OFFSET_X	30
63//-->Added by PengYunQuan for Validity Cell Range Picker
64TabPage TP_VALIDATION_VALUES
65{
66	HelpID = "sc:TabPage:TP_VALIDATION_VALUES" ;
67	Hide = TRUE ;
68	SVLook = TRUE ;
69	Size = MAP_APPFONT ( 260, 185 ) ;
70	Text [ en-US ] = "Values" ;
71	FixedText FT_ALLOW
72	{
73		Pos = MAP_APPFONT ( 6, 16 ) ;
74		//<!--Modified by PengYunQuan for Validity Cell Range Picker
75		//Size = MAP_APPFONT ( 70, 8 ) ;
76		Size = MAP_APPFONT ( 70 - OFFSET_X, 8 ) ;
77		//-->Modified by PengYunQuan for Validity Cell Range Picker
78		Text [ en-US ] = "~Allow" ;
79	};
80	ListBox LB_ALLOW
81	{
82		HelpID = "sc:ListBox:TP_VALIDATION_VALUES:LB_ALLOW" ;
83		Border = TRUE ;
84		//<!--Modified by PengYunQuan for Validity Cell Range Picker
85		//Pos = MAP_APPFONT ( 80, 14 ) ;
86		Pos = MAP_APPFONT ( 80 - OFFSET_X, 14 ) ;
87		//-->Modified by PengYunQuan for Validity Cell Range Picker
88		Size = MAP_APPFONT ( 90, 80 ) ;
89		TabStop = TRUE ;
90		DropDown = TRUE ;
91		StringList [ en-US ] =
92		{
93			< "All values" ; SC_VALIDDLG_ALLOW_ANY ;		> ;
94			< "Whole Numbers" ; SC_VALIDDLG_ALLOW_WHOLE ;	> ;
95			< "Decimal" ; SC_VALIDDLG_ALLOW_DECIMAL ;		> ;
96			< "Date" ; SC_VALIDDLG_ALLOW_DATE ;				> ;
97			< "Time" ; SC_VALIDDLG_ALLOW_TIME ;				> ;
98			< "Cell range" ; SC_VALIDDLG_ALLOW_RANGE ;		> ;
99			< "List" ; SC_VALIDDLG_ALLOW_LIST ;				> ;
100			< "Text length" ; SC_VALIDDLG_ALLOW_TEXTLEN ;	> ;
101		};
102	};
103	FixedText FT_VALUE
104	{
105		Pos = MAP_APPFONT ( 6, 58 ) ;
106		//<!--Modified by PengYunQuan for Validity Cell Range Picker
107		//Size = MAP_APPFONT ( 70, 8 ) ;
108		Size = MAP_APPFONT ( 70 - OFFSET_X, 8 ) ;
109		//-->Modified by PengYunQuan for Validity Cell Range Picker
110		Text [ en-US ] = "~Data" ;
111	};
112	ListBox LB_VALUE
113	{
114		HelpID = "sc:ListBox:TP_VALIDATION_VALUES:LB_VALUE" ;
115		Border = TRUE ;
116		//<!--Modified by PengYunQuan for Validity Cell Range Picker
117		//Pos = MAP_APPFONT ( 80, 56 ) ;
118		Pos = MAP_APPFONT ( 80 - OFFSET_X, 56 ) ;
119		//-->Modified by PengYunQuan for Validity Cell Range Picker
120		Size = MAP_APPFONT ( 90, 90 ) ;
121		TabStop = TRUE ;
122		DropDown = TRUE ;
123		//	Reihenfolge entspricht enum ScConditionMode
124		StringList [ en-US ] =
125		{
126			< "equal" ; SC_VALIDDLG_DATA_EQUAL ;						> ;
127			< "less than" ; SC_VALIDDLG_DATA_LESS ;						> ;
128			< "greater than" ; SC_VALIDDLG_DATA_GREATER ;				> ;
129			< "less than or equal" ; SC_VALIDDLG_DATA_EQLESS ;			> ;
130			< "greater than or equal to" ; SC_VALIDDLG_DATA_EQGREATER ;	> ;
131			< "not equal" ; SC_VALIDDLG_DATA_NOTEQUAL ;					> ;
132			< "between" ; SC_VALIDDLG_DATA_BETWEEN ;					> ;
133			< "not between" ; SC_VALIDDLG_DATA_NOTBETWEEN ;				> ;
134		};
135	};
136	FixedText FT_MIN
137	{
138		Pos = MAP_APPFONT ( 6, 76 ) ;
139		//<!--Modified by PengYunQuan for Validity Cell Range Picker
140		//Size = MAP_APPFONT ( 70, 8 ) ;
141		Size = MAP_APPFONT ( 70 - OFFSET_X, 8 ) ;
142		//-->Modified by PengYunQuan for Validity Cell Range Picker
143		Text [ en-US ] = "~Minimum" ;
144	};
145	Edit EDT_MIN
146	{
147		HelpID = "sc:Edit:TP_VALIDATION_VALUES:EDT_MIN" ;
148		Border = TRUE ;
149		//<!--Modified by PengYunQuan for Validity Cell Range Picker
150		//Pos = MAP_APPFONT ( 80, 74 ) ;
151		//Size = MAP_APPFONT ( 174, 12 ) ;
152		Pos = MAP_APPFONT ( 80 - OFFSET_X, 74 ) ;
153		Size = MAP_APPFONT ( 90, 12 ) ;
154		//-->Modified by PengYunQuan for Validity Cell Range Picker
155		TabStop = TRUE ;
156	};
157	MultiLineEdit EDT_LIST
158	{
159		HelpID = "sc:MultiLineEdit:TP_VALIDATION_VALUES:EDT_LIST" ;
160		Border = TRUE ;
161		//<!--Modified by PengYunQuan for Validity Cell Range Picker
162		//Pos = MAP_APPFONT ( 80, 74 ) ;
163		//Size = MAP_APPFONT ( 174, 105 ) ;
164		Pos = MAP_APPFONT ( 80 - OFFSET_X, 74 ) ;
165		Size = MAP_APPFONT ( 174 + OFFSET_X, 105 ) ;
166		//-->Modified by PengYunQuan for Validity Cell Range Picker
167		VScroll = TRUE ;
168		IgnoreTab = TRUE ;
169	};
170	FixedText FT_MAX
171	{
172		Pos = MAP_APPFONT ( 6, 92 ) ;
173		//<!--Modified by PengYunQuan for Validity Cell Range Picker
174		//Size = MAP_APPFONT ( 70, 8 ) ;
175		Size = MAP_APPFONT ( 70 - OFFSET_X, 8 ) ;
176		//-->Modified by PengYunQuan for Validity Cell Range Picker
177		Text [ en-US ] = "Ma~ximum" ;
178	};
179	Edit EDT_MAX
180	{
181		HelpID = "sc:Edit:TP_VALIDATION_VALUES:EDT_MAX" ;
182		Border = TRUE ;
183		//<!--Modified by PengYunQuan for Validity Cell Range Picker
184		//Pos = MAP_APPFONT ( 80, 90 ) ;
185		//Size = MAP_APPFONT ( 174, 12 ) ;
186		Pos = MAP_APPFONT ( 80 - OFFSET_X, 90 ) ;
187		Size = MAP_APPFONT ( 90, 12 ) ;
188		//-->Modified by PengYunQuan for Validity Cell Range Picker
189		TabStop = TRUE ;
190	};
191	CheckBox TSB_ALLOW_BLANKS
192	{
193		HelpID = "sc:CheckBox:TP_VALIDATION_VALUES:TSB_ALLOW_BLANKS" ;
194		//<!--Modified by PengYunQuan for Validity Cell Range Picker
195		//Pos = MAP_APPFONT ( 80, 30 ) ;
196		Pos = MAP_APPFONT ( 80 - OFFSET_X, 30 ) ;
197		//-->Modified by PengYunQuan for Validity Cell Range Picker
198		Size = MAP_APPFONT ( 174, 10 ) ;
199		TabStop = TRUE ;
200		Text [ en-US ] = "Allow ~empty cells" ;
201	};
202	CheckBox CB_SHOWLIST
203	{
204		HelpID = "sc:CheckBox:TP_VALIDATION_VALUES:CB_SHOWLIST" ;
205		//<!--Modified by PengYunQuan for Validity Cell Range Picker
206		//Pos = MAP_APPFONT ( 80, 44 ) ;
207		Pos = MAP_APPFONT ( 80 - OFFSET_X, 44 ) ;
208		//-->Modified by PengYunQuan for Validity Cell Range Picker
209		Size = MAP_APPFONT ( 174, 10 ) ;
210		TabStop = TRUE ;
211		Text [ en-US ] = "Show selection ~list" ;
212	};
213	CheckBox CB_SORTLIST
214	{
215		HelpID = "sc:CheckBox:TP_VALIDATION_VALUES:CB_SORTLIST" ;
216		//<!--Modified by PengYunQuan for Validity Cell Range Picker
217		//Pos = MAP_APPFONT ( 90, 58 ) ;
218		Pos = MAP_APPFONT ( 90 - OFFSET_X, 58 ) ;
219		//-->Modified by PengYunQuan for Validity Cell Range Picker
220		Size = MAP_APPFONT ( 164, 10 ) ;
221		TabStop = TRUE ;
222		Text [ en-US ] = "Sor~t entries ascending" ;
223	};
224	FixedText FT_SOURCEHINT
225	{
226		Pos = MAP_APPFONT ( 80 - OFFSET_X, 90 ) ;
227		Size = MAP_APPFONT ( 174, 64 ) ;
228		WordBreak = TRUE ;
229		Text [ en-US ] = "A valid source can only consist of a contiguous selection of rows and columns, or a formula that results in an area or array." ;
230	};
231	//<!--Added by PengYunQuan for Validity Cell Range Picker
232	ImageButton RB_VALIDITY_REF
233	{
234		HelpID = "sc:ImageButton:TP_VALIDATION_VALUES:RB_VALIDITY_REF" ;
235		Pos = MAP_APPFONT ( 142, 73 ) ;
236		Size = MAP_APPFONT ( 13, 14 ) ;
237		TabStop = TRUE ;
238		QuickHelpText [ en-US ] = "Shrink" ;
239	};
240	//-->Added by PengYunQuan for Validity Cell Range Picker
241};
242
243TabPage TP_VALIDATION_INPUTHELP
244{
245	HelpID = "sc:TabPage:TP_VALIDATION_INPUTHELP" ;
246	Hide = TRUE ;
247	SVLook = TRUE ;
248	Size = MAP_APPFONT ( 260, 185 ) ;
249	Text = "Eingabehilfe" ;
250	TriStateBox TSB_HELP
251	{
252		HelpID = "sc:TriStateBox:TP_VALIDATION_INPUTHELP:TSB_HELP" ;
253		Pos = MAP_APPFONT ( 6, 6 ) ;
254		Size = MAP_APPFONT ( 248, 10 ) ;
255		TabStop = TRUE ;
256		Text [ en-US ] = "~Show input help when cell is selected" ;
257	};
258	FixedLine FL_CONTENT
259	{
260		Pos = MAP_APPFONT ( 6, 22 ) ;
261		Size = MAP_APPFONT ( 248, 8 ) ;
262		Text [ en-US ] = "Contents" ;
263	};
264	FixedText FT_TITLE
265	{
266		Pos = MAP_APPFONT ( 12, 35 ) ;
267		Size = MAP_APPFONT ( 64, 8 ) ;
268		Text [ en-US ] = "~Title" ;
269	};
270	FixedText FT_INPUTHELP
271	{
272		Pos = MAP_APPFONT ( 12, 53 ) ;
273		Size = MAP_APPFONT ( 64, 8 ) ;
274		Text [ en-US ] = "~Input help" ;
275	};
276	Edit EDT_TITLE
277	{
278		HelpID = "sc:Edit:TP_VALIDATION_INPUTHELP:EDT_TITLE" ;
279		Border = TRUE ;
280		Pos = MAP_APPFONT ( 80, 33 ) ;
281		Size = MAP_APPFONT ( 171, 12 ) ;
282		TabStop = TRUE ;
283	};
284	MultiLineEdit EDT_INPUTHELP
285	{
286		HelpID = "sc:MultiLineEdit:TP_VALIDATION_INPUTHELP:EDT_INPUTHELP" ;
287		Border = TRUE ;
288		Pos = MAP_APPFONT ( 80, 51 ) ;
289		Size = MAP_APPFONT ( 171, 128 ) ;
290		TabStop = TRUE ;
291		VScroll = TRUE ;
292		IgnoreTab = TRUE ;
293	};
294};
295
296TabPage TP_VALIDATION_ERROR
297{
298	HelpID = "sc:TabPage:TP_VALIDATION_ERROR" ;
299	Hide = TRUE ;
300	SVLook = TRUE ;
301	Size = MAP_APPFONT ( 260, 185 ) ;
302	FixedLine FL_CONTENT
303	{
304		Pos = MAP_APPFONT ( 6, 22 ) ;
305		Size = MAP_APPFONT ( 248, 8 ) ;
306		Text [ en-US ] = "Contents" ;
307	};
308	TriStateBox TSB_SHOW
309	{
310		HelpID = "sc:TriStateBox:TP_VALIDATION_ERROR:TSB_SHOW" ;
311		Pos = MAP_APPFONT ( 6, 6 ) ;
312		Size = MAP_APPFONT ( 248, 10 ) ;
313		TabStop = TRUE ;
314		Text [ en-US ] = "Show error ~message when invalid values are entered" ;
315	};
316	MultiLineEdit EDT_ERROR
317	{
318		HelpID = "sc:MultiLineEdit:TP_VALIDATION_ERROR:EDT_ERROR" ;
319		Border = TRUE ;
320		Pos = MAP_APPFONT ( 80, 69 ) ;
321		Size = MAP_APPFONT ( 171, 110 ) ;
322		TabStop = TRUE ;
323		VScroll = TRUE ;
324		IgnoreTab = TRUE ;
325	};
326	Edit EDT_TITLE
327	{
328		HelpID = "sc:Edit:TP_VALIDATION_ERROR:EDT_TITLE" ;
329		Border = TRUE ;
330		Pos = MAP_APPFONT ( 80, 51 ) ;
331		Size = MAP_APPFONT ( 171, 12 ) ;
332		TabStop = TRUE ;
333	};
334	FixedText FT_ERROR
335	{
336		Pos = MAP_APPFONT ( 12, 71 ) ;
337		Size = MAP_APPFONT ( 64, 8 ) ;
338		Text [ en-US ] = "~Error message" ;
339	};
340	FixedText FT_TITLE
341	{
342		Pos = MAP_APPFONT ( 12, 53 ) ;
343		Size = MAP_APPFONT ( 64, 8 ) ;
344		Text [ en-US ] = "~Title" ;
345	};
346	FixedText FT_ACTION
347	{
348		Pos = MAP_APPFONT ( 12, 35 ) ;
349		Size = MAP_APPFONT ( 64, 8 ) ;
350		Text [ en-US ] = "~Action" ;
351	};
352	ListBox LB_ACTION
353	{
354		HelpID = "sc:ListBox:TP_VALIDATION_ERROR:LB_ACTION" ;
355		Border = TRUE ;
356		Pos = MAP_APPFONT ( 80, 33 ) ;
357		Size = MAP_APPFONT ( 107, 76 ) ;
358		TabStop = TRUE ;
359		DropDown = TRUE ;
360		//	Reihenfolge entspricht enum ScValidErrorStyle
361		StringList [ en-US ] =
362		{
363			< "Stop" ; Default ;		> ;
364			< "Warning" ; Default ;		> ;
365			< "Information" ; Default ;	> ;
366			< "Macro" ; Default ;		> ;
367		};
368	};
369	PushButton BTN_SEARCH
370	{
371		HelpID = "sc:PushButton:TP_VALIDATION_ERROR:BTN_SEARCH" ;
372		Pos = MAP_APPFONT ( 191, 32 ) ;
373		Size = MAP_APPFONT ( 60, 14 ) ;
374		TabStop = TRUE ;
375		Text [ en-US ] = "~Browse..." ;
376	};
377	Text [ en-US ] = "Error Alert" ;
378};
379
380// ********************************************************************** EOF
381