https://bz.apache.org/bugzilla/show_bug.cgi?id=58633
Bug ID: 58633
Summary: [patch] Need to set multiple CellStyle properties at
once
Product: POI
Version: 3.13-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Created attachment 33286
--> https://bz.apache.org/bugzilla/attachment.cgi?id=33286&action=edit
Patch file
Setting a single CellStyle property at a time using setCellStyleProperty causes
a search through all the CellStyles for each property set, and creates a new
CellStyle if a match is not found, even if that specific style will never be
used. When more than one property needs to be set, for example when drawing
borders, it would be more efficient both in the number of styles created, and
in performance, to set them all in one shot.
I have included a patch to org.apache.poi.ss.util.CellUtil which adds a new
method setCellStyleProperty(Cell, Workbook, Map<String, Object>) that adds a
group of properties to the cell style in one shot. I also modified the existing
method to call the new method with a map containing a single property. No test
cases yet, just wanted to make sure I am on the right track.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
