Issue 56054 - Date/Time-format in cell affects value display in Formular Bar
Summary: Date/Time-format in cell affects value display in Formular Bar
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO330m20
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2005-10-15 10:18 UTC by hbb
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

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

Screenshot shows partly missing content in Formula Bar (32.21 KB, image/jpeg)
2011-01-28 22:52 UTC, hbb
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description hbb 2005-10-15 10:18:57 UTC
If the cell format for example is DD.MM.YYYY and the cell contains a
date/time-value with fractions of a day (i.e. hours), these fractions are not
shown in the Formular Bar. 

The contents of the Formular Bar should reflect the exact value of the cell. A
numeric value of one-third is correctly shown as 0,333333333333333 even if the
cell format is 0,00. 

The Status Bar is even more affected. A cell format of MM.YY gives different
results between Status Bar, Formular Bar and cell value.
Comment 1 frank 2005-10-28 15:51:28 UTC

not a bug but an enhancement request.

Comment 2 ace_dent 2008-05-16 01:41:46 UTC Issue Tracker - Feedback Request.

The Issue you raised is currently assigned to 'Requirements' pending review, but
has not been updated within the last 2+ years. Please consider re-testing with
one of the latest versions of OOo, as the problem(s) may have already been
addressed. Either use the recent stable version:
or consider trying the new OOo 3 BETA (still in testing):
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
Comment 3 hbb 2011-01-28 22:51:28 UTC
Steps to reproduce in version OOO330m20 (Build 9567):

1. Type "11/11/11 9:11[Enter]" in cell C1. 
2. Type "11/11/11[Enter]" in cell C2. 
3. Move back to cell C2.
4. Edit cell C2 by typing "[F2] 9:12[Enter]". 
5. Move to cell C3 and type "=C2[Enter]".
6. Format cell C3 to show dates and fractions of days.

Step 1 gives "11.11.11 09:15" in the cell and "11.11.2011 09:15:00" in the
Formula Bar. This is the expected behavior in the German localization.

After step 4 the Formula Bar doesn't show hours and minutes, see screen shot.

Steps 5 and 6 verify that the value of cell C2 has fractions of a day.

The error happens regardless whether the checkbox RID_SCPAGE_CALC.BTN_CALC
"Precision as shown"/"Genauigkeit wie angezeigt" is set or not.
Comment 4 hbb 2011-01-28 22:52:14 UTC
Created attachment 75712 [details]
Screenshot shows partly missing content in Formula Bar