Issue 20138 - Lose of time format when saving to xls
Summary: Lose of time format when saving to xls
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC5
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
: 21973 28409 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-09-26 09:50 UTC by mpupat
Modified: 2013-08-07 15:15 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

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

Note You need to log in before you can comment on or make changes to this issue.
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