https://bugs.documentfoundation.org/show_bug.cgi?id=140580
--- Comment #5 from Colin <that.man.co...@gmail.com> ---
(In reply to m.a.riosv from comment #4)
> Have you seen that 17:21 it's a text not a true time in the spreadsheet.
>
> Use Menu/View/Value Highlighting
>
> Text is in black, numeric/date-time values in blue.
Precisely, It was text in the SMS, it was text in the SMSBackup XLS file in
Dropbox, it was text in the view XML file at
https://synctech.com.au/sms-backup-restore/view-backup/ using Firefox and it
appeared as a formatted time when pasted special to the Lo Calc - see attached
screen grab and compare it with the cut & paste herewith from the first stage
of my processing;
Sent 2021-02-17 2:35:43 PM Bus?
Received 2021-02-17 2:36:00 PM 05:21 PM
Sent 2021-02-17 2:36:43 PM Food?
Note: As can be seen in the attached screen grab, the entire date & Time is one
text string which I then chop and rationalise.
The subsequent treatment in the sample calc can be verified as "unexpected" and
"inconsistent". It's a two-stage operation. I select and copy the browser
screen and then ALT CTRL SHFT V to the LO Calc which simply forces unformatted
- NO dialogue box * to the first sheet and that is the representation above
where the source 17:21 is autoformatted 05:21PM. I then manipulate some of the
data but NEVER the text message which is then simply selected and copied with
CTRL SHFT V to the destination and the dialogue box is confirmed "text,
numbers, date and time". All the rationalised dates and times present as
formatted but the 17:21 or 05:21PM which is sourced from a "numerically
formatted? text" cell becomes decimal 0,72291666* within the target cell.
It was only noticed by chance and I don't really conceive of vetting 7500 lines
on the calc to ascertain if perhaps 10-20 could contain the same anomaly
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
