On 29/03/2019 20.54, Simon Becherer wrote:
Am 29.03.19 um 20:39 schrieb Carlos E. R.:
Try to email the file directly to me, not to the list, but zip it first. Then I can have a go at it with an idea I have. I'm not sure, but I can try.
have mailed direct.
Seen it. Yes, the trick is to remove "mail parts". It starts like this: MIME-Version: 1.0^M X-Document-Type: Workbook^M Content-Type: multipart/related; boundary="----=_NextPart_01C3B8B1.6DB8B6D0"^M ^M Dieses Dokument wurde f.r die Anzeige in Microsoft Excel 2002 oder h.her formatiert. Sie verwenden eine fr.here Version von Excel.^M ^M ------=_NextPart_01C3B8B1.6DB8B6D0^M Content-Location: file:///C:/CE594991/xls.htm^M Content-Transfer-Encoding: quoted-printable^M Content-Type: text/html; charset="us-ascii"^M ^M <html xmlns:v=3D"urn:schemas-microsoft-com:vml"^M The new file has to start at the last line above, ie: <html xmlns:v=3D"urn:schemas-microsoft-com:vml"^M and it has to end just before the "next part". The probably correct name is given there, "xls.htm". I just used "one.xls" and libre office accepted to open it, but it is empty. The second file I do the same, and this time LO populates. It is a table, but I don't know if it is correct. There is another file below, declared as style sheet, and another as filelist: Content-Location: file:///C:/CE594991/xls_files/filelist.xml^M Content-Transfer-Encoding: quoted-printable^M Content-Type: text/xml; charset="us-ascii"^M ^M <xml xmlns:o=3D"urn:schemas-microsoft-com:office:office">^M <o:MainFile HRef=3D"../xls.htm"/>^M <o:File HRef=3D"stylesheet.css"/>^M <o:File HRef=3D"sheet001.htm"/>^M <o:File HRef=3D"filelist.xml"/>^M </xml>^M So, maybe sheet001.htm is the sheet and stylesheet.css the formatting. Possibly in Windows and with the correct mail program that would be assembled into the correct excel sheet. I'd guess that your correspondent is using some functionality in excel to "send via email" which only works correctly with Outlook or Exchange. Terrible. -- Cheers / Saludos, Carlos E. R. (from 15.0 x86_64 at Telcontar)