Issue 88431 - Calc does not export sheet props properly into .xls file
Summary: Calc does not export sheet props properly into .xls file
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 2.4.0
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-04-18 10:16 UTC by kabalak
Modified: 2013-01-29 21:40 UTC (History)
1 user (show)

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

Attachments
Original Excel .xls file with properties (13.50 KB, application/vnd.ms-excel)
2008-04-18 10:18 UTC, kabalak 		no flags Details
Exported Excel .xls file from Calc - props not showing up in Excel anymore but Calc shows them anyway (62.50 KB, application/vnd.ms-excel)
2008-04-18 10:18 UTC, kabalak 		no flags Details
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 kabalak 2008-04-18 10:16:45 UTC 
An Excel .xls file with entries in the properties (Topic, keywords and 
comments) is properly opened in Calc - you can see the corresponing properties 
entries in the Properties-Dialogue of Calc.

If you now save this .xls file with Calc, the properties are lost for Excel. 
Excel does not show any properties for this .xls file anymore. Astonishingly 
reopening the corresponding file with Calc shows the properties again.

Something with the properties is screwed for Excel.
Comment 1 kabalak 2008-04-18 10:18:04 UTC 
Created attachment 52990 [details]
Original Excel .xls file with properties
Comment 2 kabalak 2008-04-18 10:18:44 UTC 
Created attachment 52991 [details]
Exported Excel .xls file from Calc - props not showing up in Excel anymore but Calc shows them anyway
Comment 3 amy2008 2008-08-25 04:47:37 UTC 
Confirmed in OOo-Dev_OOO300_m3_en-US on WinXP.

But it can be simplified as the following one.
To reproduce:
1 Create a new Calc file
2 File -> properties, properties of ... popups,
3 select Description tab, then input some characters 
  into the box(Title, Subject, Keywords, Comments)
4 File -> Save as *.xls, close the *.xls file
5 Reopen this file with excel
6 In excel, File -> properties, Description tab

Result:
Excel does not show any properties for this .xls file anymore.
But OOo Calc can show it very well.