Summary: | FILESAVE: LibreOffice produced .xls files don't have file type info in properties when opened in Excel .doc files do | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | declan_moriarty |
Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | QA Contact: | |
Severity: | normal | ||
Priority: | medium | CC: | bfo.bugmail, qubit, serval2412 |
Version: | 4.0.3.3 release | ||
Hardware: | Other | ||
OS: | Mac OS X (All) | ||
Whiteboard: | BSA NeedsDevEval | ||
i915 platform: | i915 features: | ||
Attachments: | This contains test file.xls, test file.doc, test file_xls properties.png, test file_doc properties.png. These png's show the properties not filled in for the XLS file and filled in for the DOC file produced by Writer and Calc respectively. |
With LO 4.0.3.3 (Win7 Home Premium 32bit) I can see properties of all the attached files. @ign_christian, Have you opened the supplied files in Excel on your Windows 7 system? The problem is that the Excel properties are not filled in. The scant LibreOffice properties are filled in when the files are opened in LO. Someone receiving an LO produced .xls spreadsheet might not like the idea that these properties are not filled in, since they may wonder how it was produced and if it was malicious. Note that the .doc files work and the .xls files don't. So something is different between the way Writer deals with file properties and Calc. Michael: I can't reproduce this since I don't have MsOffice but if it's confirmed perhaps that, provided someone gives code pointers, it could be an easy hack, what do you think? Sure - it could be an easy-hack, but it would take some code pointers. I'll add the tag for ProposedEasyHack. The 'properties' are saved in a separate OLE2 binary stream which (IIRC) shares a reasonably common syntax with other modules like writer. Having said that - IIRC there is data in there we need, and IIRC it used to work so ... not sure. Also - it needs confirming by someone with MS Office. HTH. (In reply to comment #2) > problem is that the Excel properties are not filled in. The scant > LibreOffice properties are filled in when the files are opened in LO. Confirmed with: LO 4.2.0.0.alfa0 Build ID: 2013-06-24 own debug build Windows 7 Professional SP1 64 bit xls document properties are empty in Excel 2010. doc document properties are visible in Word 2010. Removing comma from whiteboard (please use a space to delimit values in this field) https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Whiteboard#Getting_Started (In reply to comment #4) > > Having said that - IIRC there is data in there we need, and IIRC it used to > work so ... not sure. Also - it needs confirming by someone with MS Office. > If the document properties used to be present, should we count this as a regression? We could try testing some old versions or use a bibisect repository... In order to limit the confusion between ProposedEasyHack and EasyHack and to make queries much easier we are changing ProposedEasyHack to NeedsDevEval. Thank you and apologies for the noise |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
Created attachment 79193 [details] This contains test file.xls, test file.doc, test file_xls properties.png, test file_doc properties.png. These png's show the properties not filled in for the XLS file and filled in for the DOC file produced by Writer and Calc respectively. Problem description: LibreOffice produced MS Excel .xls files don't have any file type info in the properties dialogue box when opened in Excel - .doc files do. Steps to reproduce: 1. Create a .xls spreadsheet in Calc 2. Transfer to Windows PC and open in MS Excel. 3. Open Properties dialogue box and go to General tab. Current behavior: All file type information and statistics for the general tab are empty. Expected behavior: All these fields should be filled in. Operating System: Mac OS X Version: 4.0.3.3 release