Issue 29949 - Excel Import: Add support for default number formats
Summary: Excel Import: Add support for default number formats
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 680m40
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: ms_interoperability, rfe_eval_ok
Depends on:
Blocks:
 
Reported: 2004-06-07 20:01 UTC by daniel.rentz
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description daniel.rentz 2004-06-07 20:01:33 UTC
[Enhancement] Add Excel default number formats of all supported locales.
Comment 1 daniel.rentz 2004-06-07 20:06:56 UTC
Accepted
Comment 2 erwin.tenhumberg 2004-10-26 16:01:42 UTC
set keywords and reassigned issue according to RFE process
Comment 3 daniel.rentz 2007-03-16 10:47:00 UTC
started
Comment 4 daniel.rentz 2007-04-11 17:14:51 UTC
back to me
Comment 5 daniel.rentz 2007-04-11 17:15:29 UTC
fixed in SRC680/xmlfilter02.
Added support for nearly all locales.
Comment 6 daniel.rentz 2007-11-28 10:43:18 UTC
target
Comment 7 daniel.rentz 2008-04-04 11:36:52 UTC
to verify, do the following steps:

- shutdown soffice (incl. quickstarter) and Excel 2007
- change system locale to some major locales (*)
- start Calc and Excel 2007
- load http://sc.openoffice.org/testdocs/numberformat_import_oox7.xlsx into both
apps
- compare the number formats

I don't think that all locales need to be tested. The import filter supports 142
locales:
af-ZA, 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, be-BY, bg-BG, bn-IN, ca-ES, cs-CZ,
cy-GB, da-DK, de-AT, de-CH, de-DE, de-LI, de-LU, div-MV, el-GR, en-AU, en-BZ,
en-CA, en-CB, en-GB, en-IE, en-JM, en-NZ, en-PH, en-TT, en-US, en-ZA, en-ZW,
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-UY, es-VE, et-EE, fa-IR, fi-FI,
fo-FO, fr-BE, fr-CA, fr-CH, fr-FR, fr-LU, fr-MC, gl-ES, gu-IN, he-IL, hi-IN,
hr-BA, hr-HR, hu-HU, hy-AM, id-ID, is-IS, it-CH, it-IT, ja-JP, ka-GE, kk-KZ,
kn-IN, ko-KR, kok-IN, ky-KG, lt-LT, lv-LV, mi-NZ, ml-IN, mn-MN, mr-IN, ms-BN,
ms-MY, mt-MT, nb-NO, nl-BE, nl-NL, nn-NO, nso-ZA, pa-IN, pl-PL, pt-BR, pt-PT,
qu-BO, qu-EC, qu-PE, ro-RO, ru-RU, sa-IN, se-FI, se-NO, se-SE, sk-SK, sl-SI,
sv-FI, sv-SE, sw-TZ, syr-SY, syr-TR, ta-IN, te-IN, th-TH, tn-ZA, tr-TR, tt-RU,
uk-UA, ur-PK, vi-VN, xh-ZA, zh-CN, zh-HK, zh-MO, zh-SG, zh-TW, zu-ZA
Comment 8 daniel.rentz 2008-04-21 08:04:44 UTC
back to QA
Comment 9 oc 2008-09-23 09:59:50 UTC
closed because fix available in builds OOO300_m6 and DEV300_m31