https://bugs.documentfoundation.org/show_bug.cgi?id=94771
Bug ID: 94771
Summary: FORMATTING: time is impossible to figure out
Product: LibreOffice
Version: 4.2.8.2 release
Hardware: Other
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
I'm trying to build a spreadsheet with a column of MM:SS formatting. However I
get impossible to understand results. I enter 30:08 and get 6:06 displayed. The
application is to list some video files with their lengths from 00:00 to 59:59
seconds. and then do time sum operations on the lengths with =sum(...) and so
forth. However formatting an entire column as MM:SS does not appear to work
correctly. Things appear to work for some values, but for other values, the
results are totally nonsensical.
It appears that the problem is that if you take the default formatting of HH:MM
rather than resetting it manually to MM:SS, then you get values that cannot be
converted to MM:SS. For example, if I have mistakenly formatted the column to
13:37 option, this is actually HH:MM. Which is probably what gave me the
strange result of 6:06 when I entered an hour larger than 23. But I can see no
way to correct my error without entering all the data again. Formatting to TEXT
does not do that. It seems reasonable to me that I should be able to format to
text, then back to MM:SS and correct most of the values. At that point I should
only have to re-enter the values that fall outside the range of 23:59. But this
apparently does not work. Formatting to text does not remove the "Time
Valueness" of the value and reduce it to text again apparently. Whatever is
going on is completely opaque without a deep understanding and a spreadsheet
should not behave that way in simple cases, IMHO.
It seems to me that doing this job should be so simple... But apparently the
way that time formatting works, it becomes so very hard. One apparently has to
have a deep understanding of how the spreadsheet values work, and how
formatting works BEFORE HAND or you will enter a bunch of data and then find
you have to enter it all again because you cannot easily just reformat it to
work.
I look forward to anyone's reaction to this observation.
Thanks a bunch,
WW
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
