Issue 48913 - Numbering Format doesn't work if it is done prior to entering value in table
Summary: Numbering Format doesn't work if it is done prior to entering value in table
Status: CONFIRMED
Alias: None
Product: Writer
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.0 Beta
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-05-09 05:02 UTC by aijo
Modified: 2013-08-07 14:38 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
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 aijo 2005-05-09 05:02:58 UTC 
In a table, we select a column and give it a numbering format eg #,###.00.

Procedure taken:
Highlight column by holding mouse left button and drag it down,
then right-click on it for context menu, 
then select "Number Format...". 
Select "Number" under "category", 
select "-1,234.12" under "Format", 
"Language" stays as "Default", 
"Decimal Places" at "2", 
"Leading Zeroes" at "0" and 
"Format Code" as "#,###.00".

Then we start to enter number value in each row of the column eg number 23 in
r1c2 and 43.2 in r2c2.
The values do not take the format that we have set, instead they take the
default text format which is to the left of the column and will take 23 and 43.2
where they should be aligned to the right and have format as 23.00 and 43.20.
This does not happen with the current stable version 1.1.4.
Comment 1 michael.ruess 2005-05-09 09:45:29 UTC 
MRU->OS: assigning a number format to a cell before entering a number, the
format will be ignored after number has been entered into cell.
Comment 2 Oliver Specht 2005-05-13 15:23:41 UTC 
os->mru: OOo 114 did it the same way except for the change in the default of the
"Number Recognition" setting, which is now off (which has been done according to
a spec, internal issue #114143#).
Comment 3 michael.ruess 2005-05-19 12:27:24 UTC 
Reopened to reassign.
Comment 4 michael.ruess 2005-05-19 12:29:00 UTC 
MRU->CJ:ok, the default changed (which I didn't recognized at first) and you are
member of the i-Team ;-)
In my opinion there's still something non-intuitive. When the number-recognition
is turned off and I assign certain number formats to cells (e.g. Currency) this
will be overwritten the by number format "text". IMO this is of course not, what
the user expects here...
Comment 5 christian.jansen 2005-05-19 14:12:28 UTC 
CJ: Set to Office Later
Comment 6 oreg 2007-09-14 21:24:33 UTC 
This is a duplicate of bug #54397 (or vice versa).