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
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-07-30 13:50 UTC by Arrtu
Modified: 2019-07-30 13:52 UTC (History)
0 users


Attachments
Empty external data from file (37.85 KB, image/png)
2019-07-30 13:50 UTC, Arrtu 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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

Sequnce:
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)
fastWriteWb.write(fileOutputStream)

Is there any hot-fix for this?