https://bugs.documentfoundation.org/show_bug.cgi?id=149139
JohnTweed <dump4c...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS|All |macOS (All)
Hardware|x86-64 (AMD64) |Other
--- Comment #8 from JohnTweed <dump4c...@gmail.com> ---
Thanks to all for for taking time to look at this.
I think I see where the problem arose now.
Taking a random track list off Discogs, I copy/paste (MACOS) into calc.
If I paste with 'Paste -> +detect special numbers' then the time column values
appear as 12:34:00 for the input '12:34', changing format to TIME [HH]:MM:SS
allows the (partially) correct sum(C0:Cxx).
The only problem is that the input MM:SS is interpreted as HH:MM:00, but for
my purpose it doesn't matter, it may for some.
Now ....
If I do the paste with 'Paste Special -> +Unformatted text' then the time
column comes out as text (but doesn't show as "'12:30" ) but after a format
change to TIME [HH]:MM:SS. the column is now firmly TEXT and requires the extra
steps to undo this and get back to a time value. With only MM:SS this is
especially difficult since the TEXT->TIME conversion does not recognise that
text format as time, I have to force the TEXT to be '00:MM:SS' by prepending
"00:" to the time strings in the column.
However, setting the option 'detect special numbers' does set the time column
to be TIME type again.
So the problem is really now that
a) Can't set the detect special numbers to see MM:SS not HH:MM:SS, but it
doesn't necessarily prevent simple use for summing times.
b) The function TIMEVALUE(text) only seems to work for HH:MM:SS and is not
flexible enough to see MM:SS or any other formatting.
So once my paste was converted to TEXT life became a bit more difficult.
In conclusion,
A misunderstanding of the necessary paste choice for the mixed text and time
paste, meant that the time column was converted to text, making any further
processing a lot more complicated (because of the limitations of the TIMEVALUE
function).
--
You are receiving this mail because:
You are the assignee for the bug.
