Public bug reported:
I'm using OpenOffice.org Calc 2.4.1 (openoffice.org-core 1:2.4.1-1ubuntu2, Mon
Jun 30 10:45:22 UTC 2008) on a machine
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.
** Affects: openoffice.org (Ubuntu)
Importance: Undecided
Status: New
--
Fill series dragging for time formats broken
https://bugs.launchpad.net/bugs/295143
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
