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 2009/02/19 15:44:30 UTC

DO NOT REPLY [Bug 46736] New: HSSFSheet autosizeColumn() doesn't process formula cells

https://issues.apache.org/bugzilla/show_bug.cgi?id=46736

           Summary: HSSFSheet autosizeColumn() doesn't process formula cells
           Product: POI
           Version: 3.2-FINAL
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: Maksym_Symonov@epam.com


HSSFSheet autosizeColumn() doesn't process formula cells. It works just with
string, number and boolean cells. It can use HSSFFormulaEvaluator to get cell
value and process it too


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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

DO NOT REPLY [Bug 46736] HSSFSheet autosizeColumn() doesn't process formula cells

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


Yegor Kozlov <ye...@dinom.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |ASSIGNED




--- Comment #1 from Yegor Kozlov <ye...@dinom.ru>  2009-02-19 08:15:13 PST ---
HSSFSheet.autosizeColumn() operates on static, i.e. non-formula cell values. It
wasn't written with formula evaluation in mind and I don't think we should
change it that way. 

However, your post suggests a natural improvement to use the cached formula
result when autosizing columns. If the cached value is wrong or out of date,
you can use HSSFFormulaEvaluator to update it.

Yegor


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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

DO NOT REPLY [Bug 46736] HSSFSheet autosizeColumn() doesn't process formula cells

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


Yegor Kozlov <ye...@dinom.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|ASSIGNED                    |RESOLVED
         Resolution|                            |FIXED




--- Comment #2 from Yegor Kozlov <ye...@dinom.ru>  2009-02-19 09:30:15 PST ---
Fixed in r745937 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=745937 )both for HSSF and XSSF.

Regards,
Yegor


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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