Bug 49376

Summary:	EDITING
Product:	LibreOffice	Reporter:	John Stamos <jastamos>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED INVALID
Severity:	normal	CC:	LibreOffice
Priority:	medium
Version:	3.5.2 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description John Stamos 2012-05-02 04:22:36 UTC

When using text to columns, converting a date time from a text string AM and PM is ignored, excel handles the same data correctly.

3/11/2012 5:33 PM is converted to 3/11/12 5:33 AM in calc 

I tried setting the format of the cells before conversion to MM/DD/YY HH:MM AM/PM before conversion but that didn't help

thanks

Comment 1 Rainer Bielefeld Retired 2012-05-02 04:47:17 UTC

No idea what problem we are talking about.

@reporter:
Thank you for your report – unfortunately important information is missing.
May be hints on <http://wiki.documentfoundation.org/BugReport> will help you to find out what information will be useful to reproduce your problem? If you believe that that  is really sophisticated please as for Help on a user mailing list
Please:
- Write a meaningful Summary describing exactly what the problem is
- Attach a sample document (not only screenshot) or refer to an existing 
  sample document in an other Bug with a link.
- Attach screenshots with comments if you believe that that might explain the 
  problem better than a text comment. Best way is to insert your screenshots
  into a DRAW document and to add comments that explain what you want to show
- Contribute a step by step instruction containing every key press and every 
  mouse click how to reproduce your problem (due to example in Bug 43431)
– if possible contribute an instruction how to create a sample document 
  from the scratch
- add information 
  -- what EXACTLY is unexpected
  -- and WHY do you believe it's unexpected (cite Help or Documentation!)
  -- concerning your PC 
  -- concerning your OS (Version, Distribution, Language)
  -- concerning your LibO version (with Build ID if it's not a public release)
     and localization (UI language, Locale setting)
  –- Libo settings that might be related to your problems 
    (anything related to "Locale" settings)
  -- how you launch LibO and how you opened the sample document
  -- everything else crossing your mind after you read linked texts

Even  if you can not provide all demanded information, every little new information might bring the breakthrough.

Comment 2 Rainer Bielefeld Retired 2012-05-21 00:47:46 UTC

Closing Bug due to reporter's inactivity as INVALID.

@reporter:
Please feel free to reopen this bug if you find out that the problem still exists with the current stable LibreOffice version and if you can contribute requested additional information due to <http://wiki.documentfoundation.org/BugReport> (especially BugReport Details)!