Created attachment 142140 [details] Locale Data for Iloko [ilo-PH] Locale data for Iloko [ilo-PH] attached (ilo_PH.xml).
Great, thanks! I just had to correct one thing, the currency replacement's LCID value 3409 is from en_PH, which needs to be 6A3 here (the new value added with https://cgit.freedesktop.org/libreoffice/core/diff/include/i18nlangtag/lang.h?id=ed9416446def1a9c9af3869c3113d041ad33884e ). That's some requirement (stemming from Excel) for currency format codes to include the LCID and if not changed generates two sets of otherwise identical currency formats that only differ in LCID. A detail you likely couldn't know. - <LC_FORMAT replaceFrom="[CURRENCY]" replaceTo="[$Php-3409]"> + <LC_FORMAT replaceFrom="[CURRENCY]" replaceTo="[$Php-6A3]">
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4478c334349d2a58ef767a4db4b7087cc9319e11 Resolves: tdf#117655 Add Iloko [ilo-PH] locale data It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Thanks for you all your help! How can I test this in the next nightly build?
In Calc, Ctrl+1 or menu Format -> Cells..., then tab page Numbers, the various number formats in different categories. Play with different dates and format codes DDD, DDDD, MMM and MMMM to see the day and month names, or QQ for quarter names. In Writer, generate an Index table (from headings or some such, I don't remember), which should sort in the order given by the character sequence given in the <IndexKey> element. If under Tools -> Options -> Language Settings -> Languages, the Locale is set to Iloko, then in Calc date input should be accepted according to the Date Acceptance Patterns, also some long dates with month names should be possible, and all default formatting should occur according to the ilo-PH locale data.
Comment on attachment 142140 [details] Locale Data for Iloko [ilo-PH] ><?xml version="1.0" encoding="UTF-8" ?> ><!DOCTYPE Locale SYSTEM 'locale.dtd'> ><!-- > * This file is part of the LibreOffice project. > * > * This Source Code Form is subject to the terms of the Mozilla Public > * License, v. 2.0. If a copy of the MPL was not distributed with this > * file, You can obtain one at http://mozilla.org/MPL/2.0/. > * > * This file incorporates work covered by the following license notice: > * > * Licensed to the Apache Software Foundation (ASF) under one or more > * contributor license agreements. See the NOTICE file distributed > * with this work for additional information regarding copyright > * ownership. The ASF licenses this file to you under the Apache > * License, Version 2.0 (the "License"); you may not use this file > * except in compliance with the License. You may obtain a copy of > * the License at http://www.apache.org/licenses/LICENSE-2.0 . > --> ><Locale versionDTD="2.0.3" allowUpdateFromCLDR="yes" version="1.2"> > <LC_INFO> > <Language> > <LangID>ilo</LangID> > <DefaultName>english</DefaultName> > </Language> > <Country> > <CountryID>PH</CountryID> > <DefaultName>Philippines</DefaultName> > </Country> > </LC_INFO> > <LC_CTYPE> > <Separators> > <DateSeparator>/</DateSeparator> > <ThousandSeparator>,</ThousandSeparator> > <DecimalSeparator>.</DecimalSeparator> > <TimeSeparator>:</TimeSeparator> > <Time100SecSeparator>.</Time100SecSeparator> > <ListSeparator>;</ListSeparator> > <LongDateDayOfWeekSeparator>, </LongDateDayOfWeekSeparator> > <LongDateDaySeparator> ti </LongDateDaySeparator> > <LongDateMonthSeparator> iti </LongDateMonthSeparator> > <LongDateYearSeparator> </LongDateYearSeparator> > </Separators> > <Markers> > <QuotationStart>â</QuotationStart> > <QuotationEnd>â</QuotationEnd> > <DoubleQuotationStart>â</DoubleQuotationStart> > <DoubleQuotationEnd>â</DoubleQuotationEnd> > </Markers> > <TimeAM>AM</TimeAM> > <TimePM>PM</TimePM> > <MeasurementSystem>metric</MeasurementSystem> > </LC_CTYPE> > <LC_FORMAT replaceFrom="[CURRENCY]" replaceTo="[$Php-3409]"> > <DateAcceptancePattern>M/D</DateAcceptancePattern> > <DateAcceptancePattern>M-D</DateAcceptancePattern> > <FormatElement msgid="FixedFormatskey1" default="true" type="medium" usage="FIXED_NUMBER" formatindex="0"> > <FormatCode>Kadaywan</FormatCode> > </FormatElement> > <FormatElement msgid="FixedFormatskey2" default="true" type="short" usage="FIXED_NUMBER" formatindex="1"> > <FormatCode>0</FormatCode> > </FormatElement> > <FormatElement msgid="FixedFormatskey3" default="false" type="medium" usage="FIXED_NUMBER" formatindex="2"> > <FormatCode>0.00</FormatCode> > </FormatElement> > <FormatElement msgid="FixedFormatskey4" default="false" type="short" usage="FIXED_NUMBER" formatindex="3"> > <FormatCode>#,##0</FormatCode> > </FormatElement> > <FormatElement msgid="FixedFormatskey5" default="false" type="medium" usage="FIXED_NUMBER" formatindex="4"> > <FormatCode>#,##0.00</FormatCode> > </FormatElement> > <FormatElement msgid="FixedFormatskey6" default="false" type="medium" usage="FIXED_NUMBER" formatindex="5"> > <FormatCode>#,###.00</FormatCode> > </FormatElement> > <FormatElement msgid="FixedFormatskey7" default="false" type="short" usage="FIXED_NUMBER" formatindex="80"> > <FormatCode>#,##0_);(#,##0)</FormatCode> > </FormatElement> > <FormatElement msgid="FixedFormatskey8" default="false" type="medium" usage="FIXED_NUMBER" formatindex="81"> > <FormatCode>#,##0.00_);(#,##0.00)</FormatCode> > </FormatElement> > <FormatElement msgid="ScientificFormatskey1" default="false" type="medium" usage="SCIENTIFIC_NUMBER" formatindex="6"> > <FormatCode>0.00E+000</FormatCode> > </FormatElement> > <FormatElement msgid="ScientificFormatskey2" default="true" type="medium" usage="SCIENTIFIC_NUMBER" formatindex="7"> > <FormatCode>0.00E+00</FormatCode> > </FormatElement> > <FormatElement msgid="ScientificFormatskey3" default="false" type="medium" usage="SCIENTIFIC_NUMBER" formatindex="78"> > <FormatCode>##0.00E+00</FormatCode> > </FormatElement> > <FormatElement msgid="PercentFormatskey1" default="true" type="short" usage="PERCENT_NUMBER" formatindex="8"> > <FormatCode>0%</FormatCode> > </FormatElement> > <FormatElement msgid="PercentFormatskey2" default="true" type="long" usage="PERCENT_NUMBER" formatindex="9"> > <FormatCode>0.00%</FormatCode> > </FormatElement> > <FormatElement msgid="CurrencyFormatskey1" default="true" type="short" usage="CURRENCY" formatindex="12"> > <FormatCode>[CURRENCY]#,##0;-[CURRENCY]#,##0</FormatCode> > </FormatElement> > <FormatElement msgid="CurrencyFormatskey2" default="false" type="medium" usage="CURRENCY" formatindex="13"> > <FormatCode>[CURRENCY]#,##0.00;-[CURRENCY]#,##0.00</FormatCode> > </FormatElement> > <FormatElement msgid="CurrencyFormatskey3" default="false" type="medium" usage="CURRENCY" formatindex="14"> > <FormatCode>[CURRENCY]#,##0;[RED]-[CURRENCY]#,##0</FormatCode> > </FormatElement> > <FormatElement msgid="CurrencyFormatskey4" default="true" type="medium" usage="CURRENCY" formatindex="15"> > <FormatCode>[CURRENCY]#,##0.00;[RED]-[CURRENCY]#,##0.00</FormatCode> > </FormatElement> > <FormatElement msgid="CurrencyFormatskey5" default="false" type="medium" usage="CURRENCY" formatindex="16"> > <FormatCode>#,##0.00 CCC</FormatCode> > </FormatElement> > <FormatElement msgid="CurrencyFormatskey6" default="false" type="medium" usage="CURRENCY" formatindex="17"> > <FormatCode>[CURRENCY]#,##0.--;[RED]-[CURRENCY]#,##0.--</FormatCode> > </FormatElement> > <FormatElement msgid="CurrencyFormatskey7" default="false" type="short" usage="CURRENCY" formatindex="82"> > <FormatCode>[CURRENCY]* #,##0;-[CURRENCY]* #,##0</FormatCode> > </FormatElement> > <FormatElement msgid="CurrencyFormatskey8" default="false" type="medium" usage="CURRENCY" formatindex="83"> > <FormatCode>[CURRENCY]* #,##0.00;-[CURRENCY]* #,##0.00</FormatCode> > </FormatElement> > <FormatElement msgid="DateFormatskey1" default="true" type="short" usage="DATE" formatindex="18"> > <FormatCode>M/D/YY</FormatCode> > </FormatElement> > <FormatElement msgid="DateFormatskey9" default="true" type="long" usage="DATE" formatindex="19"> > <FormatCode>NNNND "ti" MMMM "iti" YYYY</FormatCode> > </FormatElement> > <FormatElement msgid="DateFormatskey8" default="true" type="medium" usage="DATE" formatindex="20"> > <FormatCode>MM/DD/YY</FormatCode> > </FormatElement> > <FormatElement msgid="DateFormatskey7" default="false" type="medium" usage="DATE" formatindex="21"> > <FormatCode>MM/DD/YYYY</FormatCode> > </FormatElement> > <FormatElement msgid="DateFormatskey10" default="false" type="long" usage="DATE" formatindex="22"> > <FormatCode>D "ti" MMM "iti" YY</FormatCode> > </FormatElement> > <FormatElement msgid="DateFormatskey11" default="false" type="long" usage="DATE" formatindex="23"> > <FormatCode>D "ti" MMM, YYYY</FormatCode> > </FormatElement> > <FormatElement msgid="DateFormatskey16" default="false" type="long" usage="DATE" formatindex="24"> > <FormatCode>D. MMM. YYYY</FormatCode> > </FormatElement> > <FormatElement msgid="DateFormatskey12" default="false" type="long" usage="DATE" formatindex="25"> > <FormatCode>D "ti" MMMM "iti" YYYY</FormatCode> > </FormatElement> > <FormatElement msgid="DateFormatskey17" default="false" type="long" usage="DATE" formatindex="26"> > <FormatCode>D. MMMM YYYY</FormatCode> > </FormatElement> > <FormatElement msgid="DateFormatskey13" default="false" type="long" usage="DATE" formatindex="27"> > <FormatCode>NN, D "ti" MMM, YY</FormatCode> > </FormatElement> > <FormatElement msgid="DateFormatskey2" default="false" type="medium" usage="DATE" formatindex="28"> > <FormatCode>NN DD/MMM YY</FormatCode> > </FormatElement> > <FormatElement msgid="DateFormatskey14" default="false" type="long" usage="DATE" formatindex="29"> > <FormatCode>NN, D "ti" MMMM, YYYY</FormatCode> > </FormatElement> > <FormatElement msgid="DateFormatskey15" default="false" type="long" usage="DATE" formatindex="30"> > <FormatCode>NNNND "ti" MMMM, YYYY</FormatCode> > </FormatElement> > <FormatElement msgid="DateFormatskey18" default="false" type="short" usage="DATE" formatindex="31"> > <FormatCode>MM-DD</FormatCode> > </FormatElement> > <FormatElement msgid="DateFormatskey19" default="false" type="medium" usage="DATE" formatindex="32"> > <FormatCode>YY-MM-DD</FormatCode> > </FormatElement> > <FormatElement msgid="DateFormatskey20" default="false" type="medium" usage="DATE" formatindex="33"> > <FormatCode>YYYY-MM-DD</FormatCode> > <DefaultName>ISO 8601</DefaultName> > </FormatElement> > <FormatElement msgid="DateFormatskey3" default="false" type="medium" usage="DATE" formatindex="34"> > <FormatCode>MM/YY</FormatCode> > </FormatElement> > <FormatElement msgid="DateFormatskey4" default="false" type="medium" usage="DATE" formatindex="35"> > <FormatCode>MMM DD</FormatCode> > </FormatElement> > <FormatElement msgid="DateFormatskey5" default="false" type="medium" usage="DATE" formatindex="36"> > <FormatCode>MMMM</FormatCode> > </FormatElement> > <FormatElement msgid="DateFormatskey6" default="false" type="medium" usage="DATE" formatindex="37"> > <FormatCode>QQ YY</FormatCode> > </FormatElement> > <FormatElement msgid="DateFormatskey21" default="false" type="medium" usage="DATE" formatindex="38"> > <FormatCode>WW</FormatCode> > </FormatElement> > <FormatElement msgid="TimeFormatskey1" default="false" type="short" usage="TIME" formatindex="39"> > <FormatCode>HH:MM</FormatCode> > </FormatElement> > <FormatElement msgid="TimeFormatskey2" default="false" type="medium" usage="TIME" formatindex="40"> > <FormatCode>HH:MM:SS</FormatCode> > </FormatElement> > <FormatElement msgid="TimeFormatskey3" default="true" type="short" usage="TIME" formatindex="41"> > <FormatCode>HH:MM AM/PM</FormatCode> > </FormatElement> > <FormatElement msgid="TimeFormatskey4" default="true" type="medium" usage="TIME" formatindex="42"> > <FormatCode>HH:MM:SS AM/PM</FormatCode> > </FormatElement> > <FormatElement msgid="TimeFormatskey5" default="false" type="medium" usage="TIME" formatindex="43"> > <FormatCode>[HH]:MM:SS</FormatCode> > </FormatElement> > <FormatElement msgid="TimeFormatskey6" default="false" type="short" usage="TIME" formatindex="44"> > <FormatCode>MM:SS.00</FormatCode> > </FormatElement> > <FormatElement msgid="TimeFormatskey7" default="false" type="medium" usage="TIME" formatindex="45"> > <FormatCode>[HH]:MM:SS.00</FormatCode> > </FormatElement> > <FormatElement msgid="DateTimeFormatskey1" default="true" type="medium" usage="DATE_TIME" formatindex="46"> > <FormatCode>MM/DD/YY HH:MM AM/PM</FormatCode> > </FormatElement> > <FormatElement msgid="DateTimeFormatskey2" default="false" type="medium" usage="DATE_TIME" formatindex="47"> > <FormatCode>MM/DD/YYYY HH:MM:SS</FormatCode> > </FormatElement> > </LC_FORMAT> > <LC_COLLATION> > <Collator default="true" unoid="alphanumeric" /> > <CollationOptions> > <TransliterationModules>IGNORE_CASE</TransliterationModules> > </CollationOptions> > </LC_COLLATION> > <LC_SEARCH> > <SearchOptions> > <TransliterationModules>IGNORE_CASE</TransliterationModules> > </SearchOptions> > </LC_SEARCH> > <LC_INDEX> > <IndexKey phonetic="false" default="true" unoid="alphanumeric">A-N à {NG} O-Z</IndexKey> > <UnicodeScript>0</UnicodeScript> > <UnicodeScript>1</UnicodeScript> > <FollowPageWord>p.</FollowPageWord> > <FollowPageWord>pp.</FollowPageWord> > </LC_INDEX> > <LC_CALENDAR> > <Calendar unoid="gregorian" default="true"> > <DaysOfWeek> > <Day> > <DayID>sun</DayID> > <DefaultAbbrvName>Dom</DefaultAbbrvName> > <DefaultFullName>Dominggo</DefaultFullName> > </Day> > <Day> > <DayID>mon</DayID> > <DefaultAbbrvName>Mon</DefaultAbbrvName> > <DefaultFullName>Monday</DefaultFullName> > </Day> > <Day> > <DayID>tue</DayID> > <DefaultAbbrvName>Tues</DefaultAbbrvName> > <DefaultFullName>Tuesday</DefaultFullName> > </Day> > <Day> > <DayID>wed</DayID> > <DefaultAbbrvName>Wed</DefaultAbbrvName> > <DefaultFullName>Wednesday</DefaultFullName> > </Day> > <Day> > <DayID>thu</DayID> > <DefaultAbbrvName>Thur</DefaultAbbrvName> > <DefaultFullName>Thursday</DefaultFullName> > </Day> > <Day> > <DayID>fri</DayID> > <DefaultAbbrvName>Fri</DefaultAbbrvName> > <DefaultFullName>Friday</DefaultFullName> > </Day> > <Day> > <DayID>sat</DayID> > <DefaultAbbrvName>Sat</DefaultAbbrvName> > <DefaultFullName>Saturday</DefaultFullName> > </Day> > </DaysOfWeek> > <MonthsOfYear> > <Month> > <MonthID>jan</MonthID> > <DefaultAbbrvName>Jan</DefaultAbbrvName> > <DefaultFullName>January</DefaultFullName> > </Month> > <Month> > <MonthID>feb</MonthID> > <DefaultAbbrvName>Peb</DefaultAbbrvName> > <DefaultFullName>Pebrero</DefaultFullName> > </Month> > <Month> > <MonthID>mar</MonthID> > <DefaultAbbrvName>Mar</DefaultAbbrvName> > <DefaultFullName>Marso</DefaultFullName> > </Month> > <Month> > <MonthID>apr</MonthID> > <DefaultAbbrvName>Abr</DefaultAbbrvName> > <DefaultFullName>Abril</DefaultFullName> > </Month> > <Month> > <MonthID>may</MonthID> > <DefaultAbbrvName>May</DefaultAbbrvName> > <DefaultFullName>Mayo</DefaultFullName> > </Month> > <Month> > <MonthID>jun</MonthID> > <DefaultAbbrvName>Hun</DefaultAbbrvName> > <DefaultFullName>Hunio</DefaultFullName> > </Month> > <Month> > <MonthID>jul</MonthID> > <DefaultAbbrvName>Hul</DefaultAbbrvName> > <DefaultFullName>Hulio</DefaultFullName> > </Month> > <Month> > <MonthID>aug</MonthID> > <DefaultAbbrvName>Ago</DefaultAbbrvName> > <DefaultFullName>Agosto</DefaultFullName> > </Month> > <Month> > <MonthID>sep</MonthID> > <DefaultAbbrvName>Sept</DefaultAbbrvName> > <DefaultFullName>Septiembre</DefaultFullName> > </Month> > <Month> > <MonthID>oct</MonthID> > <DefaultAbbrvName>Okt</DefaultAbbrvName> > <DefaultFullName>Oktubre</DefaultFullName> > </Month> > <Month> > <MonthID>nov</MonthID> > <DefaultAbbrvName>Nob</DefaultAbbrvName> > <DefaultFullName>Nobiembre</DefaultFullName> > </Month> > <Month> > <MonthID>dec</MonthID> > <DefaultAbbrvName>Dis</DefaultAbbrvName> > <DefaultFullName>Disiembre</DefaultFullName> > </Month> > </MonthsOfYear> > <Eras> > <Era> > <EraID>bc</EraID> > <DefaultAbbrvName>BC</DefaultAbbrvName> > <DefaultFullName>BC</DefaultFullName> > </Era> > <Era> > <EraID>ad</EraID> > <DefaultAbbrvName>AD</DefaultAbbrvName> > <DefaultFullName>AD</DefaultFullName> > </Era> > </Eras> > <StartDayOfWeek> > <DayID>sun</DayID> > </StartDayOfWeek> > <MinimalDaysInFirstWeek>1</MinimalDaysInFirstWeek> > </Calendar> > </LC_CALENDAR> > <LC_CURRENCY> > <Currency default="true" usedInCompatibleFormatCodes="true"> > <CurrencyID>PHP</CurrencyID> > <CurrencySymbol>Php</CurrencySymbol> > <BankSymbol>PHP</BankSymbol> > <CurrencyName>Peso</CurrencyName> > <DecimalPlaces>2</DecimalPlaces> > </Currency> > </LC_CURRENCY> > <LC_TRANSLITERATION ref="en_US" /> > <LC_MISC> > <ReservedWords> > <trueWord>pudno</trueWord> > <falseWord>ubbaw</falseWord> > <quarter1Word>umuna a kakapat</quarter1Word> > <quarter2Word>maika-2 a kakapat</quarter2Word> > <quarter3Word>maika-3 a kakapat</quarter3Word> > <quarter4Word>maika-4 a kakapat</quarter4Word> > <aboveWord>iti ngato</aboveWord> > <belowWord>iti baba</belowWord> > <quarter1Abbreviation>Q1</quarter1Abbreviation> > <quarter2Abbreviation>Q2</quarter2Abbreviation> > <quarter3Abbreviation>Q3</quarter3Abbreviation> > <quarter4Abbreviation>Q4</quarter4Abbreviation> > </ReservedWords> > </LC_MISC> > <LC_NumberingLevel ref="en_US" /> > <LC_OutLineNumberingLevel ref="en_US" /> ></Locale>
Confusing comment.. ;-) Just the attached file unnecessarily copied as comment.