[Bug 63621] New: Unable to link data from file be

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 63621] New: Unable to link data from file be

Bugzilla from bugzilla@apache.org
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: [hidden email]
          Reporter: [hidden email]
  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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 63621] Unable to link data from file

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=63621

Arrtu <[hidden email]> 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: [hidden email]
For additional commands, e-mail: [hidden email]