From: Helge Hafting [mailto:helge.haft...@ntnu.no] Sent: Monday, September 5, 2016 3:07 PM
Den 05. sep. 2016 00:53, skrev Jannick: > Currently lyx deals with *.xls files only, while the Excel world > rather turns around .xlsx files. It would be great if lyx could be > extended including the file handler where ssconvert appears to > faithfully extract data from *.xlsx files. > > I am not subscribed to the devel list, so please copy me in if you > need any more information on this from my side. > LyX already support .xlsx, so I am not sure what you are asking for here? I created a LyX document, inserted a file (external material). I selected spreadsheet, and typed in "testfile.xlsx". This worked fine, the PDF contained the spreadsheet. Anything "ssconvert" supports should indeed work. I don't know if ssconvert handles all xlsx files, but it certainly handled my testfile well. I tested with LyX 2.2.1, but this sould work for most earlier versions too - as there haven't been much changes since the excel support went in. Conversion is handled by ssconvert, so anything ssconvert handles should work, (unless the spreadsheet is wider than the page). Do you have an xlsx file that ssconvert handles, but LyX does not? If so, please send me such a file so I can look into it. Helge Hafting _____________ Thanks. What I am suggesting is an enhancement of lyx' ssconvert interface (i.e. for external material/tables), namely: 1 - adding *.xlsx to the file filter of the file selection dialog window (to avoid manual entering the file name - as you suggested - and not to be cluttered with all files in the specific folder after selecting the file filter *.* provided as second option in the file selection dialog window) 2 - add *.xlsx in the default file handler configuration which does not appear to exist in the default configuration (in lyx 2.1.5 (on Win10) there is only one explicitly saying that it deals with *.xls). Regards, J.
