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

            Bug ID: 69658
           Summary: CellUtil is using HashMap instead of EnumMap
           Product: POI
           Version: unspecified
          Hardware: PC
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P2
         Component: SS Common
          Assignee: dev@poi.apache.org
          Reporter: nik_...@abv.bg
  Target Milestone: ---

I have been using CellUtil.setCellStylePropertiesEnum to change cells'
CellStyle, but I've noticed that it adds quite a lot of overhead, especially
when you deal with tens of thousands of cells. The main issue, obviously, is
the lack of cache which makes a necessity for getFormatProperties to be called
on all the cell styles in the workbook. But the second highest contributor to
the overhead, as far as I've observed, is the creation and comparison of the
properties maps. And I do not understand, why are HashMaps used there, instead
of EnumMaps. The creation and comparison of EnumMaps is much faster than the
one of HashMaps. I am missing some detail of why HashMaps are used in the whole
CellUtil instead of EnumMaps?

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Reply via email to