https://bz.apache.org/bugzilla/show_bug.cgi?id=59734
Bug ID: 59734 Summary: Named range creation & lookup are linear in the number of ranges Product: POI Version: unspecified Hardware: PC OS: Linux Status: NEW Severity: normal Priority: P2 Component: XSSF Assignee: dev@poi.apache.org Reporter: dtn-asfb...@corefiling.co.uk XSSFName.setNameName and XSSFWorkbook.getName both involve a linear iteration through all names already in the workbook. This is a major performance bottleneck for an application creating lots of named ranges. I'll shortly attach a suggested patch which does the obvious thing and adds a map to do fast lookup. I'll also propose deprecating the methods on Workbook which operate in an index-based manner and replacing them with ones based on names. -- 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