Bug 64766 - Columns hidden when open in MS Office 365 on Windows or Mac
Summary: Columns hidden when open in MS Office 365 on Windows or Mac
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 4.1.2-FINAL
Hardware: PC Mac OS X 10.1
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2020-09-25 16:15 UTC by Elke Hofmann
Modified: 2020-09-26 14:24 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Elke Hofmann 2020-09-25 16:15:39 UTC
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
Comment 1 Elke Hofmann 2020-09-26 14:24:09 UTC
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.