You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2019/07/30 13:50:53 UTC
[Bug 63621] New: Unable to link data from file be
https://bz.apache.org/bugzilla/show_bug.cgi?id=63621
Bug ID: 63621
Summary: Unable to link data from file be
Product: POI
Version: unspecified
Hardware: PC
OS: Linux
Status: NEW
Severity: normal
Priority: P2
Component: SXSSF
Assignee: dev@poi.apache.org
Reporter: artem@telemagic.no
Target Milestone: ---
Created attachment 36688
--> https://bz.apache.org/bugzilla/attachment.cgi?id=36688&action=edit
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?
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63621] Unable to link data from file
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63621
Arrtu <ar...@telemagic.no> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|Unable to link data from |Unable to link data from
|file be |file
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org