https://bugs.documentfoundation.org/show_bug.cgi?id=151668
Bug ID: 151668
Summary: unable to perform calculations on HH:MM:SS fields read
from a file
Product: LibreOffice
Version: 7.4.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 183176
--> https://bugs.documentfoundation.org/attachment.cgi?id=183176&action=edit
Sampling of the file I was trying to process when this issue was discovered
Found this issue in today's 7.5.0alpha. It exists in 7.4.0.3, so I suspect it
exists in all versions; so reporting it against 7.4.0.3.
Calc will not allow calculations of HH:MM:SS fields read in from a file. I can
manually enter 12:34:56 data in cells and the calculations work.
Steps to reproduce:
- Open attached file
- Select fixed width (also occurs with Separated by)
- add field separators on either side of the timestamps
- OK
- select any cell with HH:MM:SS -- the Input line shows the content correctly
- insert a column next to the column of timestamps
- Assuming you have the times in column B and the new column at C
- in C2, enter =b2-b1
- C2 shows =B2-B1
Issue #1:
- with the attached file, C2 should display 00:00:00, not =B2-B1
Issue #2:
- select C2 and double-click on its bottom-right corner to repeat the formula
- C3 shows =B2-B2 instead of =B3-B2
- C4 shows =B2-B3 instead of =B4-B3
- C5 shows =B2-B4 instead of =B5-B4
etc... or more correctly, instead of the time differences.
- the repeat acts like C2 contains =B$2-B1
Note that the time cells in column B are still showing as 12:34:56
Issue #3:
- select column B
- Format>Cells... (hoping this would solve the above)
Time, 13:37:46, OK
- Notice that all the B cell contents now have a leading single quote
This further makes the time calculations unlikely.
Issue #4:
- It probably wouldn't help; but the "Column type:" selections are lacking in
the Text Import panel; only a minimal choices are available.
Amazingly, at this point, if I copy column B to an empty column, and create the
formulae as above, the calculations work.
So this bug may be covered with an Errata notice until it's resolved.
--
You are receiving this mail because:
You are the assignee for the bug.
