You can modify the culture string and create a custom culture using the CultureInfo class.
Add the custom culture by using the addCultureInfo method along with a culture name. Use the culture by setting the Culture method with the corresponding name.
<template>
<div class="sample-tutorial">
<gc-spread-sheets class="sample-spreadsheets" @workbookInitialized="initSpread">
<gc-worksheet>
</gc-worksheet>
</gc-spread-sheets>
<div class="options-container">
<div class="option-row">
<label for="cultures">Culture: </label>
</div>
<div class="option-row">
<select id="cultures" style="width: 100%" @change="selectCulture">
<option value="af">af: Afrikaans (Afrikaans)</option>
<option value="af-ZA">af-ZA: Afrikaans (South Africa) (Afrikaans (Suid Afrika))</option>
<option value="am">am: Amharic (አማርኛ)</option>
<option value="am-ET">am-ET: Amharic (Ethiopia) (አማርኛ (ኢትዮጵያ))</option>
<option value="ar">ar: Arabic (العربية)</option>
<option value="ar-AE">ar-AE: Arabic (U.A.E.) (العربية (الإمارات العربية المتحدة))</option>
<option value="ar-BH">ar-BH: Arabic (Bahrain) (العربية (البحرين))</option>
<option value="ar-DZ">ar-DZ: Arabic (Algeria) (العربية (الجزائر))</option>
<option value="ar-EG">ar-EG: Arabic (Egypt) (العربية (مصر))</option>
<option value="ar-IQ">ar-IQ: Arabic (Iraq) (العربية (العراق))</option>
<option value="ar-JO">ar-JO: Arabic (Jordan) (العربية (الأردن))</option>
<option value="ar-KW">ar-KW: Arabic (Kuwait) (العربية (الكويت))</option>
<option value="ar-LB">ar-LB: Arabic (Lebanon) (العربية (لبنان))</option>
<option value="ar-LY">ar-LY: Arabic (Libya) (العربية (ليبيا))</option>
<option value="ar-MA">ar-MA: Arabic (Morocco) (العربية (المملكة المغربية))</option>
<option value="ar-OM">ar-OM: Arabic (Oman) (العربية (عمان))</option>
<option value="ar-QA">ar-QA: Arabic (Qatar) (العربية (قطر))</option>
<option value="ar-SA">ar-SA: Arabic (Saudi Arabia) (العربية (المملكة العربية السعودية))</option>
<option value="ar-SY">ar-SY: Arabic (Syria) (العربية (سوريا))</option>
<option value="ar-TN">ar-TN: Arabic (Tunisia) (العربية (تونس))</option>
<option value="ar-YE">ar-YE: Arabic (Yemen) (العربية (اليمن))</option>
<option value="arn">arn: Mapudungun (Mapudungun)</option>
<option value="arn-CL">arn-CL: Mapudungun (Chile) (Mapudungun (Chile))</option>
<option value="as">as: Assamese (অসমীয়া)</option>
<option value="as-IN">as-IN: Assamese (India) (অসমীয়া (ভাৰত))</option>
<option value="az">az: Azeri (Azərbaycanılı)</option>
<option value="az-Cyrl">az-Cyrl: Azeri (Cyrillic) (Азәрбајҹан дили)</option>
<option value="az-Cyrl-AZ">az-Cyrl-AZ: Azeri (Cyrillic, Azerbaijan) (Азәрбајҹан (Азәрбајҹан))</option>
<option value="az-Latn">az-Latn: Azeri (Latin) (Azərbaycanılı)</option>
<option value="az-Latn-AZ">az-Latn-AZ: Azeri (Latin, Azerbaijan) (Azərbaycanılı (Azərbaycan))</option>
<option value="ba">ba: Bashkir (Башҡорт)</option>
<option value="ba-RU">ba-RU: Bashkir (Russia) (Башҡорт (Россия))</option>
<option value="be">be: Belarusian (Беларускі)</option>
<option value="be-BY">be-BY: Belarusian (Belarus) (Беларускі (Беларусь))</option>
<option value="bg">bg: Bulgarian (български)</option>
<option value="bg-BG">bg-BG: Bulgarian (Bulgaria) (български (България))</option>
<option value="bn">bn: Bengali (বাংলা)</option>
<option value="bn-BD">bn-BD: Bengali (Bangladesh) (বাংলা (বাংলাদেশ))</option>
<option value="bn-IN">bn-IN: Bengali (India) (বাংলা (ভারত))</option>
<option value="bo">bo: Tibetan (བོད་ཡིག)</option>
<option value="bo-CN">bo-CN: Tibetan (PRC) (བོད་ཡིག (ཀྲུང་ཧྭ་མི་དམངས་སྤྱི་མཐུན་རྒྱལ་ཁབ།))</option>
<option value="br">br: Breton (brezhoneg)</option>
<option value="br-FR">br-FR: Breton (France) (brezhoneg (Frañs))</option>
<option value="bs">bs: Bosnian (bosanski)</option>
<option value="bs-Cyrl">bs-Cyrl: Bosnian (Cyrillic) (босански)</option>
<option value="bs-Cyrl-BA">bs-Cyrl-BA: Bosnian (Cyrillic, Bosnia and Herzegovina) (босански (Босна и
Херцеговина))
</option>
<option value="bs-Latn">bs-Latn: Bosnian (Latin) (bosanski)</option>
<option value="bs-Latn-BA">bs-Latn-BA: Bosnian (Latin, Bosnia and Herzegovina) (bosanski (Bosna i
Hercegovina))
</option>
<option value="ca">ca: Catalan (català)</option>
<option value="ca-ES">ca-ES: Catalan (Catalan) (català (català))</option>
<option value="co">co: Corsican (Corsu)</option>
<option value="co-FR">co-FR: Corsican (France) (Corsu (France))</option>
<option value="cs">cs: Czech (čeština)</option>
<option value="cs-CZ">cs-CZ: Czech (Czech Republic) (čeština (Česká republika))</option>
<option value="cy">cy: Welsh (Cymraeg)</option>
<option value="cy-GB">cy-GB: Welsh (United Kingdom) (Cymraeg (y Deyrnas Unedig))</option>
<option value="da">da: Danish (dansk)</option>
<option value="da-DK">da-DK: Danish (Denmark) (dansk (Danmark))</option>
<option value="de">de: German (Deutsch)</option>
<option value="de-AT">de-AT: German (Austria) (Deutsch (Österreich))</option>
<option value="de-CH">de-CH: German (Switzerland) (Deutsch (Schweiz))</option>
<option value="de-DE">de-DE: German (Germany) (Deutsch (Deutschland))</option>
<option value="de-LI">de-LI: German (Liechtenstein) (Deutsch (Liechtenstein))</option>
<option value="de-LU">de-LU: German (Luxembourg) (Deutsch (Luxemburg))</option>
<option value="dsb">dsb: Lower Sorbian (dolnoserbšćina)</option>
<option value="dsb-DE">dsb-DE: Lower Sorbian (Germany) (dolnoserbšćina (Nimska))</option>
<option value="dv">dv: Divehi (ދިވެހިބަސް)</option>
<option value="dv-MV">dv-MV: Divehi (Maldives) (ދިވެހިބަސް (ދިވެހި ރާއްޖެ))</option>
<option value="el">el: Greek (Ελληνικά)</option>
<option value="el-GR">el-GR: Greek (Greece) (Ελληνικά (Ελλάδα))</option>
<option value="en">en: English (English)</option>
<option value="en">en: English (English)</option>
<option value="en-029">en-029: English (Caribbean) (English (Caribbean))</option>
<option value="en-AU">en-AU: English (Australia) (English (Australia))</option>
<option value="en-BZ">en-BZ: English (Belize) (English (Belize))</option>
<option value="en-CA">en-CA: English (Canada) (English (Canada))</option>
<option value="en-GB">en-GB: English (United Kingdom) (English (United Kingdom))</option>
<option value="en-IE">en-IE: English (Ireland) (English (Ireland))</option>
<option value="en-IN">en-IN: English (India) (English (India))</option>
<option value="en-JM">en-JM: English (Jamaica) (English (Jamaica))</option>
<option value="en-MY">en-MY: English (Malaysia) (English (Malaysia))</option>
<option value="en-NZ">en-NZ: English (New Zealand) (English (New Zealand))</option>
<option value="en-PH">en-PH: English (Republic of the Philippines) (English (Philippines))</option>
<option value="en-SG">en-SG: English (Singapore) (English (Singapore))</option>
<option value="en-TT">en-TT: English (Trinidad and Tobago) (English (Trinidad y Tobago))</option>
<option value="en-US">en-US: English (United States) (English)</option>
<option value="en-ZA">en-ZA: English (South Africa) (English (South Africa))</option>
<option value="en-ZW">en-ZW: English (Zimbabwe) (English (Zimbabwe))</option>
<option value="es">es: Spanish (español)</option>
<option value="es-AR">es-AR: Spanish (Argentina) (Español (Argentina))</option>
<option value="es-BO">es-BO: Spanish (Bolivia) (Español (Bolivia))</option>
<option value="es-CL">es-CL: Spanish (Chile) (Español (Chile))</option>
<option value="es-CO">es-CO: Spanish (Colombia) (Español (Colombia))</option>
<option value="es-CR">es-CR: Spanish (Costa Rica) (Español (Costa Rica))</option>
<option value="es-DO">es-DO: Spanish (Dominican Republic) (Español (República Dominicana))</option>
<option value="es-EC">es-EC: Spanish (Ecuador) (Español (Ecuador))</option>
<option value="es-ES">es-ES: Spanish (Spain, International Sort) (Español (España, alfabetización
internacional))
</option>
<option value="es-GT">es-GT: Spanish (Guatemala) (Español (Guatemala))</option>
<option value="es-HN">es-HN: Spanish (Honduras) (Español (Honduras))</option>
<option value="es-MX">es-MX: Spanish (Mexico) (Español (México))</option>
<option value="es-NI">es-NI: Spanish (Nicaragua) (Español (Nicaragua))</option>
<option value="es-PA">es-PA: Spanish (Panama) (Español (Panamá))</option>
<option value="es-PE">es-PE: Spanish (Peru) (Español (Perú))</option>
<option value="es-PR">es-PR: Spanish (Puerto Rico) (Español (Puerto Rico))</option>
<option value="es-PY">es-PY: Spanish (Paraguay) (Español (Paraguay))</option>
<option value="es-SV">es-SV: Spanish (El Salvador) (Español (El Salvador))</option>
<option value="es-US">es-US: Spanish (United States) (Español (Estados Unidos))</option>
<option value="es-UY">es-UY: Spanish (Uruguay) (Español (Uruguay))</option>
<option value="es-VE">es-VE: Spanish (Bolivarian Republic of Venezuela) (Español (Republica Bolivariana
de Venezuela))
</option>
<option value="et">et: Estonian (eesti)</option>
<option value="et-EE">et-EE: Estonian (Estonia) (eesti (Eesti))</option>
<option value="eu">eu: Basque (euskara)</option>
<option value="eu-ES">eu-ES: Basque (Basque) (euskara (euskara))</option>
<option value="fa">fa: Persian (فارسى)</option>
<option value="fa-IR">fa-IR: Persian (فارسى (ایران))</option>
<option value="fi">fi: Finnish (suomi)</option>
<option value="fi-FI">fi-FI: Finnish (Finland) (suomi (Suomi))</option>
<option value="fil">fil: Filipino (Filipino)</option>
<option value="fil-PH">fil-PH: Filipino (Philippines) (Filipino (Pilipinas))</option>
<option value="fo">fo: Faroese (føroyskt)</option>
<option value="fo-FO">fo-FO: Faroese (Faroe Islands) (føroyskt (Føroyar))</option>
<option value="fr">fr: French (français)</option>
<option value="fr-BE">fr-BE: French (Belgium) (français (Belgique))</option>
<option value="fr-CA">fr-CA: French (Canada) (français (Canada))</option>
<option value="fr-CH">fr-CH: French (Switzerland) (français (Suisse))</option>
<option value="fr-FR">fr-FR: French (France) (français (France))</option>
<option value="fr-LU">fr-LU: French (Luxembourg) (français (Luxembourg))</option>
<option value="fr-MC">fr-MC: French (Monaco) (français (Principauté de Monaco))</option>
<option value="fy">fy: Frisian (Frysk)</option>
<option value="fy-NL">fy-NL: Frisian (Netherlands) (Frysk (Nederlân))</option>
<option value="ga">ga: Irish (Gaeilge)</option>
<option value="ga-IE">ga-IE: Irish (Ireland) (Gaeilge (Éire))</option>
<option value="gd">gd: Scottish Gaelic (Gàidhlig)</option>
<option value="gd-GB">gd-GB: Scottish Gaelic (United Kingdom) (Gàidhlig (An Rìoghachd Aonaichte))
</option>
<option value="gl">gl: Galician (galego)</option>
<option value="gl-ES">gl-ES: Galician (Galician) (galego (galego))</option>
<option value="gsw">gsw: Alsatian (Elsässisch)</option>
<option value="gsw-FR">gsw-FR: Alsatian (France) (Elsässisch (Frànkrisch))</option>
<option value="gu">gu: Gujarati (ગુજરાતી)</option>
<option value="gu-IN">gu-IN: Gujarati (India) (ગુજરાતી (ભારત))</option>
<option value="ha">ha: Hausa (Hausa)</option>
<option value="ha-Latn">ha-Latn: Hausa (Latin) (Hausa)</option>
<option value="ha-Latn-NG">ha-Latn-NG: Hausa (Latin, Nigeria) (Hausa (Nigeria))</option>
<option value="he">he: Hebrew (עברית)</option>
<option value="he-IL">he-IL: Hebrew (Israel) (עברית (ישראל))</option>
<option value="hi">hi: Hindi (हिंदी)</option>
<option value="hi-IN">hi-IN: Hindi (India) (हिंदी (भारत))</option>
<option value="hr">hr: Croatian (hrvatski)</option>
<option value="hr-BA">hr-BA: Croatian (Latin, Bosnia and Herzegovina) (hrvatski (Bosna i Hercegovina))
</option>
<option value="hr-HR">hr-HR: Croatian (Croatia) (hrvatski (Hrvatska))</option>
<option value="hsb">hsb: Upper Sorbian (hornjoserbšćina)</option>
<option value="hsb-DE">hsb-DE: Upper Sorbian (Germany) (hornjoserbšćina (Němska))</option>
<option value="hu">hu: Hungarian (magyar)</option>
<option value="hu-HU">hu-HU: Hungarian (Hungary) (magyar (Magyarország))</option>
<option value="hy">hy: Armenian (Հայերեն)</option>
<option value="hy-AM">hy-AM: Armenian (Armenia) (Հայերեն (Հայաստան))</option>
<option value="id">id: Indonesian (Bahasa Indonesia)</option>
<option value="id-ID">id-ID: Indonesian (Indonesia) (Bahasa Indonesia (Indonesia))</option>
<option value="ig">ig: Igbo (Igbo)</option>
<option value="ig-NG">ig-NG: Igbo (Nigeria) (Igbo (Nigeria))</option>
<option value="ii">ii: Yi (ꆈꌠꁱꂷ)</option>
<option value="ii-CN">ii-CN: Yi (PRC) (ꆈꌠꁱꂷ (ꍏꉸꏓꂱꇭꉼꇩ))</option>
<option value="is">is: Icelandic (íslenska)</option>
<option value="is-IS">is-IS: Icelandic (Iceland) (íslenska (Ísland))</option>
<option value="it">it: Italian (italiano)</option>
<option value="it-CH">it-CH: Italian (Switzerland) (italiano (Svizzera))</option>
<option value="it-IT">it-IT: Italian (Italy) (italiano (Italia))</option>
<option value="iu">iu: Inuktitut (Inuktitut)</option>
<option value="iu-Cans">iu-Cans: Inuktitut (Syllabics) (ᐃᓄᒃᑎᑐᑦ)</option>
<option value="iu-Cans-CA">iu-Cans-CA: Inuktitut (Syllabics, Canada) (ᐃᓄᒃᑎᑐᑦ (ᑲᓇᑕᒥ))</option>
<option value="iu-Latn">iu-Latn: Inuktitut (Latin) (Inuktitut)</option>
<option value="iu-Latn-CA">iu-Latn-CA: Inuktitut (Latin, Canada) (Inuktitut (Kanatami))</option>
<option value="ja">ja: Japanese (日本語)</option>
<option value="ja-JP">ja-JP: Japanese (Japan) (日本語 (日本))</option>
<option value="ka">ka: Georgian (ქართული)</option>
<option value="ka-GE">ka-GE: Georgian (Georgia) (ქართული (საქართველო))</option>
<option value="kk">kk: Kazakh (Қазақ)</option>
<option value="kk-KZ">kk-KZ: Kazakh (Kazakhstan) (Қазақ (Қазақстан))</option>
<option value="kl">kl: Greenlandic (kalaallisut)</option>
<option value="kl-GL">kl-GL: Greenlandic (Greenland) (kalaallisut (Kalaallit Nunaat))</option>
<option value="km">km: Khmer (ខ្មែរ)</option>
<option value="km-KH">km-KH: Khmer (Cambodia) (ខ្មែរ (កម្ពុជា))</option>
<option value="kn">kn: Kannada (ಕನ್ನಡ)</option>
<option value="kn-IN">kn-IN: Kannada (India) (ಕನ್ನಡ (ಭಾರತ))</option>
<option value="ko">ko: Korean (한국어)</option>
<option value="ko-KR">ko-KR: Korean (Korea) (한국어 (대한민국))</option>
<option value="kok">kok: Konkani (कोंकणी)</option>
<option value="kok-IN">kok-IN: Konkani (India) (कोंकणी (भारत))</option>
<option value="ky">ky: Kyrgyz (Кыргыз)</option>
<option value="ky-KG">ky-KG: Kyrgyz (Kyrgyzstan) (Кыргыз (Кыргызстан))</option>
<option value="lb">lb: Luxembourgish (Lëtzebuergesch)</option>
<option value="lb-LU">lb-LU: Luxembourgish (Luxembourg) (Lëtzebuergesch (Luxembourg))</option>
<option value="lo">lo: Lao (ລາວ)</option>
<option value="lo-LA">lo-LA: Lao (Lao P.D.R.) (ລາວ (ສ.ປ.ປ. ລາວ))</option>
<option value="lt">lt: Lithuanian (lietuvių)</option>
<option value="lt-LT">lt-LT: Lithuanian (Lithuania) (lietuvių (Lietuva))</option>
<option value="lv">lv: Latvian (latviešu)</option>
<option value="lv-LV">lv-LV: Latvian (Latvia) (latviešu (Latvija))</option>
<option value="mi">mi: Maori (Reo Māori)</option>
<option value="mi-NZ">mi-NZ: Maori (New Zealand) (Reo Māori (Aotearoa))</option>
<option value="mk">mk: Macedonian (FYROM) (македонски јазик)</option>
<option value="mk-MK">mk-MK: Macedonian (Former Yugoslav Republic of Macedonia) (македонски јазик
(Македонија))
</option>
<option value="ml">ml: Malayalam (മലയാളം)</option>
<option value="ml-IN">ml-IN: Malayalam (India) (മലയാളം (ഭാരതം))</option>
<option value="mn">mn: Mongolian (Монгол хэл)</option>
<option value="mn-Cyrl">mn-Cyrl: Mongolian (Cyrillic) (Монгол хэл)</option>
<option value="mn-MN">mn-MN: Mongolian (Cyrillic, Mongolia) (Монгол хэл (Монгол улс))</option>
<option value="mn-Mong">mn-Mong: Mongolian (Traditional Mongolian) (ᠮᠤᠨᠭᠭᠤᠯ ᠬᠡᠯᠡ)</option>
<option value="mn-Mong-CN">mn-Mong-CN: Mongolian (Traditional Mongolian, PRC) (ᠮᠤᠨᠭᠭᠤᠯ ᠬᠡᠯᠡ (ᠪᠦᠭᠦᠳᠡ
ᠨᠠᠢᠷᠠᠮᠳᠠᠬᠤ ᠳᠤᠮᠳᠠᠳᠤ ᠠᠷᠠᠳ ᠣᠯᠣᠰ))
</option>
<option value="moh">moh: Mohawk (Kanien'kéha)</option>
<option value="moh-CA">moh-CA: Mohawk (Mohawk) (Kanien'kéha)</option>
<option value="mr">mr: Marathi (मराठी)</option>
<option value="mr-IN">mr-IN: Marathi (India) (मराठी (भारत))</option>
<option value="ms">ms: Malay (Bahasa Melayu)</option>
<option value="ms-BN">ms-BN: Malay (Brunei Darussalam) (Bahasa Melayu (Brunei Darussalam))</option>
<option value="ms-MY">ms-MY: Malay (Malaysia) (Bahasa Melayu (Malaysia))</option>
<option value="mt">mt: Maltese (Malti)</option>
<option value="mt-MT">mt-MT: Maltese (Malta) (Malti (Malta))</option>
<option value="nb">nb: Norwegian (Bokmål) (norsk (bokmål))</option>
<option value="nb-NO">nb-NO: Norwegian, Bokmål (Norway) (norsk, bokmål (Norge))</option>
<option value="ne">ne: Nepali (नेपाली)</option>
<option value="ne-NP">ne-NP: Nepali (Nepal) (नेपाली (नेपाल))</option>
<option value="nl">nl: Dutch (Nederlands)</option>
<option value="nl-BE">nl-BE: Dutch (Belgium) (Nederlands (België))</option>
<option value="nl-NL">nl-NL: Dutch (Netherlands) (Nederlands (Nederland))</option>
<option value="nn">nn: Norwegian (Nynorsk) (norsk (nynorsk))</option>
<option value="nn-NO">nn-NO: Norwegian, Nynorsk (Norway) (norsk, nynorsk (Noreg))</option>
<option value="no">no: Norwegian (norsk)</option>
<option value="nso">nso: Sesotho sa Leboa (Sesotho sa Leboa)</option>
<option value="nso-ZA">nso-ZA: Sesotho sa Leboa (South Africa) (Sesotho sa Leboa (Afrika Borwa))
</option>
<option value="oc">oc: Occitan (Occitan)</option>
<option value="oc-FR">oc-FR: Occitan (France) (Occitan (França))</option>
<option value="or">or: Oriya (ଓଡ଼ିଆ)</option>
<option value="or-IN">or-IN: Oriya (India) (ଓଡ଼ିଆ (ଭାରତ))</option>
<option value="pa">pa: Punjabi (ਪੰਜਾਬੀ)</option>
<option value="pa-IN">pa-IN: Punjabi (India) (ਪੰਜਾਬੀ (ਭਾਰਤ))</option>
<option value="pl">pl: Polish (polski)</option>
<option value="pl-PL">pl-PL: Polish (Poland) (polski (Polska))</option>
<option value="prs">prs: Dari (درى)</option>
<option value="prs-AF">prs-AF: Dari (Afghanistan) (درى (افغانستان))</option>
<option value="ps">ps: Pashto (پښتو)</option>
<option value="ps-AF">ps-AF: Pashto (Afghanistan) (پښتو (افغانستان))</option>
<option value="pt">pt: Portuguese (Português)</option>
<option value="pt-BR">pt-BR: Portuguese (Brazil) (Português (Brasil))</option>
<option value="pt-PT">pt-PT: Portuguese (Portugal) (português (Portugal))</option>
<option value="qut">qut: K'iche (K'iche)</option>
<option value="qut-GT">qut-GT: K'iche (Guatemala) (K'iche (Guatemala))</option>
<option value="quz">quz: Quechua (runasimi)</option>
<option value="quz-BO">quz-BO: Quechua (Bolivia) (runasimi (Qullasuyu))</option>
<option value="quz-EC">quz-EC: Quechua (Ecuador) (runasimi (Ecuador))</option>
<option value="quz-PE">quz-PE: Quechua (Peru) (runasimi (Piruw))</option>
<option value="rm">rm: Romansh (Rumantsch)</option>
<option value="rm-CH">rm-CH: Romansh (Switzerland) (Rumantsch (Svizra))</option>
<option value="ro">ro: Romanian (română)</option>
<option value="ro-RO">ro-RO: Romanian (Romania) (română (România))</option>
<option value="ru">ru: Russian (русский)</option>
<option value="ru-RU">ru-RU: Russian (Russia) (русский (Россия))</option>
<option value="rw">rw: Kinyarwanda (Kinyarwanda)</option>
<option value="rw-RW">rw-RW: Kinyarwanda (Rwanda) (Kinyarwanda (Rwanda))</option>
<option value="sa">sa: Sanskrit (संस्कृत)</option>
<option value="sa-IN">sa-IN: Sanskrit (India) (संस्कृत (भारतम्))</option>
<option value="sah">sah: Yakut (саха)</option>
<option value="sah-RU">sah-RU: Yakut (Russia) (саха (Россия))</option>
<option value="se">se: Sami (Northern) (davvisámegiella)</option>
<option value="se-FI">se-FI: Sami, Northern (Finland) (davvisámegiella (Suopma))</option>
<option value="se-NO">se-NO: Sami, Northern (Norway) (davvisámegiella (Norga))</option>
<option value="se-SE">se-SE: Sami, Northern (Sweden) (davvisámegiella (Ruoŧŧa))</option>
<option value="si">si: Sinhala (සිංහල)</option>
<option value="si-LK">si-LK: Sinhala (Sri Lanka) (සිංහල (ශ්රී ලංකා))</option>
<option value="sk">sk: Slovak (slovenčina)</option>
<option value="sk-SK">sk-SK: Slovak (Slovakia) (slovenčina (Slovenská republika))</option>
<option value="sl">sl: Slovenian (slovenski)</option>
<option value="sl-SI">sl-SI: Slovenian (Slovenia) (slovenski (Slovenija))</option>
<option value="sma">sma: Sami (Southern) (åarjelsaemiengiele)</option>
<option value="sma-NO">sma-NO: Sami, Southern (Norway) (åarjelsaemiengiele (Nöörje))</option>
<option value="sma-SE">sma-SE: Sami, Southern (Sweden) (åarjelsaemiengiele (Sveerje))</option>
<option value="smj">smj: Sami (Lule) (julevusámegiella)</option>
<option value="smj-NO">smj-NO: Sami, Lule (Norway) (julevusámegiella (Vuodna))</option>
<option value="smj-SE">smj-SE: Sami, Lule (Sweden) (julevusámegiella (Svierik))</option>
<option value="smn">smn: Sami (Inari) (sämikielâ)</option>
<option value="smn-FI">smn-FI: Sami, Inari (Finland) (sämikielâ (Suomâ))</option>
<option value="sms">sms: Sami (Skolt) (sääm´ǩiõll)</option>
<option value="sms-FI">sms-FI: Sami, Skolt (Finland) (sääm´ǩiõll (Lää´ddjânnam))</option>
<option value="sq">sq: Albanian (shqipe)</option>
<option value="sq-AL">sq-AL: Albanian (Albania) (shqipe (Shqipëria))</option>
<option value="sr">sr: Serbian (srpski)</option>
<option value="sr-Cyrl">sr-Cyrl: Serbian (Cyrillic) (српски)</option>
<option value="sr-Cyrl-BA">sr-Cyrl-BA: Serbian (Cyrillic, Bosnia and Herzegovina) (српски (Босна и
Херцеговина))
</option>
<option value="sr-Cyrl-CS">sr-Cyrl-CS: Serbian (Cyrillic, Serbia and Montenegro (Former)) (српски
(Србија и Црна Гора (Претходно)))
</option>
<option value="sr-Cyrl-ME">sr-Cyrl-ME: Serbian (Cyrillic, Montenegro) (српски (Црна Гора))</option>
<option value="sr-Cyrl-RS">sr-Cyrl-RS: Serbian (Cyrillic, Serbia) (српски (Србија))</option>
<option value="sr-Latn">sr-Latn: Serbian (Latin) (srpski)</option>
<option value="sr-Latn-BA">sr-Latn-BA: Serbian (Latin, Bosnia and Herzegovina) (srpski (Bosna i
Hercegovina))
</option>
<option value="sr-Latn-CS">sr-Latn-CS: Serbian (Latin, Serbia and Montenegro (Former)) (srpski (Srbija i
Crna Gora (Prethodno)))
</option>
<option value="sr-Latn-ME">sr-Latn-ME: Serbian (Latin, Montenegro) (srpski (Crna Gora))</option>
<option value="sr-Latn-RS">sr-Latn-RS: Serbian (Latin, Serbia) (srpski (Srbija))</option>
<option value="sv">sv: Swedish (svenska)</option>
<option value="sv-FI">sv-FI: Swedish (Finland) (svenska (Finland))</option>
<option value="sv-SE">sv-SE: Swedish (Sweden) (svenska (Sverige))</option>
<option value="sw">sw: Kiswahili (Kiswahili)</option>
<option value="sw-KE">sw-KE: Kiswahili (Kenya) (Kiswahili (Kenya))</option>
<option value="syr">syr: Syriac (ܣܘܪܝܝܐ)</option>
<option value="syr-SY">syr-SY: Syriac (Syria) (ܣܘܪܝܝܐ (سوريا))</option>
<option value="ta">ta: Tamil (தமிழ்)</option>
<option value="ta-IN">ta-IN: Tamil (India) (தமிழ் (இந்தியா))</option>
<option value="te">te: Telugu (తెలుగు)</option>
<option value="te-IN">te-IN: Telugu (India) (తెలుగు (భారత దేశం))</option>
<option value="tg">tg: Tajik (Тоҷикӣ)</option>
<option value="tg-Cyrl">tg-Cyrl: Tajik (Cyrillic) (Тоҷикӣ)</option>
<option value="tg-Cyrl-TJ">tg-Cyrl-TJ: Tajik (Cyrillic, Tajikistan) (Тоҷикӣ (Тоҷикистон))</option>
<option value="th">th: Thai (ไทย)</option>
<option value="th-TH">th-TH: Thai (Thailand) (ไทย (ไทย))</option>
<option value="tk">tk: Turkmen (türkmençe)</option>
<option value="tk-TM">tk-TM: Turkmen (Turkmenistan) (türkmençe (Türkmenistan))</option>
<option value="tn">tn: Setswana (Setswana)</option>
<option value="tn-ZA">tn-ZA: Setswana (South Africa) (Setswana (Aforika Borwa))</option>
<option value="tr">tr: Turkish (Türkçe)</option>
<option value="tr-TR">tr-TR: Turkish (Turkey) (Türkçe (Türkiye))</option>
<option value="tt">tt: Tatar (Татар)</option>
<option value="tt-RU">tt-RU: Tatar (Russia) (Татар (Россия))</option>
<option value="tzm">tzm: Tamazight (Tamazight)</option>
<option value="tzm-Latn">tzm-Latn: Tamazight (Latin) (Tamazight)</option>
<option value="tzm-Latn-DZ">tzm-Latn-DZ: Tamazight (Latin, Algeria) (Tamazight (Djazaïr))</option>
<option value="ug">ug: Uyghur (ئۇيغۇرچە)</option>
<option value="ug-CN">ug-CN: Uyghur (PRC) (ئۇيغۇرچە (جۇڭخۇا خەلق جۇمھۇرىيىتى))</option>
<option value="uk">uk: Ukrainian (українська)</option>
<option value="uk-UA">uk-UA: Ukrainian (Ukraine) (українська (Україна))</option>
<option value="ur">ur: Urdu (اُردو)</option>
<option value="ur-PK">ur-PK: Urdu (Islamic Republic of Pakistan) (اُردو (پاکستان))</option>
<option value="uz">uz: Uzbek (U'zbek)</option>
<option value="uz-Cyrl">uz-Cyrl: Uzbek (Cyrillic) (Ўзбек)</option>
<option value="uz-Cyrl-UZ">uz-Cyrl-UZ: Uzbek (Cyrillic, Uzbekistan) (Ўзбек (Ўзбекистон))</option>
<option value="uz-Latn">uz-Latn: Uzbek (Latin) (U'zbek)</option>
<option value="uz-Latn-UZ">uz-Latn-UZ: Uzbek (Latin, Uzbekistan) (U'zbek (U'zbekiston Respublikasi))
</option>
<option value="vi">vi: Vietnamese (Tiếng Việt)</option>
<option value="vi-VN">vi-VN: Vietnamese (Vietnam) (Tiếng Việt (Việt Nam))</option>
<option value="wo">wo: Wolof (Wolof)</option>
<option value="wo-SN">wo-SN: Wolof (Senegal) (Wolof (Sénégal))</option>
<option value="xh">xh: isiXhosa (isiXhosa)</option>
<option value="xh-ZA">xh-ZA: isiXhosa (South Africa) (isiXhosa (uMzantsi Afrika))</option>
<option value="yo">yo: Yoruba (Yoruba)</option>
<option value="yo-NG">yo-NG: Yoruba (Nigeria) (Yoruba (Nigeria))</option>
<option value="zh">zh: Chinese (中文)</option>
<option value="zh-CHS">zh-CHS: Chinese (Simplified) Legacy (中文(简体) 旧版)</option>
<option value="zh-CHT">zh-CHT: Chinese (Traditional) Legacy (中文(繁體) 舊版)</option>
<option value="zh-CN">zh-CN: Chinese (Simplified, PRC) (中文(中华人民共和国))</option>
<option value="zh-HK">zh-HK: Chinese (Traditional, Hong Kong S.A.R.) (中文(香港特別行政區))</option>
<option value="zh-Hans">zh-Hans: Chinese (Simplified) (中文(简体))</option>
<option value="zh-Hant">zh-Hant: Chinese (Traditional) (中文(繁體))</option>
<option value="zh-MO">zh-MO: Chinese (Traditional, Macao S.A.R.) (中文(澳門特別行政區))</option>
<option value="zh-SG">zh-SG: Chinese (Simplified, Singapore) (中文(新加坡))</option>
<option value="zh-TW">zh-TW: Chinese (Traditional, Taiwan) (中文(台灣))</option>
<option value="zu">zu: isiZulu (isiZulu)</option>
<option value="zu-ZA">zu-ZA: isiZulu (South Africa) (isiZulu (iNingizimu Afrika))</option>
</select>
</div>
</div>
</div>
</template>
<script>
import Vue from "vue";
import "@grapecity/spread-sheets-vue";
import GC from "@grapecity/spread-sheets";
import "./styles.css";
let App = Vue.extend({
name: "app",
data: function () {
return {
spread: null
};
},
methods: {
initSpread: function (spread) {
this.spread = spread;
spread.suspendPaint();
this.initData(spread)
spread.resumePaint();
},
initData(spread) {
let symbolFormat = '¥#,##0.00';
let fullDateTimePattern = 'dddd, MMMM dd, yyyy h:mm:ss tt';
let shortDateTimePattern = 'dddd tt';
let sheet = spread.getActiveSheet();
sheet.options.allowCellOverflow = true;
let table = sheet.tables.add("Table1", 2, 2, 8, 4, GC.Spread.Sheets.Tables.TableThemes.medium9);
table.highlightFirstColumn(true);
sheet.setColumnWidth(0, 20);
sheet.setColumnWidth(1, 20);
sheet.setColumnWidth(2, 80);
sheet.setColumnWidth(3, 180);
sheet.setColumnWidth(4, 180);
sheet.setColumnWidth(5, 200);
//header
sheet.setValue(2, 2, "Names");
sheet.setValue(2, 3, "Sale");
sheet.setValue(2, 4, "Buy");
sheet.setValue(2, 5, "Total");
sheet.setValue(3, 2, "Cindy");
sheet.setValue(4, 2, "Wills");
sheet.setValue(5, 2, "Sara");
sheet.setValue(6, 2, "Faith");
sheet.setValue(7, 2, "Halley");
sheet.setValue(8, 2, "Ken");
sheet.setValue(9, 2, "Newell");
sheet.setValue(3, 3, 1089468.3);
sheet.setValue(4, 3, 1078758.3);
sheet.setValue(5, 3, 1094684.6);
sheet.setValue(6, 3, 1034683.2);
sheet.setValue(7, 3, 1013685.1);
sheet.setValue(8, 3, 1013468.8);
sheet.setValue(9, 3, 1034686.2);
sheet.getCell(3, 3).formatter(symbolFormat);
sheet.getCell(4, 3).formatter(symbolFormat);
sheet.getCell(5, 3).formatter(symbolFormat);
sheet.getCell(6, 3).formatter(symbolFormat);
sheet.getCell(7, 3).formatter(symbolFormat);
sheet.getCell(8, 3).formatter(symbolFormat);
sheet.getCell(9, 3).formatter(symbolFormat);
sheet.setValue(3, 4, 1094682.6);
sheet.setValue(4, 4, 1094683.9);
sheet.setValue(5, 4, 1016856.9);
sheet.setValue(6, 4, 1046858.4);
sheet.setValue(7, 4, 1034685.9);
sheet.setValue(8, 4, 1074851.5);
sheet.setValue(9, 4, 1034682.9);
sheet.getCell(3, 4).formatter(symbolFormat);
sheet.getCell(4, 4).formatter(symbolFormat);
sheet.getCell(5, 4).formatter(symbolFormat);
sheet.getCell(6, 4).formatter(symbolFormat);
sheet.getCell(7, 4).formatter(symbolFormat);
sheet.getCell(8, 4).formatter(symbolFormat);
sheet.getCell(9, 4).formatter(symbolFormat);
sheet.getCell(3, 5).formula("=D4+E4-100.1");
sheet.getCell(4, 5).formula("=D5+E5-100.1");
sheet.getCell(5, 5).formula("=D6+E6-100.1");
sheet.getCell(6, 5).formula("=D7+E7-100.1");
sheet.getCell(7, 5).formula("=D8+E8-100.1");
sheet.getCell(8, 5).formula("=D9+E9-100.1");
sheet.getCell(9, 5).formula("=D10+E10-100.1");
sheet.getCell(3, 5).formatter(symbolFormat);
sheet.getCell(4, 5).formatter(symbolFormat);
sheet.getCell(5, 5).formatter(symbolFormat);
sheet.getCell(6, 5).formatter(symbolFormat);
sheet.getCell(7, 5).formatter(symbolFormat);
sheet.getCell(8, 5).formatter(symbolFormat);
sheet.getCell(9, 5).formatter(symbolFormat);
let table2 = sheet.tables.add("Table2", 12, 2, 5, 4, GC.Spread.Sheets.Tables.TableThemes.medium9);
table2.highlightFirstColumn(true);
sheet.setValue(12, 2, "Name");
sheet.setValue(12, 3, "Birthday");
sheet.setValue(12, 5, "Date");
sheet.setValue(13, 2, "Cindy");
sheet.setValue(14, 2, "Sara");
sheet.setValue(15, 2, "Faith");
sheet.setValue(16, 2, "Nami");
sheet.addSpan(12, 3, 1, 2);
sheet.addSpan(13, 3, 1, 2);
sheet.addSpan(14, 3, 1, 2);
sheet.addSpan(15, 3, 1, 2);
sheet.addSpan(16, 3, 1, 2);
let mydate = new Date();
mydate.setFullYear(1984, 1, 21);
let date;
date = new Date("1984/01/21 15:32:26");
sheet.setValue(13, 3, date);
sheet.setValue(13, 5, date);
date = new Date("1991/08/17 21:36:52");
sheet.setValue(14, 3, date);
sheet.setValue(14, 5, date);
date = new Date("2008/08/08 08:08:08");
sheet.setValue(15, 3, date);
sheet.setValue(15, 5, date);
date = new Date("2014/01/01 0:00:00");
sheet.setValue(16, 3, date);
sheet.setValue(16, 5, date);
sheet.getCell(13, 3).formatter(fullDateTimePattern);
sheet.getCell(14, 3).formatter(fullDateTimePattern);
sheet.getCell(15, 3).formatter(fullDateTimePattern);
sheet.getCell(16, 3).formatter(fullDateTimePattern);
sheet.getCell(13, 5).formatter(shortDateTimePattern);
sheet.getCell(14, 5).formatter(shortDateTimePattern);
sheet.getCell(15, 5).formatter(shortDateTimePattern);
sheet.getCell(16, 5).formatter(shortDateTimePattern);
},
selectCulture(e) {
let cultureTextInfo = {
"af": ";",
"af-ZA": ";",
"am": ";",
"am-ET": ";",
"ar": ";",
"ar-AE": ";",
"ar-BH": ";",
"ar-DZ": ";",
"ar-EG": ";",
"ar-IQ": ";",
"ar-JO": ";",
"ar-KW": ";",
"ar-LB": ";",
"ar-LY": ";",
"ar-MA": ";",
"ar-OM": ";",
"ar-QA": ";",
"ar-SA": ";",
"ar-SY": ";",
"ar-TN": ";",
"ar-YE": ";",
"arn": ",",
"arn-CL": ",",
"as": ",",
"as-IN": ",",
"az": ";",
"az-Cyrl": ";",
"az-Cyrl-AZ": ";",
"az-Latn": ";",
"az-Latn-AZ": ";",
"ba": ";",
"ba-RU": ";",
"be": ";",
"be-BY": ";",
"bg": ";",
"bg-BG": ";",
"bn": ",",
"bn-BD": ",",
"bn-IN": ",",
"bo": ",",
"bo-CN": ",",
"br": ";",
"br-FR": ";",
"bs": ";",
"bs-Cyrl": ";",
"bs-Cyrl-BA": ";",
"bs-Latn": ";",
"bs-Latn-BA": ";",
"ca": ";",
"ca-ES": ";",
"co": ";",
"co-FR": ";",
"cs": ";",
"cs-CZ": ";",
"cy": ";",
"cy-GB": ";",
"da": ";",
"da-DK": ";",
"de": ";",
"de-AT": ";",
"de-CH": ";",
"de-DE": ";",
"de-LI": ";",
"de-LU": ";",
"dsb": ";",
"dsb-DE": ";",
"dv": "،",
"dv-MV": "،",
"el": ";",
"el-GR": ";",
"en": ",",
"en-029": ",",
"en-AU": ",",
"en-BZ": ",",
"en-CA": ",",
"en-GB": ",",
"en-IE": ",",
"en-IN": ",",
"en-JM": ",",
"en-MY": ",",
"en-NZ": ",",
"en-PH": ",",
"en-SG": ",",
"en-TT": ",",
"en-US": ",",
"en-ZA": ",",
"en-ZW": ",",
"es": ";",
"es-AR": ";",
"es-BO": ";",
"es-CL": ";",
"es-CO": ";",
"es-CR": ";",
"es-DO": ";",
"es-EC": ";",
"es-ES": ";",
"es-GT": ";",
"es-HN": ";",
"es-MX": ",",
"es-NI": ";",
"es-PA": ";",
"es-PE": ";",
"es-PR": ";",
"es-PY": ";",
"es-SV": ";",
"es-US": ",",
"es-UY": ";",
"es-VE": ";",
"et": ";",
"et-EE": ";",
"eu": ";",
"eu-ES": ";",
"fa": "؛",
"fa-IR": "؛",
"fi": ";",
"fi-FI": ";",
"fil": ";",
"fil-PH": ";",
"fo": ";",
"fo-FO": ";",
"fr": ";",
"fr-BE": ";",
"fr-CA": ";",
"fr-CH": ";",
"fr-FR": ";",
"fr-LU": ";",
"fr-MC": ";",
"fy": ";",
"fy-NL": ";",
"ga": ";",
"ga-IE": ";",
"gd": ";",
"gd-GB": ";",
"gl": ";",
"gl-ES": ";",
"gsw": ";",
"gsw-FR": ";",
"gu": ",",
"gu-IN": ",",
"ha": ";",
"ha-Latn": ";",
"ha-Latn-NG": ";",
"he": ",",
"he-IL": ",",
"hi": ",",
"hi-IN": ",",
"hr": ";",
"hr-BA": ";",
"hr-HR": ";",
"hsb": ";",
"hsb-DE": ";",
"hu": ";",
"hu-HU": ";",
"hy": ",",
"hy-AM": ",",
"id": ";",
"id-ID": ";",
"ig": ";",
"ig-NG": ";",
"ii": ";",
"ii-CN": ";",
"is": ";",
"is-IS": ";",
"it": ";",
"it-CH": ";",
"it-IT": ";",
"iu": ",",
"iu-Cans": ",",
"iu-Cans-CA": ",",
"iu-Latn": ",",
"iu-Latn-CA": ",",
"ja": ",",
"ja-JP": ",",
"ka": ";",
"ka-GE": ";",
"kk": ";",
"kk-KZ": ";",
"kl": ";",
"kl-GL": ";",
"km": ",",
"km-KH": ",",
"kn": ",",
"kn-IN": ",",
"ko": ",",
"ko-KR": ",",
"kok": ",",
"kok-IN": ",",
"ky": ";",
"ky-KG": ";",
"lb": ";",
"lb-LU": ";",
"lo": ";",
"lo-LA": ";",
"lt": ";",
"lt-LT": ";",
"lv": ";",
"lv-LV": ";",
"mi": ",",
"mi-NZ": ",",
"mk": ";",
"mk-MK": ";",
"ml": ",",
"ml-IN": ",",
"mn": ";",
"mn-Cyrl": ";",
"mn-MN": ";",
"mn-Mong": ",",
"mn-Mong-CN": ",",
"moh": ",",
"moh-CA": ",",
"mr": ",",
"mr-IN": ",",
"ms": ";",
"ms-BN": ";",
"ms-MY": ";",
"mt": ";",
"mt-MT": ";",
"nb": ";",
"nb-NO": ";",
"ne": ",",
"ne-NP": ",",
"nl": ";",
"nl-BE": ";",
"nl-NL": ";",
"nn": ";",
"nn-NO": ";",
"no": ";",
"nso": ";",
"nso-ZA": ";",
"oc": ";",
"oc-FR": ";",
"or": ",",
"or-IN": ",",
"pa": ",",
"pa-IN": ",",
"pl": ";",
"pl-PL": ";",
"prs": ";",
"prs-AF": ";",
"ps": ";",
"ps-AF": ";",
"pt": ";",
"pt-BR": ";",
"pt-PT": ";",
"qut": ",",
"qut-GT": ",",
"quz": ",",
"quz-BO": ",",
"quz-EC": ",",
"quz-PE": ",",
"rm": ";",
"rm-CH": ";",
"ro": ";",
"ro-RO": ";",
"ru": ";",
"ru-RU": ";",
"rw": ";",
"rw-RW": ";",
"sa": ",",
"sa-IN": ",",
"sah": ";",
"sah-RU": ";",
"se": ";",
"se-FI": ";",
"se-NO": ";",
"se-SE": ";",
"si": ";",
"si-LK": ";",
"sk": ";",
"sk-SK": ";",
"sl": ";",
"sl-SI": ";",
"sma": ";",
"sma-NO": ";",
"sma-SE": ";",
"smj": ";",
"smj-NO": ";",
"smj-SE": ";",
"smn": ";",
"smn-FI": ";",
"sms": ";",
"sms-FI": ";",
"sq": ";",
"sq-AL": ";",
"sr": ";",
"sr-Cyrl": ";",
"sr-Cyrl-BA": ";",
"sr-Cyrl-CS": ";",
"sr-Cyrl-ME": ";",
"sr-Cyrl-RS": ";",
"sr-Latn": ";",
"sr-Latn-BA": ";",
"sr-Latn-CS": ";",
"sr-Latn-ME": ";",
"sr-Latn-RS": ";",
"sv": ";",
"sv-FI": ";",
"sv-SE": ";",
"sw": ";",
"sw-KE": ";",
"syr": ",",
"syr-SY": ",",
"ta": ",",
"ta-IN": ",",
"te": ",",
"te-IN": ",",
"tg": ";",
"tg-Cyrl": ";",
"tg-Cyrl-TJ": ";",
"th": ",",
"th-TH": ",",
"tk": ";",
"tk-TM": ";",
"tn": ";",
"tn-ZA": ";",
"tr": ";",
"tr-TR": ";",
"tt": ";",
"tt-RU": ";",
"tzm": ";",
"tzm-Latn": ";",
"tzm-Latn-DZ": ";",
"ug": ",",
"ug-CN": ",",
"uk": ";",
"uk-UA": ";",
"ur": ";",
"ur-PK": ";",
"uz": ";",
"uz-Cyrl": ";",
"uz-Cyrl-UZ": ";",
"uz-Latn": ";",
"uz-Latn-UZ": ";",
"vi": ",",
"vi-VN": ",",
"wo": ";",
"wo-SN": ";",
"xh": ";",
"xh-ZA": ";",
"yo": ";",
"yo-NG": ";",
"zh": ",",
"zh-CHS": ",",
"zh-CHT": ",",
"zh-CN": ",",
"zh-HK": ",",
"zh-Hans": ",",
"zh-Hant": ",",
"zh-MO": ",",
"zh-SG": ",",
"zh-TW": ",",
"zu": ";",
"zu-ZA": ";"
};
let specialListSeparator = "!";
let spread = this.spread;
let sheet = spread.getActiveSheet();
spread.suspendPaint();
let cultureName = e.target.value;
Globalize.culture(cultureName);
let myCulture = new GC.Spread.Common.CultureInfo();
myCulture.name = function () {
return cultureName;
};
let selectedCulture = Globalize.culture(),
numberFormat = selectedCulture.numberFormat,
standardCalendar = selectedCulture.calendars.standard,
patterns = standardCalendar.patterns;
myCulture.NumberFormat.currencySymbol = numberFormat.currency.symbol;
myCulture.NumberFormat.numberDecimalSeparator = numberFormat["."];
myCulture.NumberFormat.numberGroupSeparator = numberFormat[","];
myCulture.NumberFormat.listSeparator = cultureTextInfo[cultureName] === myCulture.NumberFormat.numberDecimalSeparator ? specialListSeparator : cultureTextInfo[cultureName];
myCulture.NumberFormat.arrayListSeparator = myCulture.NumberFormat.listSeparator === myCulture.NumberFormat.arrayGroupSeparator ? '\\' : myCulture.NumberFormat.listSeparator;
myCulture.NumberFormat.isReadOnly = true;
if (standardCalendar.AM && standardCalendar.AM.length > 0) {
myCulture.DateTimeFormat.amDesignator = standardCalendar.AM[0];
}
if (standardCalendar.PM && standardCalendar.PM.length > 0) {
myCulture.DateTimeFormat.pmDesignator = standardCalendar.PM[0];
}
myCulture.DateTimeFormat.monthNames = standardCalendar.months.names;
myCulture.DateTimeFormat.abbreviatedMonthNames = standardCalendar.months.namesAbbr;
myCulture.DateTimeFormat.abbreviatedDayNames = standardCalendar.days.namesAbbr;
myCulture.DateTimeFormat.dayNames = standardCalendar.days.names;
if (standardCalendar.monthsGenitive) {
myCulture.DateTimeFormat.abbreviatedMonthGenitiveNames = standardCalendar.monthsGenitive.namesAbbr || [];
myCulture.DateTimeFormat.monthGenitiveNames = standardCalendar.monthsGenitive.names || [];
} else {
myCulture.DateTimeFormat.abbreviatedMonthGenitiveNames = standardCalendar.months.namesAbbr;
myCulture.DateTimeFormat.monthGenitiveNames = standardCalendar.months.names;
}
myCulture.DateTimeFormat.dateSeparator = standardCalendar["/"];
myCulture.DateTimeFormat.fullDateTimePattern = patterns.F;
myCulture.DateTimeFormat.longDatePattern = patterns.D;
myCulture.DateTimeFormat.longTimePattern = patterns.T;
myCulture.DateTimeFormat.monthDayPattern = patterns.M;
myCulture.DateTimeFormat.rFC1123Pattern = "ddd, dd MMM yyyy HH\':\'mm\':\'ss \'GMT\'";
myCulture.DateTimeFormat.shortDatePattern = patterns.d;
myCulture.DateTimeFormat.shortTimePattern = patterns.t;
myCulture.DateTimeFormat.sortableDateTimePattern = patterns.S;
myCulture.DateTimeFormat.universalSortableDateTimePattern = "yyyy\'-\'MM\'-\'dd HH\':\'mm\':\'ss\'Z\'";
myCulture.DateTimeFormat.yearMonthPattern = patterns.Y;
myCulture.DateTimeFormat.calendarIsReadOnly = true;
GC.Spread.Common.CultureManager.addCultureInfo(cultureName, myCulture);
GC.Spread.Common.CultureManager.culture(cultureName);
let symbolFormat = myCulture.NumberFormat.currencySymbol;
symbolFormat = '"' + symbolFormat + '"' + '#,##0.00';
for (let row = 3; row <= 9; row++) {
for (let col = 3; col <= 5; col++) {
sheet.getCell(row, col).formatter(symbolFormat);
}
}
spread.resumePaint();
}
}
});
new Vue({
render: h => h(App)
}).$mount("#app");
</script>
<!doctype html>
<html style="height:100%;font-size:14px;">
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<link rel="stylesheet" type="text/css" href="$DEMOROOT$/en/vue/node_modules/@grapecity/spread-sheets/styles/gc.spread.sheets.excel2013white.css">
<script src="$DEMOROOT$/spread/source/js/external/globalize.min.js" type="text/javascript"></script>
<script src="$DEMOROOT$/spread/source/js/external/globalize.cultures.js" type="text/javascript"></script>
<!-- SystemJS -->
<script src="$DEMOROOT$/en/vue/node_modules/systemjs/dist/system.src.js"></script>
<script src="systemjs.config.js"></script>
<script>
System.import('./src/app.vue');
System.import('$DEMOROOT$/en/lib/vue/license.js');
</script>
</head>
<body>
<div id="app"></div>
</body>
</html>
.sample-tutorial {
position: relative;
height: 100%;
overflow: hidden;
}
.sample-spreadsheets {
width: calc(100% - 280px);
height: 100%;
overflow: hidden;
float: left;
}
.options-container {
float: right;
width: 280px;
padding: 12px;
height: 100%;
box-sizing: border-box;
background: #fbfbfb;
overflow: auto;
}
.option-row {
font-size: 14px;
margin-top: 10px;
}
label {
display: block;
margin-bottom: 6px;
}
input {
padding: 4px 6px;
}
input[type=button] {
margin-top: 6px;
display: block;
}
body {
position: absolute;
top: 0;
bottom: 0;
left: 0;
right: 0;
}
(function (global) {
System.config({
transpiler: 'plugin-babel',
babelOptions: {
es2015: true
},
meta: {
'*.css': { loader: 'css' },
'*.vue': { loader: 'vue-loader' }
},
paths: {
// paths serve as alias
'npm:': 'node_modules/'
},
// map tells the System loader where to look for things
map: {
'@grapecity/spread-sheets': 'npm:@grapecity/spread-sheets/index.js',
'@grapecity/spread-sheets-vue': 'npm:@grapecity/spread-sheets-vue/index.js',
'@grapecity/jsob-test-dependency-package/react-components': 'npm:@grapecity/jsob-test-dependency-package/react-components/index.js',
'jszip': 'npm:jszip/dist/jszip.js',
'css': 'npm:systemjs-plugin-css/css.js',
'vue': 'npm:vue/dist/vue.min.js',
'vue-loader': 'npm:systemjs-vue-browser/index.js',
'plugin-babel': 'npm:systemjs-plugin-babel/plugin-babel.js',
'systemjs-babel-build':'npm:systemjs-plugin-babel/systemjs-babel-browser.js'
},
// packages tells the System loader how to load when no filename and/or no extension
packages: {
src: {
defaultExtension: 'js'
},
rxjs: {
defaultExtension: 'js'
},
"node_modules": {
defaultExtension: 'js'
}
}
});
})(this);