Bug 90272 - Formatting error displaying number 5 in standard numeric format box
Summary: Formatting error displaying number 5 in standard numeric format box
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-03-26 22:19 UTC by roger.eaton
Modified: 2015-04-01 18:19 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Small Spreadshheet (17.66 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-03-26 22:30 UTC, roger.eaton 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description roger.eaton 2015-03-26 22:19:14 UTC 

    


    


      



        
          Comment 1
        

        
          roger.eaton

        

        
        

        
          2015-03-26 22:30:43 UTC
        

      






Created attachment 114391 [details]
Small Spreadshheet

    


    


      



        
          Comment 2
        

        
          m_a_riosv

        

        
        

        
          2015-03-26 23:44:13 UTC
        

      






Hi @roger,
please can you detail what it the bug.

Please set up the status to unconfirmed after answer.

    


    


      



        
          Comment 3
        

        
          roger.eaton

        

        
        

        
          2015-03-27 09:31:32 UTC
        

      






In the range e19..e46 format is numeric -1234.12. Any integer is diplayed as eg 3.00 except 5, which is displayed as 0.21 (rounded), and takes that value in calculation. As far as I can tell all other numbers, integer and decimal are correctly displayed and used.

    


    


      



        
          Comment 4
        

        
          GerardF

        

        
        

        
          2015-03-27 10:28:52 UTC
        

      






Typing 5 and resulting in 0.21 is cause by "AutoInput".
If I write 5 and look at the cell before pressing Enter, I saw the suggestion 5:00.
Hitting enter accept the suggestion. (5 hours is 0.21 day)

Normaly "AutoInput" don't work with numeric values but only strings.
Here AutoInput suggest 5:00 because cell C14 (containing 5:00) is formatted as text (@).

IMHO, this is not a bug.
I let this Unconfirmed for other opinion.

    


    


      



        
          Comment 5
        

        
          raal

        

        
        

        
          2015-04-01 18:19:32 UTC
        

      






After delete cell C14 I can write 5 without problem, autoinput issue. Closing as notabug