Bug 63621 - Unable to link data from file
Summary: Unable to link data from file
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: SXSSF (show other bugs)
Version: unspecified
Hardware: PC Linux
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2019-07-30 13:50 UTC by Arrtu
Modified: 2019-07-30 13:52 UTC (History)
0 users

Empty external data from file (37.85 KB, image/png)
2019-07-30 13:50 UTC, Arrtu

Note You need to log in before you can comment on or make changes to this bug.
Description Arrtu 2019-07-30 13:50:53 UTC
Created attachment 36688 [details]
Empty external data from file

1) Using SXSSF to add data and generate excel file. 
2) Using microsoft excel 'Data -> Get external data -> From file' shows no data in file, but they are 100% there. 

But if you open the file in excel and 'Save as' then 'Data -> Get external data -> From file' functionality work fine. 

Investigation shows that in sheet from 'Saved as' file dimension tag is <dimension ref="A1:E4"/> and in file that was generated with SXSSF dimension tag is <dimension ref="A1:E1"/>.

I tried next code but didn't helped:
sxssfWorkbook.getXSSFWorkbook.getSheet(sheet.getSheetName).getCTWorksheet.getDimension.setRef("A1:" + CellReference.convertNumToColString(nubmerOfCol) + contentLenght)

Is there any hot-fix for this?