xref: /AOO42X/main/wizards/source/euro/Init.xba (revision 717feae994648a95e5c6051dd798f1832b307d99)
1<?xml version="1.0" encoding="UTF-8"?>
2<!DOCTYPE script:module PUBLIC "-//OpenOffice.org//DTD OfficeDocument 1.0//EN" "module.dtd">
3<!--***********************************************************
4 *
5 * Licensed to the Apache Software Foundation (ASF) under one
6 * or more contributor license agreements.  See the NOTICE file
7 * distributed with this work for additional information
8 * regarding copyright ownership.  The ASF licenses this file
9 * to you under the Apache License, Version 2.0 (the
10 * "License"); you may not use this file except in compliance
11 * with the License.  You may obtain a copy of the License at
12 *
13 *   http://www.apache.org/licenses/LICENSE-2.0
14 *
15 * Unless required by applicable law or agreed to in writing,
16 * software distributed under the License is distributed on an
17 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
18 * KIND, either express or implied.  See the License for the
19 * specific language governing permissions and limitations
20 * under the License.
21 *
22 ***********************************************************-->
23<script:module xmlns:script="http://openoffice.org/2000/script" script:name="Init" script:language="StarBasic">Option Explicit
24REM ***** BASIC *****
25
26Public Const SBRANGEUBOUND = 20
27Public StyleRangeAssignmentList(SBRANGEUBOUND)as String
28Public SelRangeList(SBRANGEUBOUND) as String
29Public RangeList(SBRANGEUBOUND) as String
30Public UnprotectList() as String
31Public FilterNames(2,1) as String
32Public bDoUnProtect as Boolean
33Public bCancelTask as Boolean
34
35Public sREADY as String
36Public sPROTECT as String
37Public sCONTINUE as String
38
39Public sSELTEMPL as String
40Public sSELCELL as String
41Public sCURRRANGES as String
42Public sTEMPLATES as String
43
44Public sSOURCEFILE as String
45Public sSOURCEDIR as String
46Public sTARGETDIR as String
47
48Public sStsPROGRESS as String
49Public sStsCELLPROGRSS as String
50Public sStsRELRANGES as String
51Public sStsRELSHEETRANGES as String
52Public sStsREPROTECT as String
53
54Public sMsgSELDIR as String
55Public sMsgSELFILE as String
56Public sMsgTARGETDIR as String
57Public sMsgNOTTHERE as String
58Public sMsgDLGTITLE as String
59Public sMsgUNPROTECT as String
60Public sMsgPWPROTECT as String
61Public sMsgWRONGPW as String
62Public sMsgSHEETPROTECTED as String
63Public sMsgWARNING as String
64Public sMsgSHEETSNOPROTECT as String
65Public sMsgSHEETNOPROTECT as String
66Public sMsgCHOOSECURRENCY as String
67Public sMsgPASSWORD as String
68Public sMsgOK as String
69Public sMsgCANCEL as String
70Public sMsgFileInvalid as String
71Public sMsgNODIRECTORY as String
72Public sMsgDOCISREADONLY as String
73Public sMsgFileExists as String
74Public sMsgCancelConversion as String
75Public sMsgCancelTitle as String
76Public sCurrPORTUGUESE as String
77Public sCurrDUTCH as String
78Public sCurrFRENCH as String
79Public sCurrSPANISH as String
80Public sCurrITALIAN as String
81Public sCurrGERMAN as String
82Public sCurrBELGIAN as String
83Public sCurrIRISH as String
84Public sCurrLUXEMBOURG as String
85Public sCurrAUSTRIAN as String
86Public sCurrFINNISH as String
87Public sCurrGREEK as String
88Public sCurrSLOVENIAN as String
89Public sCurrCYPRIOT as String
90Public sCurrMALTESE as String
91Public sCurrSLOVAK as String
92Public sCurrESTONIAN as String
93Public sCurrLATVIAN as String
94Public sCurrLITHUANIAN as String
95Public sCurrCROATIAN as String
96Public sCurrBULGARIAN as String
97Public sCurrUNKNOWN as String
98Public sCurrSYSUNKNOWN as String
99
100Public sPrgsRETRIEVAL as String
101Public sPrgsCONVERTING as String
102Public sPrgsUNPROTECT as String
103Public sInclusiveSubDir as String
104
105Public Const SBCOUNTRYCOUNT = 20
106Public CurMimeType as String
107Public CurCellCount as Long
108Public oSheets as Object
109Public oStyles as Object
110Public oStyle as Object
111Public oFormats as Object
112Public aSimpleStr as String
113Public nSimpleKey as Long
114Public aFormat() as Variant
115Public oRanges as Object
116Public oRange as Object
117Public nLanguage as integer
118Public nFormatLanguage as integer
119Public aCellFormat as Variant
120Public oDocument as Object
121Public StartCol, StartRow, EndCol, EndRow as String
122Public oSheet as Object
123Public IntStartCol,	IntStartRow, IntEndCol,	IntEndRow as integer
124Public oSelRanges as Object
125Public nFormatType as Integer
126Public sFormatCurrency as String
127Public sFormatLanguage as String
128Public CurSheetName as String
129Public oStatusLine as Object
130Public Const SBRELGET = 50
131Public StatusValue as Single
132Public TotCellCount as Long
133Public StyleIndex as Integer
134Public RangeIndex as Integer
135Public CurrIndex as Integer
136Public ActLangNumber(1) as Integer
137Public CurExtension(2) as String
138Public Currfactor as Double
139Public CurrSymbolList(2) as String
140Public CurrLanguage as String
141Public CurrValue(20,5)
142Public LangIDValue(20,2,2) as String
143Public PreName as String
144Public Separator as String
145Public BitmapDir as String
146Public TypeIndex as Integer, CSIndex as Integer, LangIndex as Integer, FSIndex as Integer
147Public oLocale as New com.sun.star.lang.Locale
148Public sEuroSign as String
149Public oPointer as Object
150Public sDocType as String
151Public bPreSelected as Boolean
152Public bRecursive as Boolean
153Public bCancelProtection as Boolean
154Public CurrRoundMode as Boolean
155Public bRangeListDefined as Boolean
156Public bDocHasProtectedSheets as Boolean
157Public sGOON as String
158Public sHELP as String
159Public sCANCEL as String
160Dim sEnd as String
161
162Sub InitializeResources()
163Dim LocWorkPath as String
164	With DialogModel
165		&apos; Strings that are also needed by the Password Dialog
166		sGoOn = GetResText(1003)
167		sHelp = GetResText(1001)
168		sCANCEL = GetResText(1418)
169		sEnd = GetResText(1000)
170		sPROTECT = GetResText(1005)
171		sCONTINUE = GetResText(1007)
172		sSELTEMPL = GetResText(1106)
173		sSELCELL = GetResText(1107)
174		sCURRRANGES = GetResText(1108)
175		sTEMPLATES = GetResText(1109)
176		sStsPROGRESS = GetResText(1300)
177		sStsCELLPROGRSS = GetResText(1301)
178		sStsRELSHEETRANGES = GetResText(1302)
179		sStsRELRANGES = GetResText(1303)
180		sStsREPROTECT = GetResText(1304)
181		sREADY = GetResText(1400)
182		sMsgSELDIR = GetResText(1401)
183		sMsgSELFILE = GetResText(1402)
184		sMsgTARGETDIR = GetResText(1403)
185		sMsgNOTTHERE = GetResText(1404)
186		sMsgDLGTITLE = GetResText(1405)
187		sMsgUNPROTECT = GetResText(1406)
188		sMsgPWPROTECT = GetResText(1407)
189		sMsgWRONGPW = GetResText(1408)
190		sMsgSHEETPROTECTED = GetResText(1409)
191		sMsgWARNING = GetResText(1410)
192		sMsgSHEETSNOPROTECT = GetResText(1411)
193		sMsgSHEETNOPROTECT = GetResText(1412)
194		sMsgCHOOSECURRENCY = GetResText(1415)
195		sMsgPASSWORD = GetResText(1416)
196		sMsgOK = GetResText(1417)
197		sMsgCANCEL = GetResText(1418)
198		sMsgFILEINVALID = GetResText(1419)
199		sMsgFILEINVALID = ReplaceString(sMsgFILEINVALID,&quot;%PRODUCTNAME&quot;, GetProductname())
200		SMsgNODIRECTORY = GetResText(1420)
201		sMsgDOCISREADONLY = GetResText(1421)
202		sMsgFileExists = GetResText(1422)
203		sMsgCancelConversion = GetResText(1423)
204		sMsgCancelTitle = GetResText(1424)
205		sCurrPORTUGUESE = GetResText(1500)
206		sCurrDUTCH = GetResText(1501)
207		sCurrFRENCH = GetResText(1502)
208		sCurrSPANISH = GetResText(1503)
209		sCurrITALIAN = GetResText(1504)
210		sCurrGERMAN = GetResText(1505)
211		sCurrBELGIAN = GetResText(1506)
212		sCurrIRISH = GetResText(1507)
213		sCurrLUXEMBOURG = GetResText(1508)
214		sCurrAUSTRIAN = GetResText(1509)
215		sCurrFINNISH = GetResText(1510)
216		sCurrGREEK = GetResText(1511)
217		sCurrSLOVENIAN = GetResText(1512)
218		sCurrCYPRIOT = GetResText(1513)
219		sCurrMALTESE = GetResText(1514)
220		sCurrSLOVAK = GetResText(1515)
221		sCurrESTONIAN = GetResText(1516)
222		sCurrLATVIAN = GetResText(1517)
223		sCurrLITHUANIAN = GetResText(1518)
224		sCurrCROATIAN = GetResText(1519)
225		sCurrBULGARIAN = GetResText(1520)
226		sCurrUNKNOWN = GetResText(1521)
227		sCurrSYSUNKNOWN = GetResText(1522)
228		.cmdCancel.Label = sCANCEL
229		.cmdHelp.Label = sHELP
230		.cmdBack.Label = GetResText(1002)
231		.cmdGoOn.Label = sGOON
232		.lblHint.Label = GetResText(1004)
233		.lblCurrencies.Label = GetResText(1006)
234		.cmdBack.Enabled = False
235		If .Step = 1 Then
236			.chkComplete.Label = GetResText(1100)
237			.hlnSelection.Label = GetResText(1101)
238			.optCellTemplates.Label = GetResText(1102)
239			.optSheetRanges.Label = GetResText(1103)
240			.optDocRanges.Label = GetResText(1104)
241			.optSelRange.Label = GetResText(1105)
242			sCURRRANGES = GetResText(1108)
243			.lblSelection.Label = sCURRRANGES
244		Else
245			.lblProgress.Label = sStsPROGRESS
246		 	.hlnExtent.Label = GetResText(1200)
247			.optSingleFile.Label = GetResText(1201)
248 			.optWholeDir.Label = GetResText(1202)
249 			.chkProtect.Label = GetResText(1207)
250 			.chkTextDocuments.Label = GetResText(1210)
251
252			sSOURCEFILE = GetResText(1203)
253			sSOURCEDIR = GetResText(1204)
254 			.lblSource.Label = sSOURCEDIR
255 			sInclusiveSubDir = GetResText(1205)
256 			.chkRecursive.Label = sInclusiveSubDir
257			sTARGETDIR = GetResText(1206)
258 			.lblTarget.Label = STARGETDIR
259
260			LocWorkPath = GetPathSettings(&quot;Work&quot;)
261			If Not oUcb.Exists(LocWorkPath) Then
262				ShowNoOfficePathError()
263				Stop
264			End If
265
266			.txtSource.Text = ConvertfromUrl(LocWorkPath)
267
268			SubstDir = .txtSource.Text
269			.txtTarget.Text = .txtSource.Text
270			.hlnProgress.Label = GetResText(1600)
271			.lblConfig.Label = GetResText(1603)
272			sPrgsRETRIEVAL = GetResText(1601)
273			sPrgsCONVERTING = GetResText(1602)
274			sPrgsUNPROTECT = GetResText(1604)
275		End If
276	End With
277End Sub
278
279Sub InitializeLanguages()
280	sEuroSign = chr(8364)
281
282&apos; CURRENCIES_PORTUGUESE
283	LangIDValue(0,0,0) = &quot;pt&quot;
284	LangIDValue(0,0,1) = &quot;&quot;
285	LangIDValue(0,0,2) = &quot;-816&quot;
286
287&apos; CURRENCIES_DUTCH
288	LangIDValue(1,0,0) = &quot;nl&quot;
289	LangIDValue(1,0,1) = &quot;&quot;
290	LangIDValue(1,0,2) = &quot;-413&quot;
291
292&apos; CURRENCIES_FRENCH
293	LangIDValue(2,0,0) = &quot;fr&quot;
294	LangIDValue(2,0,1) = &quot;&quot;
295	LangIDValue(2,0,2) = &quot;-40C&quot;
296
297&apos; CURRENCIES_SPANISH
298	LangIDValue(3,0,0) = &quot;es&quot;
299	LangIDValue(3,0,1) = &quot;&quot;
300	LangIDValue(3,0,2) = &quot;-40A&quot;
301
302	&apos;Spanish modern
303	LangIDValue(3,1,0) = &quot;es&quot;
304	LangIDValue(3,1,1) = &quot;&quot;
305	LangIDValue(3,1,2) = &quot;-C0A&quot;
306
307	&apos;Spanish katalanic
308	LangIDValue(3,2,0) = &quot;es&quot;
309	LangIDValue(3,2,1) = &quot;&quot;
310	LangIDValue(3,2,2) = &quot;-403&quot;
311
312&apos; CURRENCIES_ITALIAN
313	LangIDValue(4,0,0) = &quot;it&quot;
314	LangIDValue(4,0,1) = &quot;&quot;
315	LangIDValue(4,0,2) = &quot;-410&quot;
316
317&apos; CURRENCIES_GERMAN
318	LangIDValue(5,0,0) = &quot;de&quot;
319	LangIDValue(5,0,1) = &quot;DE&quot;
320	LangIDValue(5,0,2) = &quot;-407&quot;
321
322&apos; CURRENCIES_BELGIAN
323	LangIDValue(6,0,0) = &quot;fr&quot;
324	LangIDValue(6,0,1) = &quot;BE&quot;
325	LangIDValue(6,0,2) = &quot;-80C&quot;
326
327	LangIDValue(6,1,0) = &quot;nl&quot;
328	LangIDValue(6,1,1) = &quot;BE&quot;
329	LangIDValue(6,1,2) = &quot;-813&quot;
330
331&apos; CURRENCIES_IRISH
332	LangIDValue(7,0,0) = &quot;en&quot;
333	LangIDValue(7,0,1) = &quot;IE&quot;
334	LangIDValue(7,0,2) = &quot;-1809&quot;
335
336	LangIDValue(7,1,0) = &quot;ga&quot;
337	LangIDValue(7,1,1) = &quot;IE&quot;
338	LangIDValue(7,1,2) = &quot;-83C&quot;
339
340&apos; CURRENCIES_LUXEMBOURG
341	LangIDValue(8,0,0) = &quot;fr&quot;
342	LangIDValue(8,0,1) = &quot;LU&quot;
343	LangIDValue(8,0,2) = &quot;-140C&quot;
344
345	LangIDValue(8,1,0) = &quot;de&quot;
346	LangIDValue(8,1,1) = &quot;LU&quot;
347	LangIDValue(8,1,2) = &quot;-1007&quot;
348
349&apos; CURRENCIES_AUSTRIAN
350	LangIDValue(9,0,0) = &quot;de&quot;
351	LangIDValue(9,0,1) = &quot;AT&quot;
352	LangIDValue(9,0,2) = &quot;-C07&quot;
353
354&apos; CURRENCIES_FINNISH
355	LangIDValue(10,0,0) = &quot;fi&quot;
356	LangIDValue(10,0,1) = &quot;FI&quot;
357	LangIDValue(10,0,2) = &quot;-40B&quot;
358
359	LangIDValue(10,1,0) = &quot;sv&quot;
360	LangIDValue(10,1,1) = &quot;FI&quot;
361	LangIDValue(10,1,2) = &quot;-81D&quot;
362
363&apos; CURRENCIES_GREEK
364	LangIDValue(11,0,0) = &quot;el&quot;
365	LangIDValue(11,0,1) = &quot;GR&quot;
366	LangIDValue(11,0,2) = &quot;-408&quot;
367
368&apos; CURRENCIES_SLOVENIAN
369	LangIDValue(12,0,0) = &quot;sl&quot;
370	LangIDValue(12,0,1) = &quot;SI&quot;
371	LangIDValue(12,0,2) = &quot;-424&quot;
372
373&apos; CURRENCIES_CYPRIOT
374	LangIDValue(13,0,0) = &quot;el&quot;
375	LangIDValue(13,0,1) = &quot;CY&quot;
376	LangIDValue(13,0,2) = &quot;-408&quot;
377
378&apos; CURRENCIES_MALTESE
379	LangIDValue(14,0,0) = &quot;mt&quot;
380	LangIDValue(14,0,1) = &quot;MT&quot;
381	LangIDValue(14,0,2) = &quot;-43A&quot;
382
383&apos; CURRENCIES_SLOVAK
384	LangIDValue(15,0,0) = &quot;sk&quot;
385	LangIDValue(15,0,1) = &quot;SK&quot;
386	LangIDValue(15,0,2) = &quot;-41B&quot;
387
388&apos; CURRENCIES_ESTONIAN
389	LangIDValue(16,0,0) = &quot;et&quot;
390	LangIDValue(16,0,1) = &quot;ET&quot;
391	LangIDValue(16,0,2) = &quot;-425&quot;
392
393&apos; CURRENCIES_LATVIAN
394	LangIDValue(17,0,0) = &quot;lv&quot;
395	LangIDValue(17,0,1) = &quot;LV&quot;
396	LangIDValue(17,0,2) = &quot;-426&quot;
397
398	&apos;Latgalian
399	LangIDValue(17,1,0) = &quot;ltg&quot;
400	LangIDValue(17,1,1) = &quot;LV&quot;
401	LangIDValue(17,1,2) = &quot;-64B&quot;
402
403&apos; CURRENCIES_LITHUANIAN
404	LangIDValue(18,0,0) = &quot;lt&quot;
405	LangIDValue(18,0,1) = &quot;LT&quot;
406	LangIDValue(18,0,2) = &quot;-427&quot;
407
408&apos; CURRENCIES_CROATIAN
409	LangIDValue(19,0,0) = &quot;hr&quot;
410	LangIDValue(19,0,1) = &quot;HR&quot;
411	LangIDValue(19,0,2) = &quot;-41A&quot;
412
413&apos; CURRENCIES_BULGARIAN
414	LangIDValue(20,0,0) = &quot;bg&quot;
415	LangIDValue(20,0,1) = &quot;BG&quot;
416	LangIDValue(20,0,2) = &quot;-402&quot;
417
418End Sub
419
420
421
422Sub InitializeCurrencies()
423Dim i as Integer
424	GoOn = True
425
426	CurrValue(0,0) = sCurrPORTUGUESE
427	&apos; real conversion rate
428	CurrValue(0,1) = 200.482
429	&apos; rounded conversion rate
430	CurrValue(0,2) = 200
431	CurrValue(0,3) = &quot;Esc.&quot;
432	CurrValue(0,4) = &quot;Esc.&quot;
433	CurrValue(0,5) = &quot;PTE&quot;
434
435	CurrValue(1,0) = sCurrDUTCH
436	&apos; real conversion rate
437	CurrValue(1,1) = 2.20371
438	&apos; rounded conversion rate
439	CurrValue(1,2) = 2
440	CurrValue(1,3) = &quot;F&quot;
441	CurrValue(1,4) = &quot;fl&quot;
442	CurrValue(1,5) = &quot;NLG&quot;
443
444	CurrValue(2,0) = sCurrFRENCH
445	&apos; real conversion rate
446	CurrValue(2,1) = 6.55957
447	&apos; rounded conversion rate
448	CurrValue(2,2) = 7
449	CurrValue(2,3) = &quot;F&quot;
450	CurrValue(2,4) = &quot;F&quot;
451	CurrValue(2,5) = &quot;FRF&quot;
452
453	CurrValue(3,0) = sCurrSPANISH
454	&apos; real conversion rate
455	CurrValue(3,1) = 166.386
456	&apos; rounded conversion rate
457	CurrValue(3,2) = 170
458	CurrValue(3,3) = &quot;Pts&quot;
459	CurrValue(3,4) = &quot;Pts&quot;
460	CurrValue(3,5) = &quot;ESP&quot;
461
462	CurrValue(4,0) = sCurrITALIAN
463	&apos; real conversion rate
464	CurrValue(4,1) = 1936.27
465	&apos; rounded conversion rate
466	CurrValue(4,2) = 2000
467	CurrValue(4,3) = &quot;L.&quot;
468	CurrValue(4,4) = &quot;L.&quot;
469	CurrValue(4,5) = &quot;ITL&quot;
470
471	CurrValue(5,0) = sCurrGERMAN
472	&apos; real conversion rate
473	CurrValue(5,1) = 1.95583
474	&apos; rounded conversion rate
475	CurrValue(5,2) = 2
476	CurrValue(5,3) = &quot;DM&quot;
477	CurrValue(5,4) = &quot;DM&quot;
478	CurrValue(5,5) = &quot;DEM&quot;
479
480	CurrValue(6,0) = sCurrBELGIAN
481	&apos; real conversion rate
482	CurrValue(6,1) = 40.3399
483	&apos; rounded conversion rate
484	CurrValue(6,2) = 40
485	CurrValue(6,3) = &quot;FB&quot;
486	CurrValue(6,4) = &quot;BF&quot;
487	CurrValue(6,5) = &quot;BEF&quot;
488
489	CurrValue(7,0) = sCurrIRISH
490	&apos; real conversion rate
491	CurrValue(7,1) = 0.787564
492	&apos; rounded conversion rate
493	CurrValue(7,2) = 0.8
494	CurrValue(7,3) = &quot;IR£&quot;
495	CurrValue(7,4) = &quot;£&quot;
496	CurrValue(7,5) = &quot;IEP&quot;
497
498	CurrValue(8,0) = sCurrLUXEMBOURG
499	&apos; real conversion rate
500	CurrValue(8,1) = 40.3399
501	&apos; rounded conversion rate
502	CurrValue(8,2) = 40
503	CurrValue(8,3) = &quot;F&quot;
504	CurrValue(8,4) = &quot;F&quot;
505	CurrValue(8,5) = &quot;LUF&quot;
506
507	CurrValue(9,0) = sCurrAUSTRIAN
508	&apos; real conversion rate
509	CurrValue(9,1) = 13.7603
510	&apos; rounded conversion rate
511	CurrValue(9,2) = 15
512	CurrValue(9,3) = &quot;öS&quot;
513	CurrValue(9,4) = &quot;S&quot;
514	CurrValue(9,5) = &quot;ATS&quot;
515
516	CurrValue(10,0) = sCurrFINNISH
517	&apos; real conversion rate
518	CurrValue(10,1) = 5.94573
519	&apos; rounded conversion rate
520	CurrValue(10,2) = 6
521	CurrValue(10,3) = &quot;mk&quot;
522	CurrValue(10,4) = &quot;mk&quot;
523	CurrValue(10,5) = &quot;FIM&quot;
524
525	CurrValue(11,0) = sCurrGREEK
526	&apos; real conversion rate
527	CurrValue(11,1) = 340.750
528	&apos; rounded conversion rate
529	CurrValue(11,2) = 400
530	CurrValue(11,3) = chr(916) &amp; chr(961) &amp; chr(967)
531	CurrValue(11,4) = chr(916) &amp; chr(961) &amp; chr(967)
532	CurrValue(11,5) = &quot;GRD&quot;
533
534	CurrValue(12,0) = sCurrSLOVENIAN
535	&apos; real conversion rate
536	CurrValue(12,1) = 239.64
537	&apos; rounded conversion rate
538	CurrValue(12,2) = 240
539	CurrValue(12,3) = &quot;SIT&quot;
540	CurrValue(12,4) = &quot;SIT&quot;
541	CurrValue(12,5) = &quot;SIT&quot;
542
543	CurrValue(13,0) = sCurrCYPRIOT
544	&apos; real conversion rate
545	CurrValue(13,1) = 0.585274
546	&apos; rounded conversion rate
547	CurrValue(13,2) = 0.6
548	CurrValue(13,3) = &quot;£C&quot;
549	CurrValue(13,4) = &quot;£&quot;
550	CurrValue(13,5) = &quot;CYP&quot;
551
552	CurrValue(14,0) = sCurrMALTESE
553	&apos; real conversion rate
554	CurrValue(14,1) = 0.429300
555	&apos; rounded conversion rate
556	CurrValue(14,2) = 0.4
557	CurrValue(14,3) = chr(8356)
558	CurrValue(14,4) = &quot;Lm&quot;
559	CurrValue(14,5) = &quot;MTL&quot;
560
561	CurrValue(15,0) = sCurrSLOVAK
562	&apos; real conversion rate
563	CurrValue(15,1) = 30.1260
564	&apos; rounded conversion rate
565	CurrValue(15,2) = 30
566	CurrValue(15,3) = &quot;Sk&quot;
567	CurrValue(15,4) = &quot;Sk&quot;
568	CurrValue(15,5) = &quot;SKK&quot;
569
570	CurrValue(16,0) = sCurrESTONIAN
571	&apos; real conversion rate
572	CurrValue(16,1) = 15.6466
573	&apos; rounded conversion rate
574	CurrValue(16,2) = 15
575	CurrValue(16,3) = &quot;kr&quot;
576	CurrValue(16,4) = &quot;kr&quot;
577	CurrValue(16,5) = &quot;EEK&quot;
578
579	CurrValue(17,0) = sCurrLATVIAN
580	&apos; real conversion rate
581	CurrValue(17,1) = 0.702804
582	&apos; rounded conversion rate
583	CurrValue(17,2) = 0.7
584	CurrValue(17,3) = &quot;Ls&quot;
585	CurrValue(17,4) = &quot;Ls&quot;
586	CurrValue(17,5) = &quot;LVL&quot;
587
588	CurrValue(18,0) = sCurrLITHUANIAN
589	&apos; real conversion rate
590	CurrValue(18,1) = 3.45280
591	&apos; rounded conversion rate
592	CurrValue(18,2) = 3.5
593	CurrValue(18,3) = &quot;Lt&quot;
594	CurrValue(18,4) = &quot;Lt&quot;
595	CurrValue(18,5) = &quot;LTL&quot;
596
597	CurrValue(19,0) = sCurrCROATIAN
598	&apos; real conversion rate
599	CurrValue(19,1) = 7.53450
600	&apos; rounded conversion rate
601	CurrValue(19,2) = 7.5
602	CurrValue(19,3) = &quot;kn&quot;
603	CurrValue(19,4) = &quot;kn&quot;
604	CurrValue(19,5) = &quot;HRK&quot;
605
606	CurrValue(20,0) = sCurrBULGARIAN
607	&apos; real conversion rate
608	CurrValue(20,1) = 1.95583
609	&apos; rounded conversion rate
610	CurrValue(20,2) = 2
611	CurrValue(20,3) = &quot;лв.&quot;
612	CurrValue(20,4) = &quot;лв.&quot;
613	CurrValue(20,5) = &quot;BGN&quot;
614
615	i = -1
616	CurrSymbolList(0) = &quot;&quot;
617	CurrSymbolList(1) = &quot;&quot;
618	InitializeCurrencyValues(CurrIndex)
619End Sub
620
621
622Sub InitializeControls()
623	If CurrIndex = -1 Then
624		If DialogModel.Step = 1 Then
625			EnableStep1DialogControls(True, False, False)
626		ElseIf DialogModel.Step = 2 Then
627			EnableStep2DialogControls(True)
628		End If
629	End If
630End Sub
631
632
633Sub InitializeConverter(oLocale, iDialogPage as Integer)
634Dim Isthere as Boolean
635	bCancelProtection = False
636	bRangeListDefined = False
637	PWIndex = -1
638	If iDialogPage = 1 Then
639		ToggleWindow(False)
640		sDocType = Tools.GetDocumentType(ThisComponent)
641		If sDocType = &quot;sCalc&quot; Then
642			bDocHasProtectedSheets = CheckSheetProtection(oSheets)
643		End If
644		oStatusline = ThisComponent.GetCurrentController.GetFrame.CreateStatusIndicator()
645	End If
646	DialogConvert = LoadDialog(&quot;Euro&quot;, &quot;DlgConvert&quot;)
647	DialogModel = DialogConvert.Model
648	DialogPassword = LoadDialog(&quot;Euro&quot;, &quot;DlgPassword&quot;)
649	PasswordModel = DialogPassword.Model
650	DialogModel.Step = iDialogPage
651	InitializeResources()
652	InitializeLanguages()
653	InitializeLocales(oLocale)
654	InitializeCurrencies()
655	InitializeControls()
656	BitmapDir = GetOfficeSubPath(&quot;Template&quot;, &quot;../wizard/bitmap&quot;)
657	If BitmapDir = &quot;&quot; Then
658		Stop
659	End If
660	FillUpCurrencyListbox()
661	DialogModel.imgPreview.ImageUrl = BitmapDir &amp; &quot;euro_&quot; &amp; DialogModel.Step &amp; &quot;.png&quot;
662	DialogConvert.Title = sMsgDLGTITLE
663	DialogModel.cmdGoOn.DefaultButton = True
664	If iDialogPage = 1 Then
665		ToggleWindow(True)
666	End If
667End Sub
668
669
670Sub	InitializeCurrencyValues(CurrIndex)
671	If CurrIndex &lt;&gt; -1 Then
672		CurrLanguage = CurrValue(CurrIndex,0)
673		CurrFactor = CurrValue(CurrIndex,1)
674		CurrSymbolList(0) = CurrValue(CurrIndex,3)
675		CurrSymbolList(1) = CurrValue(CurrIndex,4)
676		CurrSymbolList(2) = CurrValue(CurrIndex,5)
677	End If
678End Sub
679
680
681Function InitializeLocales(oLocale) as Boolean
682Dim i as Integer, n as Integer, m as Integer
683Dim sLanguage as String, sCountry as String
684Dim bTakeThisLocale as Boolean
685	sLanguage = oLocale.Language
686	sCountry = oLocale.Country
687	For n = 0 To SBCOUNTRYCOUNT - 1
688		For m = 0 TO 1
689			If DialogModel.Step = 2 Then
690				bTakeThisLocale = LangIDValue(n,m,0) = sLanguage
691			Else
692				bTakeThisLocale = LangIDValue(n,m,0) = sLanguage
693			End If
694			If bTakeThisLocale Then
695				CurrIndex = n
696				For i = 0 To 2
697					CurExtension(i) = LangIDValue(CurrIndex,i,2)
698				Next i
699				InitializeLocales = True
700				Exit Function
701			End If
702		Next m
703	Next n
704	CurrIndex = -1
705	InitializeLocales = False
706End Function
707</script:module>
708