Bug 54672 - CONFIGURATION: Does not respect "text" preformatted cell when we type a time in the cell in xlsx format
Summary: CONFIGURATION: Does not respect "text" preformatted cell when we type a time ...
Status: RESOLVED DUPLICATE of bug 55091
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.1.2 release
Hardware: Other All
: high major
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-09-08 15:40 UTC by Marcio Jacques
Modified: 2012-09-23 16:59 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Marcio Jacques 2012-09-08 15:40:38 UTC 
Occors in xlsx format (for Excell):

1- Format cell as text.
2- Type a time in the cell for ex 01:39:20 (1 hour 39 minutes 20 seconds). (But look: I want TEXT format preserved later, not time format, because I want to use hour, minutes and seconds in a formula that expects 8 characters!).
3- Save the sheet as xlsx type and close it. (Before closing it's ok).
4- Reopen it: you will see that there is a strange number in the cell and it is formatted as number. Data is not lost, because if you open using Excell it's ok. But I want to see my data the way I typed it using Libreoffice or I will change for Excell!
Thanks
Comment 1 A (Andy) 2012-09-22 18:07:59 UTC 
reproduced with LO 3.6.1.2 (Windows), but after reopening this cell is formatted as text, but shows a number 0,0689....
in Excel 2007 it is correct
Comment 2 Rainer Bielefeld Retired 2012-09-23 16:59:00 UTC 
Known problem from "Bug 55091 -  FILEOPEN .xlsx shows text dates DD.MM.YYYY as integer numbers with existing date recognition pattern D.M.Y"

@Marcio Jacques 
Thank you for your attention!
Comment 3 Rainer Bielefeld Retired 2012-09-23 16:59:22 UTC 

*** This bug has been marked as a duplicate of bug 55091 ***