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 2024/11/27 06:22:54 UTC

[Bug 69475] New: autoresize fails when more rows than rowAccessWindowSize

https://bz.apache.org/bugzilla/show_bug.cgi?id=69475

            Bug ID: 69475
           Summary: autoresize fails when more rows than
                    rowAccessWindowSize
           Product: POI
           Version: 5.2.3-FINAL
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: SXSSF
          Assignee: dev@poi.apache.org
          Reporter: jan.stolze@equans.com
  Target Milestone: ---

Created attachment 39944
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=39944&action=edit
Testcase showing the issue

When a SXSSFWorkbook has more rows than the rowAccessWindowSize
the auto-resize does not remember the size of the first row.
See attachment which creates two workbooks which illustrate the problem

-- 
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 69475] autoresize fails when more rows than rowAccessWindowSize

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=69475

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |INFORMATIONPROVIDED
             Status|NEEDINFO                    |RESOLVED

--- Comment #2 from Dominik Stadler <do...@gmx.at> ---
This is likely fixed by the given advice. Please reopen if there is still a
problem.

-- 
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 69475] autoresize fails when more rows than rowAccessWindowSize

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=69475

PJ Fanning <fa...@yahoo.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO
                 OS|                            |All

--- Comment #1 from PJ Fanning <fa...@yahoo.com> ---
sheet.trackAllColumnsForAutoSizing() -- should be called before create any
rows.

You don't need to call sheet.autoSizeColumn(0) if you are tracking all columns
from all columns. If you insist on calling this - again, it must be called
before you create and rows.

The whole point of SXSSF code is to not keep all the data in memory. The
streaming code needs to know in advance if you want to track sizes for auto
sizing.

-- 
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