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
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
Migrating Whiteboard tags to Keywords: (needsDevEval) [NinjaEdit]
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.1.6 or 5.2.3 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170103
Created attachment 135810 [details] Properties as shown in Office 2007 on Windows 7
When I open the .doc and .xls from the test file zip file, the properties show for both documents on Office 2007 on Windows 7. The screenshots in the test case file doesn't seem to be native Windows, so not sure if that had something to do with the original issue?