I developed a Java web application which exports excel files with apache poi. Development began 2018/2019, where I tested the output successfully with Microsoft office. Later development happened on Linux with testing in Libre Office. Today we noticed that when opening the exported excel files, all columns created in the application are hidden by default. With libre office, all is fine. Update to the newest version of the dependency made no difference. Is this issue known? Is there any workaround (setting all columns hidden=false makes no difference)? Any help ist highly appreciated. best, Elke
As I saw, columns were not hidden but sized 0. Initially I had borders set and a width of -1 (which I found somewhere in www as advice) for auto width of columns, which worked on ms excel but not in Libre Office. Removing the borders caused the problem. Now I applied sheet.autosizecolumn, and it works similarly with and without borders.