Issue 118309 - Guatemala currency number format incorrect
Summary: Guatemala currency number format incorrect
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.4.1
Hardware: PC Linux, all
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needhelp
Depends on:
Blocks:
 
Reported: 2011-07-19 16:55 UTC by alv000h
Modified: 2013-12-02 20:52 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description alv000h 2011-07-19 16:55:44 UTC
Guatemala Quetzal Currency format in this version is[[$Q-100A]Q#.##0,00],
but it should be (for numbers and currency on Guatemalan locale) [[$Q-100A]#,###.00 ] like in the US one.

So, this issue involve exchange positions for period and colon.

This change should be affect to (mostly Central America Area, take with caution I am not expert in this topic, maybe a native could enlighten us):

Costa Rica, Guatemala, Honduras, El Salvador, México (maybe a new standard change this in the future, I just saw a ticket over here about it), Nicaragua, Panamá, Puerto Rico y Dominican Republic.

----
Source in spanish: http://es.wikipedia.org/wiki/Wikipedia_Discusi%C3%B3n:Manual_de_estilo/N%C3%BAmeros 

"A nivel mundial sólo el cono sur de América y la mayoría de los países de Europa usa el punto para los miles y la coma para los decimales, el resto usa el sistema inverso. En cuanto a los países de habla hispana, los que usan el punto para los miles, y la coma para los decimales son Argentina, Bolivia, Cuba, Chile, Colombia, Ecuador, Paraguay, Perú, Uruguay, Venezuela y España. Los que usan la coma para los miles y el punto para los decimales son: Costa Rica, Guatemala, Honduras, El Salvador, México, Nicaragua, Panamá, Puerto Rico y República Dominicana"

In English, list of countries and its number format
1.000,00 format:
Argentina, Bolivia, Cuba, Chile, Colombia, Ecuador, Paraguay, Perú, Uruguay, Venezuela and Spain.

1,000.00 format:
Costa Rica, Guatemala, Honduras, El Salvador, México, Nicaragua, Panamá, Puerto Rico and Dominican Republic.
Comment 1 Oliver-Rainer Wittmann 2012-06-13 12:27:36 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.