Bug 236529 - [oocalc] [bn-IN] date input in english automatically gets converted to bengali digits
[oocalc] [bn-IN] date input in english automatically gets converted to bengal...
Status: CLOSED RAWHIDE
Product: Fedora
Classification: Fedora
Component: openoffice.org (Show other bugs)
rawhide
All Linux
medium Severity medium
: ---
: ---
Assigned To: Caolan McNamara
: i18n
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2007-04-16 03:10 EDT by Runa Bhattacharjee
Modified: 2013-03-03 21:21 EST (History)
2 users (show)

See Also:
Fixed In Version: 2.2.0-14.8
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2007-05-13 11:57:59 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)
screenshot of oocalc bn_IN with date written in english converted to bengali due to the [NatNum1] specification (35.56 KB, image/png)
2007-04-16 03:10 EDT, Runa Bhattacharjee
no flags Details


External Trackers
Tracker ID Priority Status Summary Last Updated
OpenOffice.org 76424 None None None Never

  None (edit)
Description Runa Bhattacharjee 2007-04-16 03:10:30 EDT
Description of problem:

Date typed in english in the Bengali India locale gets converted to bengali
instead of remaining in english.


Version-Release number of selected component (if applicable):
openoffice.org-calc-2.0.4-5.4.17.1


How reproducible:




Steps to Reproduce:
1. start OpenOffice Calc in Bengali India locale: LANG=bn_IN.UTF-8 oocalc &
2. Check that the bn keyboard is *not* selected as the input method
2. type in a date in the format 12-04-2007  
3. press "Enter" and leave the cell
  
Actual results:

date typed in english automatically converts to bengali digits

Expected results:
date typed in english should remain in english

Additional info:

The digit conversion happens only for date formats. other numbers typed in
english remain in english.

date typed in bengali remains unchanged after leaving the cell.

This behaviour is due to the [NatNum1] specifications as described here:
http://qa.openoffice.org/issues/show_bug.cgi?id=47575

I am putting sayamindu dasgupta in the cc for this bug as he had modified the
bn_IN.xml locale file to include this feature.
Comment 1 Runa Bhattacharjee 2007-04-16 03:10:30 EDT
Created attachment 152669 [details]
screenshot of oocalc bn_IN with date written in english converted to bengali due to the [NatNum1] specification
Comment 2 Caolan McNamara 2007-04-16 03:42:14 EDT
The default date format is used to display automatically detected dates in calc,
it will not matter what language-specific digits they are entered with. If they
are entered as bengali or english they are both then displayed in the default
format. So if the default format is changed to not have [NatNum1] then they will
all be displayed in english digits. 

So "data typed in english should remain in english" and "data typed in bengali
remains unchanged" is the current situation, changing the default for bengali to
not have NatNum1 will result in "data typed in english remains unchanged" and
"data typed in bengali should remain in bengali". You *cannot* retain dates
typed in bengali digits in bengali format, and those typed in english in english
format. A decision needs to be taken as to what is the better default one to use. 

But it is the case that or_IN, hi_IN, ml_IN etc don't have a [NatNum1] as their
default date format. Perhaps there is sufficiently similar reasoning for the
decision for those languages that might influence the bn_IN/bn_BD .xmls
Comment 3 Jamil Ahmed 2007-04-18 00:58:01 EDT
I think we can remove the [NatNum1] tag from Bengali locale files. It seems
bn_BD.xml is using bn_IN.xml's <LC_FORMAT>, so the patch is needed for bn_IN.xml

Hope Sayamindu will submit a patch in upstream.
Comment 4 Runa Bhattacharjee 2007-04-18 09:03:00 EDT
Issue submitted upstream:

http://bn.openoffice.org/issues/show_bug.cgi?id=76424
Comment 5 Caolan McNamara 2007-05-03 15:30:45 EDT
semi-consensus is good enough for me, remove of NatNum1 checked into devel, will
be in >= openoffice_org-2.2.0-14.7

Note You need to log in before you can comment on or make changes to this bug.