Issue 20138

Summary:	Lose of time format when saving to xls
Product:	Calc	Reporter:	mpupat <mpupat>
Component:	code	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED FIXED	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues, marius.andreiana
Version:	OOo 1.1 RC5
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description mpupat 2003-09-26 09:50:37 UTC

When you format an empty cell to display hours and minutes (HH:MM) and you save 
to Excel format, the format is lost re-opening either with MS Excel or with OOo 
Spreadsheet

Comment 1 daniel.rentz 2003-09-26 15:21:13 UTC

This is a known limitation of the Excel export filter. It saves only
the range of rows, that are filled with any values (numbers, text,
formulas, ...). So if your last value is in row 5, all rows starting
from row 6 are not exported (stay completely empty and lose
formatting). If you have no contents at all, nothing is exported
(especially no formatting).
Workaround: Have at least one cell filled in the row with the empty
cell or beyond.
I will set this issue to "OOo Later", because the fix is not trivial.

Comment 2 daniel.rentz 2003-09-26 15:21:31 UTC

started

Comment 3 daniel.rentz 2003-11-03 15:05:43 UTC

*** Issue 21973 has been marked as a duplicate of this issue. ***

Comment 4 daniel.rentz 2004-05-03 09:41:15 UTC

*** Issue 28409 has been marked as a duplicate of this issue. ***

Comment 5 daniel.rentz 2004-08-30 12:38:18 UTC

fixed in src680/dr20 (OOo 2.0)

Comment 6 daniel.rentz 2004-08-30 12:38:39 UTC

fixed

Comment 7 oc 2004-08-30 13:34:07 UTC

verified in internal build cws_dr20

Comment 8 oc 2004-12-10 14:49:42 UTC

closed because fix available in OOo1.9m65