Init.xba 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624
  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
  24. REM ***** BASIC *****
  25. Public Const SBRANGEUBOUND = 20
  26. Public StyleRangeAssignmentList(SBRANGEUBOUND)as String
  27. Public SelRangeList(SBRANGEUBOUND) as String
  28. Public RangeList(SBRANGEUBOUND) as String
  29. Public UnprotectList() as String
  30. Public FilterNames(2,1) as String
  31. Public bDoUnProtect as Boolean
  32. Public bCancelTask as Boolean
  33. Public sREADY as String
  34. Public sPROTECT as String
  35. Public sCONTINUE as String
  36. Public sSELTEMPL as String
  37. Public sSELCELL as String
  38. Public sCURRRANGES as String
  39. Public sTEMPLATES as String
  40. Public sSOURCEFILE as String
  41. Public sSOURCEDIR as String
  42. Public sTARGETDIR as String
  43. Public sStsPROGRESS as String
  44. Public sStsCELLPROGRSS as String
  45. Public sStsRELRANGES as String
  46. Public sStsRELSHEETRANGES as String
  47. Public sStsREPROTECT as String
  48. Public sMsgSELDIR as String
  49. Public sMsgSELFILE as String
  50. Public sMsgTARGETDIR as String
  51. Public sMsgNOTTHERE as String
  52. Public sMsgDLGTITLE as String
  53. Public sMsgUNPROTECT as String
  54. Public sMsgPWPROTECT as String
  55. Public sMsgWRONGPW as String
  56. Public sMsgSHEETPROTECTED as String
  57. Public sMsgWARNING as String
  58. Public sMsgSHEETSNOPROTECT as String
  59. Public sMsgSHEETNOPROTECT as String
  60. Public sMsgCHOOSECURRENCY as String
  61. Public sMsgPASSWORD as String
  62. Public sMsgOK as String
  63. Public sMsgCANCEL as String
  64. Public sMsgFileInvalid as String
  65. Public sMsgNODIRECTORY as String
  66. Public sMsgDOCISREADONLY as String
  67. Public sMsgFileExists as String
  68. Public sMsgCancelConversion as String
  69. Public sMsgCancelTitle as String
  70. Public sCurrPORTUGUESE as String
  71. Public sCurrDUTCH as String
  72. Public sCurrFRENCH as String
  73. Public sCurrSPANISH as String
  74. Public sCurrITALIAN as String
  75. Public sCurrGERMAN as String
  76. Public sCurrBELGIAN as String
  77. Public sCurrIRISH as String
  78. Public sCurrLUXEMBOURG as String
  79. Public sCurrAUSTRIAN as String
  80. Public sCurrFINNISH as String
  81. Public sCurrGREEK as String
  82. Public sCurrSLOVENIAN as String
  83. Public sCurrCYPRIOT as String
  84. Public sCurrMALTESE as String
  85. Public sCurrSLOVAK as String
  86. Public sCurrUNKNOWN as String
  87. Public sCurrSYSUNKNOWN as String
  88. Public sPrgsRETRIEVAL as String
  89. Public sPrgsCONVERTING as String
  90. Public sPrgsUNPROTECT as String
  91. Public sInclusiveSubDir as String
  92. Public Const SBCOUNTRYCOUNT = 15
  93. Public CurMimeType as String
  94. Public CurCellCount as Long
  95. Public oSheets as Object
  96. Public oStyles as Object
  97. Public oStyle as Object
  98. Public oFormats as Object
  99. Public aSimpleStr as String
  100. Public nSimpleKey as Long
  101. Public aFormat() as Variant
  102. Public oRanges as Object
  103. Public oRange as Object
  104. Public nLanguage as integer
  105. Public nFormatLanguage as integer
  106. Public aCellFormat as Variant
  107. Public oDocument as Object
  108. Public StartCol, StartRow, EndCol, EndRow as String
  109. Public oSheet as Object
  110. Public IntStartCol, IntStartRow, IntEndCol, IntEndRow as integer
  111. Public oSelRanges as Object
  112. Public nFormatType as Integer
  113. Public sFormatCurrency as String
  114. Public sFormatLanguage as String
  115. Public CurSheetName as String
  116. Public oStatusLine as Object
  117. Public Const SBRELGET = 50
  118. Public StatusValue as Single
  119. Public TotCellCount as Long
  120. Public StyleIndex as Integer
  121. Public RangeIndex as Integer
  122. Public CurrIndex as Integer
  123. Public ActLangNumber(1) as Integer
  124. Public CurExtension(2) as String
  125. Public Currfactor as Double
  126. Public CurrSymbolList(2) as String
  127. Public CurrLanguage as String
  128. Public CurrValue(15,5)
  129. Public LangIDValue(15,2,2) as String
  130. Public PreName as String
  131. Public Separator as String
  132. Public BitmapDir as String
  133. Public TypeIndex as Integer, CSIndex as Integer, LangIndex as Integer, FSIndex as Integer
  134. Public oLocale as New com.sun.star.lang.Locale
  135. Public sEuroSign as String
  136. Public oPointer as Object
  137. Public sDocType as String
  138. Public bPreSelected as Boolean
  139. Public bRecursive as Boolean
  140. Public bCancelProtection as Boolean
  141. Public CurrRoundMode as Boolean
  142. Public bRangeListDefined as Boolean
  143. Public bDocHasProtectedSheets as Boolean
  144. Public sGOON as String
  145. Public sHELP as String
  146. Public sCANCEL as String
  147. Dim sEnd as String
  148. Sub InitializeResources()
  149. Dim LocWorkPath as String
  150. With DialogModel
  151. &apos; Strings that are also needed by the Password Dialog
  152. sGoOn = GetResText(1003)
  153. sHelp = GetResText(1001)
  154. sCANCEL = GetResText(1418)
  155. sEnd = GetResText(1000)
  156. sPROTECT = GetResText(1005)
  157. sCONTINUE = GetResText(1007)
  158. sSELTEMPL = GetResText(1106)
  159. sSELCELL = GetResText(1107)
  160. sCURRRANGES = GetResText(1108)
  161. sTEMPLATES = GetResText(1109)
  162. sStsPROGRESS = GetResText(1300)
  163. sStsCELLPROGRSS = GetResText(1301)
  164. sStsRELSHEETRANGES = GetResText(1302)
  165. sStsRELRANGES = GetResText(1303)
  166. sStsREPROTECT = GetResText(1304)
  167. sREADY = GetResText(1400)
  168. sMsgSELDIR = GetResText(1401)
  169. sMsgSELFILE = GetResText(1402)
  170. sMsgTARGETDIR = GetResText(1403)
  171. sMsgNOTTHERE = GetResText(1404)
  172. sMsgDLGTITLE = GetResText(1405)
  173. sMsgUNPROTECT = GetResText(1406)
  174. sMsgPWPROTECT = GetResText(1407)
  175. sMsgWRONGPW = GetResText(1408)
  176. sMsgSHEETPROTECTED = GetResText(1409)
  177. sMsgWARNING = GetResText(1410)
  178. sMsgSHEETSNOPROTECT = GetResText(1411)
  179. sMsgSHEETNOPROTECT = GetResText(1412)
  180. sMsgCHOOSECURRENCY = GetResText(1415)
  181. sMsgPASSWORD = GetResText(1416)
  182. sMsgOK = GetResText(1417)
  183. sMsgCANCEL = GetResText(1418)
  184. sMsgFILEINVALID = GetResText(1419)
  185. sMsgFILEINVALID = ReplaceString(sMsgFILEINVALID,&quot;%PRODUCTNAME&quot;, GetProductname())
  186. SMsgNODIRECTORY = GetResText(1420)
  187. sMsgDOCISREADONLY = GetResText(1421)
  188. sMsgFileExists = GetResText(1422)
  189. sMsgCancelConversion = GetResText(1423)
  190. sMsgCancelTitle = GetResText(1424)
  191. sCurrPORTUGUESE = GetResText(1500)
  192. sCurrDUTCH = GetResText(1501)
  193. sCurrFRENCH = GetResText(1502)
  194. sCurrSPANISH = GetResText(1503)
  195. sCurrITALIAN = GetResText(1504)
  196. sCurrGERMAN = GetResText(1505)
  197. sCurrBELGIAN = GetResText(1506)
  198. sCurrIRISH = GetResText(1507)
  199. sCurrLUXEMBOURG = GetResText(1508)
  200. sCurrAUSTRIAN = GetResText(1509)
  201. sCurrFINNISH = GetResText(1510)
  202. sCurrGREEK = GetResText(1511)
  203. sCurrSLOVENIAN = GetResText(1512)
  204. sCurrCYPRIOT = GetResText(1513)
  205. sCurrMALTESE = GetResText(1514)
  206. sCurrSLOVAK = GetResText(1515)
  207. sCurrUNKNOWN = GetResText(1516)
  208. sCurrSYSUNKNOWN = GetResText(1517)
  209. .cmdCancel.Label = sCANCEL
  210. .cmdHelp.Label = sHELP
  211. .cmdBack.Label = GetResText(1002)
  212. .cmdGoOn.Label = sGOON
  213. .lblHint.Label = GetResText(1004)
  214. .lblCurrencies.Label = GetResText(1006)
  215. .cmdBack.Enabled = False
  216. If .Step = 1 Then
  217. .chkComplete.Label = GetResText(1100)
  218. .hlnSelection.Label = GetResText(1101)
  219. .optCellTemplates.Label = GetResText(1102)
  220. .optSheetRanges.Label = GetResText(1103)
  221. .optDocRanges.Label = GetResText(1104)
  222. .optSelRange.Label = GetResText(1105)
  223. sCURRRANGES = GetResText(1108)
  224. .lblSelection.Label = sCURRRANGES
  225. Else
  226. .lblProgress.Label = sStsPROGRESS
  227. .hlnExtent.Label = GetResText(1200)
  228. .optSingleFile.Label = GetResText(1201)
  229. .optWholeDir.Label = GetResText(1202)
  230. .chkProtect.Label = GetResText(1207)
  231. .chkTextDocuments.Label = GetResText(1210)
  232. sSOURCEFILE = GetResText(1203)
  233. sSOURCEDIR = GetResText(1204)
  234. .lblSource.Label = sSOURCEDIR
  235. sInclusiveSubDir = GetResText(1205)
  236. .chkRecursive.Label = sInclusiveSubDir
  237. sTARGETDIR = GetResText(1206)
  238. .lblTarget.Label = STARGETDIR
  239. LocWorkPath = GetPathSettings(&quot;Work&quot;)
  240. If Not oUcb.Exists(LocWorkPath) Then
  241. ShowNoOfficePathError()
  242. Stop
  243. End If
  244. .txtSource.Text = ConvertfromUrl(LocWorkPath)
  245. SubstDir = .txtSource.Text
  246. .txtTarget.Text = .txtSource.Text
  247. .hlnProgress.Label = GetResText(1600)
  248. .lblConfig.Label = GetResText(1603)
  249. sPrgsRETRIEVAL = GetResText(1601)
  250. sPrgsCONVERTING = GetResText(1602)
  251. sPrgsUNPROTECT = GetResText(1604)
  252. End If
  253. End With
  254. End Sub
  255. Sub InitializeLanguages()
  256. sEuroSign = chr(8364)
  257. &apos; CURRENCIES_PORTUGUESE
  258. LangIDValue(0,0,0) = &quot;pt&quot;
  259. LangIDValue(0,0,1) = &quot;&quot;
  260. LangIDValue(0,0,2) = &quot;-816&quot;
  261. &apos; CURRENCIES_DUTCH
  262. LangIDValue(1,0,0) = &quot;nl&quot;
  263. LangIDValue(1,0,1) = &quot;&quot;
  264. LangIDValue(1,0,2) = &quot;-413&quot;
  265. &apos; CURRENCIES_FRENCH
  266. LangIDValue(2,0,0) = &quot;fr&quot;
  267. LangIDValue(2,0,1) = &quot;&quot;
  268. LangIDValue(2,0,2) = &quot;-40C&quot;
  269. &apos; CURRENCIES_SPANISH
  270. LangIDValue(3,0,0) = &quot;es&quot;
  271. LangIDValue(3,0,1) = &quot;&quot;
  272. LangIDValue(3,0,2) = &quot;-40A&quot;
  273. &apos;Spanish modern
  274. LangIDValue(3,1,0) = &quot;es&quot;
  275. LangIDValue(3,1,1) = &quot;&quot;
  276. LangIDValue(3,1,2) = &quot;-C0A&quot;
  277. &apos;Spanish katalanic
  278. LangIDValue(3,2,0) = &quot;es&quot;
  279. LangIDValue(3,2,1) = &quot;&quot;
  280. LangIDValue(3,2,2) = &quot;-403&quot;
  281. &apos; CURRENCIES_ITALIAN
  282. LangIDValue(4,0,0) = &quot;it&quot;
  283. LangIDValue(4,0,1) = &quot;&quot;
  284. LangIDValue(4,0,2) = &quot;-410&quot;
  285. &apos; CURRENCIES_GERMAN
  286. LangIDValue(5,0,0) = &quot;de&quot;
  287. LangIDValue(5,0,1) = &quot;DE&quot;
  288. LangIDValue(5,0,2) = &quot;-407&quot;
  289. &apos; CURRENCIES_BELGIAN
  290. LangIDValue(6,0,0) = &quot;fr&quot;
  291. LangIDValue(6,0,1) = &quot;BE&quot;
  292. LangIDValue(6,0,2) = &quot;-80C&quot;
  293. LangIDValue(6,1,0) = &quot;nl&quot;
  294. LangIDValue(6,1,1) = &quot;BE&quot;
  295. LangIDValue(6,1,2) = &quot;-813&quot;
  296. &apos; CURRENCIES_IRISH
  297. LangIDValue(7,0,0) = &quot;en&quot;
  298. LangIDValue(7,0,1) = &quot;IE&quot;
  299. LangIDValue(7,0,2) = &quot;-1809&quot;
  300. LangIDValue(7,1,0) = &quot;ga&quot;
  301. LangIDValue(7,1,1) = &quot;IE&quot;
  302. LangIDValue(7,1,2) = &quot;-83C&quot;
  303. &apos; CURRENCIES_LUXEMBOURG
  304. LangIDValue(8,0,0) = &quot;fr&quot;
  305. LangIDValue(8,0,1) = &quot;LU&quot;
  306. LangIDValue(8,0,2) = &quot;-140C&quot;
  307. LangIDValue(8,1,0) = &quot;de&quot;
  308. LangIDValue(8,1,1) = &quot;LU&quot;
  309. LangIDValue(8,1,2) = &quot;-1007&quot;
  310. &apos; CURRENCIES_AUSTRIAN
  311. LangIDValue(9,0,0) = &quot;de&quot;
  312. LangIDValue(9,0,1) = &quot;AT&quot;
  313. LangIDValue(9,0,2) = &quot;-C07&quot;
  314. &apos; CURRENCIES_FINNISH
  315. LangIDValue(10,0,0) = &quot;fi&quot;
  316. LangIDValue(10,0,1) = &quot;FI&quot;
  317. LangIDValue(10,0,2) = &quot;-40B&quot;
  318. LangIDValue(10,1,0) = &quot;sv&quot;
  319. LangIDValue(10,1,1) = &quot;FI&quot;
  320. LangIDValue(10,1,2) = &quot;-81D&quot;
  321. &apos; CURRENCIES_GREEK
  322. LangIDValue(11,0,0) = &quot;el&quot;
  323. LangIDValue(11,0,1) = &quot;GR&quot;
  324. LangIDValue(11,0,2) = &quot;-408&quot;
  325. &apos; CURRENCIES_SLOVENIAN
  326. LangIDValue(12,0,0) = &quot;sl&quot;
  327. LangIDValue(12,0,1) = &quot;SI&quot;
  328. LangIDValue(12,0,2) = &quot;-424&quot;
  329. &apos; CURRENCIES_CYPRIOT
  330. LangIDValue(13,0,0) = &quot;el&quot;
  331. LangIDValue(13,0,1) = &quot;CY&quot;
  332. LangIDValue(13,0,2) = &quot;-408&quot;
  333. &apos; CURRENCIES_MALTESE
  334. LangIDValue(14,0,0) = &quot;mt&quot;
  335. LangIDValue(14,0,1) = &quot;MT&quot;
  336. LangIDValue(14,0,2) = &quot;-43A&quot;
  337. &apos; CURRENCIES_SLOVAK
  338. LangIDValue(15,0,0) = &quot;sk&quot;
  339. LangIDValue(15,0,1) = &quot;SK&quot;
  340. LangIDValue(15,0,2) = &quot;-41B&quot;
  341. End Sub
  342. Sub InitializeCurrencies()
  343. Dim i as Integer
  344. GoOn = True
  345. CurrValue(0,0) = sCurrPORTUGUESE
  346. &apos; real conversion rate
  347. CurrValue(0,1) = 200.482
  348. &apos; rounded conversion rate
  349. CurrValue(0,2) = 200
  350. CurrValue(0,3) = &quot;Esc.&quot;
  351. CurrValue(0,4) = &quot;Esc.&quot;
  352. CurrValue(0,5) = &quot;PTE&quot;
  353. CurrValue(1,0) = sCurrDUTCH
  354. &apos; real conversion rate
  355. CurrValue(1,1) = 2.20371
  356. &apos; rounded conversion rate
  357. CurrValue(1,2) = 2
  358. CurrValue(1,3) = &quot;F&quot;
  359. CurrValue(1,4) = &quot;fl&quot;
  360. CurrValue(1,5) = &quot;NLG&quot;
  361. CurrValue(2,0) = sCurrFRENCH
  362. &apos; real conversion rate
  363. CurrValue(2,1) = 6.55957
  364. &apos; rounded conversion rate
  365. CurrValue(2,2) = 7
  366. CurrValue(2,3) = &quot;F&quot;
  367. CurrValue(2,4) = &quot;F&quot;
  368. CurrValue(2,5) = &quot;FRF&quot;
  369. CurrValue(3,0) = sCurrSPANISH
  370. &apos; real conversion rate
  371. CurrValue(3,1) = 166.386
  372. &apos; rounded conversion rate
  373. CurrValue(3,2) = 170
  374. CurrValue(3,3) = &quot;Pts&quot;
  375. CurrValue(3,4) = &quot;Pts&quot;
  376. CurrValue(3,5) = &quot;ESP&quot;
  377. CurrValue(4,0) = sCurrITALIAN
  378. &apos; real conversion rate
  379. CurrValue(4,1) = 1936.27
  380. &apos; rounded conversion rate
  381. CurrValue(4,2) = 2000
  382. CurrValue(4,3) = &quot;L.&quot;
  383. CurrValue(4,4) = &quot;L.&quot;
  384. CurrValue(4,5) = &quot;ITL&quot;
  385. CurrValue(5,0) = sCurrGERMAN
  386. &apos; real conversion rate
  387. CurrValue(5,1) = 1.95583
  388. &apos; rounded conversion rate
  389. CurrValue(5,2) = 2
  390. CurrValue(5,3) = &quot;DM&quot;
  391. CurrValue(5,4) = &quot;DM&quot;
  392. CurrValue(5,5) = &quot;DEM&quot;
  393. CurrValue(6,0) = sCurrBELGIAN
  394. &apos; real conversion rate
  395. CurrValue(6,1) = 40.3399
  396. &apos; rounded conversion rate
  397. CurrValue(6,2) = 40
  398. CurrValue(6,3) = &quot;FB&quot;
  399. CurrValue(6,4) = &quot;BF&quot;
  400. CurrValue(6,5) = &quot;BEF&quot;
  401. CurrValue(7,0) = sCurrIRISH
  402. &apos; real conversion rate
  403. CurrValue(7,1) = 0.787564
  404. &apos; rounded conversion rate
  405. CurrValue(7,2) = 0.8
  406. CurrValue(7,3) = &quot;IR£&quot;
  407. CurrValue(7,4) = &quot;£&quot;
  408. CurrValue(7,5) = &quot;IEP&quot;
  409. CurrValue(8,0) = sCurrLUXEMBOURG
  410. &apos; real conversion rate
  411. CurrValue(8,1) = 40.3399
  412. &apos; rounded conversion rate
  413. CurrValue(8,2) = 40
  414. CurrValue(8,3) = &quot;F&quot;
  415. CurrValue(8,4) = &quot;F&quot;
  416. CurrValue(8,5) = &quot;LUF&quot;
  417. CurrValue(9,0) = sCurrAUSTRIAN
  418. &apos; real conversion rate
  419. CurrValue(9,1) = 13.7603
  420. &apos; rounded conversion rate
  421. CurrValue(9,2) = 15
  422. CurrValue(9,3) = &quot;öS&quot;
  423. CurrValue(9,4) = &quot;S&quot;
  424. CurrValue(9,5) = &quot;ATS&quot;
  425. CurrValue(10,0) = sCurrFINNISH
  426. &apos; real conversion rate
  427. CurrValue(10,1) = 5.94573
  428. &apos; rounded conversion rate
  429. CurrValue(10,2) = 6
  430. CurrValue(10,3) = &quot;mk&quot;
  431. CurrValue(10,4) = &quot;mk&quot;
  432. CurrValue(10,5) = &quot;FIM&quot;
  433. CurrValue(11,0) = sCurrGREEK
  434. &apos; real conversion rate
  435. CurrValue(11,1) = 340.750
  436. &apos; rounded conversion rate
  437. CurrValue(11,2) = 400
  438. CurrValue(11,3) = chr(916) &amp; chr(961) &amp; chr(967)
  439. CurrValue(11,4) = chr(916) &amp; chr(961) &amp; chr(967)
  440. CurrValue(11,5) = &quot;GRD&quot;
  441. CurrValue(12,0) = sCurrSLOVENIAN
  442. &apos; real conversion rate
  443. CurrValue(12,1) = 239.64
  444. &apos; rounded conversion rate
  445. CurrValue(12,2) = 240
  446. CurrValue(12,3) = &quot;SIT&quot;
  447. CurrValue(12,4) = &quot;SIT&quot;
  448. CurrValue(12,5) = &quot;SIT&quot;
  449. CurrValue(13,0) = sCurrCYPRIOT
  450. &apos; real conversion rate
  451. CurrValue(13,1) = 0.585274
  452. &apos; rounded conversion rate
  453. CurrValue(13,2) = 0.6
  454. CurrValue(13,3) = &quot;£C&quot;
  455. CurrValue(13,4) = &quot;£&quot;
  456. CurrValue(13,5) = &quot;CYP&quot;
  457. CurrValue(14,0) = sCurrMALTESE
  458. &apos; real conversion rate
  459. CurrValue(14,1) = 0.429300
  460. &apos; rounded conversion rate
  461. CurrValue(14,2) = 0.4
  462. CurrValue(14,3) = chr(8356)
  463. CurrValue(14,4) = &quot;Lm&quot;
  464. CurrValue(14,5) = &quot;MTL&quot;
  465. CurrValue(15,0) = sCurrSLOVAK
  466. &apos; real conversion rate
  467. CurrValue(15,1) = 30.1260
  468. &apos; rounded conversion rate
  469. CurrValue(15,2) = 30
  470. CurrValue(15,3) = &quot;Sk&quot;
  471. CurrValue(15,4) = &quot;Sk&quot;
  472. CurrValue(15,5) = &quot;SKK&quot;
  473. i = -1
  474. CurrSymbolList(0) = &quot;&quot;
  475. CurrSymbolList(1) = &quot;&quot;
  476. InitializeCurrencyValues(CurrIndex)
  477. End Sub
  478. Sub InitializeControls()
  479. If CurrIndex = -1 Then
  480. If DialogModel.Step = 1 Then
  481. EnableStep1DialogControls(True, False, False)
  482. ElseIf DialogModel.Step = 2 Then
  483. EnableStep2DialogControls(True)
  484. End If
  485. End If
  486. End Sub
  487. Sub InitializeConverter(oLocale, iDialogPage as Integer)
  488. Dim Isthere as Boolean
  489. bCancelProtection = False
  490. bRangeListDefined = False
  491. PWIndex = -1
  492. If iDialogPage = 1 Then
  493. ToggleWindow(False)
  494. sDocType = Tools.GetDocumentType(ThisComponent)
  495. If sDocType = &quot;sCalc&quot; Then
  496. bDocHasProtectedSheets = CheckSheetProtection(oSheets)
  497. End If
  498. oStatusline = ThisComponent.GetCurrentController.GetFrame.CreateStatusIndicator()
  499. End If
  500. DialogConvert = LoadDialog(&quot;Euro&quot;, &quot;DlgConvert&quot;)
  501. DialogModel = DialogConvert.Model
  502. DialogPassword = LoadDialog(&quot;Euro&quot;, &quot;DlgPassword&quot;)
  503. PasswordModel = DialogPassword.Model
  504. DialogModel.Step = iDialogPage
  505. InitializeResources()
  506. InitializeLanguages()
  507. InitializeLocales(oLocale)
  508. InitializeCurrencies()
  509. InitializeControls()
  510. BitmapDir = GetOfficeSubPath(&quot;Template&quot;, &quot;../wizard/bitmap&quot;)
  511. If BitmapDir = &quot;&quot; Then
  512. Stop
  513. End If
  514. FillUpCurrencyListbox()
  515. DialogModel.imgPreview.ImageUrl = BitmapDir &amp; &quot;euro_&quot; &amp; DialogModel.Step &amp; &quot;.bmp&quot;
  516. DialogConvert.Title = sMsgDLGTITLE
  517. DialogModel.cmdGoOn.DefaultButton = True
  518. If iDialogPage = 1 Then
  519. ToggleWindow(True)
  520. End If
  521. End Sub
  522. Sub InitializeCurrencyValues(CurrIndex)
  523. If CurrIndex &lt;&gt; -1 Then
  524. CurrLanguage = CurrValue(CurrIndex,0)
  525. CurrFactor = CurrValue(CurrIndex,1)
  526. CurrSymbolList(0) = CurrValue(CurrIndex,3)
  527. CurrSymbolList(1) = CurrValue(CurrIndex,4)
  528. CurrSymbolList(2) = CurrValue(CurrIndex,5)
  529. End If
  530. End Sub
  531. Function InitializeLocales(oLocale) as Boolean
  532. Dim i as Integer, n as Integer, m as Integer
  533. Dim sLanguage as String, sCountry as String
  534. Dim bTakeThisLocale as Boolean
  535. sLanguage = oLocale.Language
  536. sCountry = oLocale.Country
  537. For n = 0 To SBCOUNTRYCOUNT - 1
  538. For m = 0 TO 1
  539. If DialogModel.Step = 2 Then
  540. bTakeThisLocale = LangIDValue(n,m,0) = sLanguage
  541. Else
  542. bTakeThisLocale = LangIDValue(n,m,0) = sLanguage
  543. End If
  544. If bTakeThisLocale Then
  545. CurrIndex = n
  546. For i = 0 To 2
  547. CurExtension(i) = LangIDValue(CurrIndex,i,2)
  548. Next i
  549. InitializeLocales = True
  550. Exit Function
  551. End If
  552. Next m
  553. Next n
  554. CurrIndex = -1
  555. InitializeLocales = False
  556. End Function
  557. </script:module>