You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/01/17 12:41:33 UTC

[Bug 121638] New: number format - incorrect currency for Estonia.

https://issues.apache.org/ooo/show_bug.cgi?id=121638

            Bug ID: 121638
        Issue Type: DEFECT
           Summary: number format - incorrect currency for Estonia.
    Classification: Code
           Product: l10n
           Version: AOO 3.4.1
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: localedata
          Assignee: issues@openoffice.apache.org
          Reporter: qbicdesign@gmail.com
                CC: issues@openoffice.apache.org

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121638] Add EURO as default currency for Estonian-Estonian (et-EE)

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121638

Ariel Constenla-Haile <ar...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|CONFIRMED                   |ACCEPTED
           Assignee|issues@openoffice.apache.or |arielch@apache.org
                   |g                           |

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121638] number format - incorrect currency for Estonia.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121638

--- Comment #2 from qbicdesign <qb...@gmail.com> ---
I haven't tested yet if the same is true for the other OO.org apps, but I
assume so.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121638] number format - incorrect currency for Estonia.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121638

Ariel Constenla-Haile <ar...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Target Milestone|---                         |AOO 4.0
                 OS|Windows 7                   |All

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121638] Add EURO as default currency for Estonian-Estonian (et-EE)

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121638

--- Comment #5 from SVN Robot <sv...@dev.null.org> ---
"arielch" committed SVN revision 1437801 into trunk:
i121638 - Add EURO as default currency for et-EE

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 121638] number format - incorrect currency for Estonia.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121638

qbicdesign <qb...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |numbering
             Latest|---                         |AOO 3.4.0
    Confirmation on|                            |
           Hardware|All                         |PC
                 OS|All                         |Windows 7

--- Comment #1 from qbicdesign <qb...@gmail.com> ---
Estonia switched to Euro on 1st Jan 2011.
In OO.o 3.4.0 Writer, when choosing a number format for a table cell, Estonian
currency is presented in kr (Estonian Kroon). This must now be replaced by
Euro.

Current workaround is to select Finnish Euro which follows the same comma,
decimal and spacing rules as Estonian Euro.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121638] number format - incorrect currency for Estonia.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121638

Ariel Constenla-Haile <ar...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
                 CC|                            |arielch@apache.org
     Ever confirmed|0                           |1

--- Comment #3 from Ariel Constenla-Haile <ar...@apache.org> ---
(In reply to comment #1)
> Estonia switched to Euro on 1st Jan 2011.
> In OO.o 3.4.0 Writer, when choosing a number format for a table cell,
> Estonian currency is presented in kr (Estonian Kroon). This must now be
> replaced by Euro.

That locale setting is defined here: 
http://svn.apache.org/viewvc/openoffice/trunk/main/i18npool/source/localedata/data/et_EE.xml?revision=1413471&view=markup#l333

333     <LC_CURRENCY>
334     <Currency default="true" usedInCompatibleFormatCodes="true">
335     <CurrencyID>EEK</CurrencyID>
336     <CurrencySymbol>kr</CurrencySymbol>
337     <BankSymbol>EEK</BankSymbol>
338     <CurrencyName>kroon</CurrencyName>
339     <DecimalPlaces>2</DecimalPlaces>
340     </Currency>
341     </LC_CURRENCY>


> Current workaround is to select Finnish Euro 

fi-FI is defined here:
http://svn.apache.org/viewvc/openoffice/trunk/main/i18npool/source/localedata/data/fi_FI.xml?revision=1413471&view=markup#l327

AS you see, the proper way is not to replace the old, but to add a new one, set
it as the default, and keep the old as non-default:

327     <LC_CURRENCY>
328     <Currency default="true" usedInCompatibleFormatCodes="false">
329     <CurrencyID>EUR</CurrencyID>
330     <CurrencySymbol>€</CurrencySymbol>
331     <BankSymbol>EUR</BankSymbol>
332     <CurrencyName>euro</CurrencyName>
333     <DecimalPlaces>2</DecimalPlaces>
334     </Currency>
335     <Currency default="false" usedInCompatibleFormatCodes="true">
336     <CurrencyID>FIM</CurrencyID>
337     <CurrencySymbol>mk</CurrencySymbol>
338     <BankSymbol>FIM</BankSymbol>
339     <CurrencyName>Suomen markka</CurrencyName>
340     <DecimalPlaces>2</DecimalPlaces>
341     </Currency>
342     </LC_CURRENCY>

> which follows the same comma, decimal and spacing rules as Estonian Euro.

As far as I know, the locale currency setting only defined the the decimal
places (as you can see in the definition above), the comma is taking from other
locale setting (LC_CTYPE/Separators).


Can you confirm that all the settings in this currency are fine for Estonian?

<CurrencyID>EUR</CurrencyID>
<CurrencySymbol>€</CurrencySymbol>
<BankSymbol>EUR</BankSymbol>
<CurrencyName>euro</CurrencyName>
<DecimalPlaces>2</DecimalPlaces>

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121638] Add EURO as default currency for Estonian-Estonian (et-EE)

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121638

Ariel Constenla-Haile <ar...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|ACCEPTED                    |RESOLVED
         Resolution|---                         |FIXED

--- Comment #6 from Ariel Constenla-Haile <ar...@apache.org> ---
Fixed on trunk

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 121638] Add EURO as default currency for Estonian-Estonian (et-EE)

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121638

Ariel Constenla-Haile <ar...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|number format - incorrect   |Add EURO as default
                   |currency for Estonia.       |currency for
                   |                            |Estonian-Estonian (et-EE)

--- Comment #4 from Ariel Constenla-Haile <ar...@apache.org> ---
Adapting bug title.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121638] Add EURO as default currency for Estonian-Estonian (et-EE)

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121638

Yurggent Alfredo Chable Torrez <yu...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|numbering                   |
             Status|RESOLVED                    |CLOSED
                 CC|                            |yurggent1.791@gmail.com
             Latest|AOO 3.4.0                   |AOO 3.4.1
    Confirmation on|                            |

--- Comment #7 from Yurggent Alfredo Chable Torrez <yu...@gmail.com> ---
This has been resolved, now has 2 formats to choose. I tested in AOO 3.4.1 and
4.0
Regars

Yurggent Alfredo

-- 
You are receiving this mail because:
You are on the CC list for the bug.