[upstream] Fill series dragging for time formats broken
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenOffice |
Confirmed
|
Unknown
|
|||
openoffice.org (Ubuntu) |
Won't Fix
|
Low
|
Unassigned |
Bug Description
I'm using OpenOffice.org Calc 2.4.1 (openoffice.
running Ubuntu Hardy with kernel "2.6.24-21-generic #1 SMP Tue Oct 21 23:43:45 UTC 2008 i686 GNU/Linux" on it.
This bug is almoust similar to other bugs related to the fill series functions in openoffice.org, but not a really close match.
The bug i mentioned occurs, when using Calc with time formats and the automated fill series dragging (copy, count up ...)
of contents to the nearby cells. The realy weird thing is, that the correct time string is displayed in normal mode and
another one in edit mode.
Reproduce this with:
1. Open a Spreadsheet document
2. Enter a time in hh:mm notation or hh:mm:ss notation (e.g. 10:00) into a cell
3. Leave editing mode
4. Select the cell and drag the squara at the lower right corner downwards
5. The time value is copied to the cells following
6. Select again the first cell in the col and use the navigation arrows to move the selection down to the other cells
7. While moving the selection have a look at the formula input field, or change a selected cell (not the first in col) into edit mode.
The edit-mode values are upcounted by adding a multiple of 24 to the hour value, but not the viewmode values.
This may be correct looking at a date, adding 1 day for each row, but for a time string it is very confusing IMHO.
Well, cosidering the last sentence as the truth, this may be a confusing feature, not a bug ;-)
But this behavior appears only using the fill series dragging with the mouse. If you select an area of cells
and fill it using "Edit->Fill->..." the editmode-value and the viewmode-value of the cells are the same.
Changed in openoffice: | |
importance: | Undecided → Unknown |
status: | New → Unknown |
Changed in openoffice: | |
status: | Unknown → Confirmed |
Changed in openoffice.org (Ubuntu): | |
status: | Triaged → Won't Fix |
It also doesn't autofill like Excel does.
For example if you start at:
10:00
and then autofill with Excel it shows as:
11:00
12:00
13:00
14:00
etc