Special characters created in Excel do not translate properly to LibreOffice such as typographer's quotes (“”) or accented letters (ñ). I use Excel on a virtualized Windows XP machine. My spreadsheets are for catalog building and as such often need special characters. I use LibreOffice to open these documents on an Apple MacBook Pro to create CSV's to import into InDesign as LibreOffice is much faster at computations (usually) than Excel 2008. However, the documents often show translation errors such as Jalape√±o instead of Jalapeño.
@Eddi : please provide a sample document showing the problem. Please also indicate which format of Excel document you are using, which version of Excel you are using on the VM and the codepage you are using to save the file with on the XP machine. Does the Excel file display correctly in Excel 2008 for Mac ? Does the Excel file display correctly in Excel 2011 for Mac ? Does the Excel file display correctly in Excel 2016 ?