Issue 98018 - User defined cell format ",-"
Summary: User defined cell format ",-"
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.0
Hardware: All All
: P5 (lowest) Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-01-13 08:41 UTC by raal
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

test file. Cell A1 with user format. (6.97 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-01-13 08:42 UTC, raal
no flags Details
excel file with user defined format. (29.00 KB, application/
2009-01-13 08:43 UTC, raal
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description raal 2009-01-13 08:41:23 UTC
1) set cell format as user defined ,- 
2) write some number to this cell, eg. 2
3) click to other cell and go back to formatted cell

Actual results:
In cell you see only format string ",-", in input cell is number 2

Expected results:
In cell is "2,-"

Same behaviour is in import from excel file.
Thank you.
Comment 1 raal 2009-01-13 08:42:48 UTC
Created attachment 59342 [details]
test file. Cell A1 with user format.
Comment 2 raal 2009-01-13 08:43:47 UTC
Created attachment 59343 [details]
excel file with user defined format.
Comment 3 ooo 2009-01-14 19:23:13 UTC
In the format string  ,-  there is no digit placeholder (0 or #), therefor no
value is displayed. Assuming your locale's decimal separator is , comma, use the
format string  #,-  instead (to not display 0 values with digits, else use  0,-
 ). Excel seems to have some behavior to display a value left of a decimal
separator as soon as a decimal separator appears in the format string, even if
there is no digit placeholder. Could also be regarded as a bug of Excel ...
Comment 4 raal 2009-01-15 08:09:37 UTC
My decimal separator is "," (comma). As you write, this behaviour in excel
depends on locale settings. When I use format ".-" in excel, then excel display
only ".-" without number (same behaviour as OOo now).