To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94724
User rainerbielefeld changed the following:
What |Old value |New value
================================================================================
CC|'' |'rainerbielefeld'
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
OS/Version|All |Windows XP
--------------------------------------------------------------------------------
Platform|Unknown |PC
--------------------------------------------------------------------------------
Summary|Date/time arithmetic in fo|Date/time arithmetic in fo
|rmulas does not work |rmulas does not work after
| | input
--------------------------------------------------------------------------------
Subcomponent|code |ui
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Tue Oct 7 06:08:01 +0000
2008 -------
I checked with "Ooo 3.0.0 RC3 Multilingual version German UI WIN XP: [OOO300m8
(Build9357)]" and can confirm the reported effect. Also tested with 2.4.1 and
can also confirm that it worked fine with 2.4.
The problem seems to be, that 3.0 does no longer modify the time input
immediately to a decimal number:
Try with 2.4.1
1. open new spreadsheet
2. Input to a cell "=11:22" <enter>
(some date will appear)
3. Move cell cursor back to cell
you see contents "=0,473611111111111"
Try with 3.0.0
11. open new spreadsheet
12. Input to a cell "=11:22" <enter>
("Err:502" will appear)
13. Move cell cursor back to cell
you see contents "=11:22"
Because the problem is some input handling, there is no problem with documents
created with 2.4, all cells will be shown correctly.
There is also no problem to calculate with cells containing time information.
Only calculation with direct time input is broken.
@klute
Please specify your Platform and OS!
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
