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
Please provide the minimal java-code that is necessary to reproduce this.
No response for a long time so we cannot do much here, thus resolving this for now, please reopen with more information if this is still a problem for you.