Just tried to load some excel sheets and it doesn´t work. Normally this is not a problem . That are [xlsx] excel sheets generated by a federal statistic bureau in germany. OO try to open it and get stuck somewhere in the middle of process, using 25% CPU (maybe 1 core). Tried it with 2 separate sheets, downloaded them first [as I most often do; the bigger one was 50MB, the smaller I tested is about 10MB]. Because it failed this time I updated OO to 4.1.6, but nothing changed.
I wonder if there is a new excel version out and incompatible? Or any other known problem?
Apreciate any help
Last edited by Hagar Delest on Wed Feb 13, 2019 10:57 pm, edited 1 time in total.
Reason:tagged solved
Try disabling macros - it may be a incompatible macro is looping.
Try converting the .xlsx to a .odt at zamzar.com or similar site.
See [Tutorial] Differences between Writer and MS Word files for a discussion of differences between MS and AOO files - it could be a new feature in the .xlsx file though I would expect AOO just to ignore any such new feature (without telling you ).
Zamzar does convert it into .xls but the converted sheet does have errors [fields wich should contain numbers contain "err:504" and "makro??" instead ]. Seems to be a more complicated type of excel sheet. :-/
LibreOffice can open and edit the file almost effortlessly. There is a strange warning about too many columns but no sheet (including the 8 hidden ones) goes beyond column U. https://libreoffice.org is the successor of OpenOffice.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
).
