https://bugs.freedesktop.org/show_bug.cgi?id=54672
Bug #: 54672
Summary: CONFIGURATION: Does not respect "text" preformatted
cell when we type a time in the cell in xlsx format
Classification: Unclassified
Product: LibreOffice
Version: 3.6.1.2 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
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
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- 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
