Bug 64767 - 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
Keywords: Beginner
Depends on:
Reported: 2020-09-25 16:16 UTC by Elke Hofmann
Modified: 2020-12-13 09:52 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:16:01 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 Dominik Stadler 2020-10-25 04:22:32 UTC
Please provide the minimal java-code that is necessary to reproduce this.
Comment 2 Dominik Stadler 2020-12-13 09:52:53 UTC
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.