poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 46015] New: simpler usage for HSSFCellStyle?
Date Wed, 15 Oct 2008 20:37:06 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=46015

           Summary: simpler usage for HSSFCellStyle?
           Product: POI
           Version: 3.1
          Platform: PC
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: ryampolsky@yahoo.com


Just a suggestion...

It seems like the HSSFStyle API is designed more around the internals of the
xls file format than around what a programmer would want to do when building a
spreadsheet.

For example, I've been trying to figure out how to manage the global list of
HSSFCellStyles and reuse existing ones where possible.  It seems like the
easiest way to do this would be to build a reference style with all the
settings you want for a particular cell and then enumerate over all the
existing styles in the workbook to see if there's a match.

If so, would it not make sense to add the following methods to the HSSFCell
class to automate that procedure and hide it from the user:

HSSFCellStyle getNewStyle();

Produce a temporary HSSFCellStyle, where you could set all the parameters you
want, without attaching it to the workbook.

void applyNewStyle(HSSFCellStyle style);

Scan all the styles in the workbook and if there's a match, apply the existing
style to the cell.  If not, attach the new style to the workbook and apply it
to the cell.

It certainly seems like that's what Excel does when you restyle a cell.  It
certainly does not just apply the change to a global style that the cell shares
with others, in applying the change to all the shared cells.

Does this sound reasonable?  I'd submit a patch if I understood the POI
codebase better.


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


Mime
View raw message