Bug 49390

Summary: EDITING TABLE: Cell number format not applied for new number inputs
Product: LibreOffice Reporter: Dave Richards <drichard>
Component: WriterAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED INVALID    
Severity: major CC: LibreOffice
Priority: medium    
Version: 3.5.2 release   
Hardware: Other   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: screenshot of errant table

Description Dave Richards 2012-05-02 09:30:59 UTC 
This is very easy to replicate and is a serious regression from OpenOffice 3.3.  Create a 5x5 table and then highlight one whole column and select "Number Format" and "Currency" (available from the right mouse click). 

In OpenOffice 3.3 if you click into the first row of that column and type in "100" and then down arrow it converts it into $100.00.  All edits are handled in this same way.

In LibreOffice 3.5.2 if you type in "100" and hit down arrow it stays as "100".  

This created a lot of extra work for users, because they have to continually hand format text each time that it's changed.

The desired formatting is physically stored in the table cell, it's just not used when editing.

Only able to test on Linux.
Comment 1 Dave Richards 2012-05-02 09:33:07 UTC 
Created attachment 60908 [details]
screenshot of errant table
Comment 2 Rainer Bielefeld Retired 2012-05-02 22:57:33 UTC 
@reporter:
did you check whether Menu 'Tools -> Options -> LibO WRITER -> Table - Input in Tables - "Number Recognition" is active?
Comment 3 Dave Richards 2012-05-03 05:49:50 UTC 
@Ranier: You are awesome!  This feature must have been enabled in OpenOffice by default.  Thank you, it worked. Closing.