Issue 99837 - Cell format: [DBNum?] don't work
Summary: Cell format: [DBNum?] don't work
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: DEV300m40
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: CJK, oooqa
Depends on:
Blocks: 84405
  Show dependency tree
 
Reported: 2009-03-04 02:46 UTC by redflagzhulihua
Modified: 2010-09-07 02:41 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description redflagzhulihua 2009-03-04 02:46:40 UTC 
1. Enter a decimal in a cell, and apply user-defined format to it. The possible
user-defined format including:

[DBNum1]

[DBNum2]

[DBNum3]

[DBNum4](Just for Korean) 

I can confirm [DBNum1] [DBNum2] and [DBNum3] don't work. I think maybe [DBNum4]
don't work for Korean either.
Comment 1 thackert 2010-09-02 18:04:19 UTC 
Hello redflagzhulihua, *,
I can confirm this issue with OOO330m6 under Debian SID/Experimental AMD64 ...
:( @redflagzhulihua: Could you please add information about the OS/architecture,
which you have used to find your issues, please? That prevents us other testers
for asking everytime ... ;)
HTH
Thomas.
Comment 2 redflagzhulihua 2010-09-03 02:38:10 UTC 
Hi Thomas,

We tested on Windows Xp and Linux(Redhat) with X86.
Comment 3 ooo 2010-09-06 16:16:36 UTC 
Can't confirm. With OOO330m6 and number format locale zh-CN (Chinese
simplified), formats and display strings for the value 1.23 are:
[DBNum1]General  => 一．二三
[DBNum2]General  => 壹点贰叁
[DBNum3]General  => １．２３

Note that entering only a modifier [DBNum1] as code doesn't display anything,
also the digits code is needed, for example at least [DBNum1]0 to display values
without decimals.

Further note that the preferred modifier notation is [NatNum#] that for some
locales provides more transliterations than available with [DBNum#], which
exists only for Excel interoperability.
Comment 4 redflagzhulihua 2010-09-07 02:40:16 UTC 
Hello er,

Thank you very much. You are right. The issue caused by the wrong use of the format.

I'll close this issue.

regards,
Lihua
Comment 5 redflagzhulihua 2010-09-07 02:41:11 UTC 
closing