On 30/03/2019 15.09, Simon Becherer wrote:
Hi carlos,
Am 30.03.19 um 14:50 schrieb Carlos E. R.:
I did a test with LO. You can "save as" excel file. I tried xls and xlsx. The later is actually a zip archive, so I renamed to " test.xlsx.zip" and could open the archive with 'mc', but the structure is different. i did the same..... Google? has not helped much...
google "structure of xls excel 2002 files" <https://docs.microsoft.com/en-us/openspecs/office_file_formats/ms-xls/cd03cb5f-ca02-4934-a391-bb674cb8aa06> <https://en.wikipedia.org/wiki/Microsoft_Excel#File_formats> File formats Microsoft Excel up until 2007 version used a proprietary binary file format called Excel Binary File Format (.XLS) as its primary format.[27] Excel 2007 uses Office Open XML as its primary file format, an XML-based format that followed after a previous XML-based format called "XML Spreadsheet" ("XMLSS"), first introduced in Excel 2002.[28] Although supporting and encouraging the use of new XML-based formats as replacements, Excel 2007 remained backwards-compatible with the traditional, binary formats. In addition, most versions of Microsoft Excel can read CSV, DBF, SYLK, DIF, and other legacy formats. Support for some older file formats was removed in Excel 2007.[29] The file formats were mainly from DOS-based programs. Binary OpenOffice.org has created documentation of the Excel format.[30] Since then Microsoft made the Excel binary format specification available to freely download.[31] XML Spreadsheet Main article: Microsoft Office XML formats The XML Spreadsheet format introduced in Excel 2002[28] is a simple, XML based format missing some more advanced features like storage of VBA macros. Though the intended file extension for this format is .xml, the program also correctly handles XML files with .xls extension. This feature is widely used by third-party applications (e.g. MySQL Query Browser) to offer "export to Excel" capabilities without implementing binary file format. The following example will be correctly opened by Excel if saved either as Book1.xml or Book1.xls: Also, google "mail excel file" and you will see what your correspondent has done. There are even videos. It is possible he selected part of the sheet and hit "mail this". Try to tell him to send mail from the file explorer, not from inside excel. Or... How complicated things are... -- Cheers / Saludos, Carlos E. R. (from 15.0 x86_64 at Telcontar)