Jenkins build is back to normal : POI-DSL-1.8 #318

2017-12-06 Thread Apache Jenkins Server
See - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61841] Unnecessary long computation when evaluating VLOOKUP on all column reference

2017-12-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61841 --- Comment #10 from Javen O'Neal --- Throw in some @Override's for good measure -- You are receiving this mail because: You are the assignee for the bug.

[Bug 61862] Improve TreeMap implementation to cache first and last key

2017-12-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61862 --- Comment #3 from Greg Woolsey --- All said and done, however, the Map interface has so many possible mutation vectors, including submaps and iterators, it likely isn't worth it. Caching in the evaluation structures is

[Bug 61841] Unnecessary long computation when evaluating VLOOKUP on all column reference

2017-12-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61841 Greg Woolsey changed: What|Removed |Added Status|NEEDINFO|RESOLVED

[Bug 61841] Unnecessary long computation when evaluating VLOOKUP on all column reference

2017-12-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61841 --- Comment #9 from Greg Woolsey --- (In reply to PJ Fanning from comment #7) > Can we call the new method getLastRowNum instead of getlastRowNum? > Also, a lot of public methods have had their signatures changed. Do we

[Bug 61797] Embed Excel / Ole objects into powerpoint

2017-12-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61797 Shashidhar changed: What|Removed |Added CC||shas.e...@gmail.com

[Bug 61841] Unnecessary long computation when evaluating VLOOKUP on all column reference

2017-12-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61841 --- Comment #8 from Luca Martini --- (In reply to Greg Woolsey from comment #5) > Changes in r1817252 > Thank you very much Greg. > Of this remaining time, about 2/3 is taken up in the formula evaluation > caching

Jenkins build is back to normal : POI-DSL-OpenJDK #330

2017-12-06 Thread Apache Jenkins Server
See - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61798] Corrupted Excel file produced due to wrong dimension calculation during XSSFWorkbook.write(str) call

2017-12-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61798 --- Comment #2 from dolphin.in.the.sky...@gmail.com --- I made a mistake in patch code. not "row.getFirstCellNum()" Correctly,"row.getLastCellNum()" Sorry. -- You are receiving this mail because: You are the assignee for the bug.

Jenkins build is back to normal : POI-DSL-Windows-1.8 #95

2017-12-06 Thread Apache Jenkins Server
See - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61832] Unable to create a excel of 500,000 rows and 150 column using SXSSF workbook

2017-12-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61832 --- Comment #9 from Yegor Kozlov --- In theory SXSSF can use a fixed-size cache of shared strings, e.g. we can allow SXSSF to put 10K distinct strings in the SST. If the cache is full then the string goes inline. The 10K limit

[Bug 61798] Corrupted Excel file produced due to wrong dimension calculation during XSSFWorkbook.write(str) call

2017-12-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61798 dolphin.in.the.sky...@gmail.com changed: What|Removed |Added CC|

[Bug 61864] New: Workbook.setForceFormulaRecalculation not working as expected

2017-12-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61864 Bug ID: 61864 Summary: Workbook.setForceFormulaRecalculation not working as expected Product: POI Version: 3.17-FINAL Hardware: PC Status: NEW

[Bug 61863] New: Sheet.ForceFormulaRecalculation not overridden by Workbook.ForceFormulaRecalculation

2017-12-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61863 Bug ID: 61863 Summary: Sheet.ForceFormulaRecalculation not overridden by Workbook.ForceFormulaRecalculation Product: POI Version: 3.17-FINAL Hardware: PC

[Bug 61862] Improve TreeMap implementation to cache first and last key

2017-12-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61862 Javen O'Neal changed: What|Removed |Added Severity|normal |enhancement

[Bug 61862] New: Improve TreeMap implementation to cache first and last key

2017-12-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61862 Bug ID: 61862 Summary: Improve TreeMap implementation to cache first and last key Product: POI Version: unspecified Hardware: PC OS: All

[Bug 61841] Unnecessary long computation when evaluating VLOOKUP on all column reference

2017-12-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61841 --- Comment #7 from PJ Fanning --- Can we call the new method getLastRowNum instead of getlastRowNum? Also, a lot of public methods have had their signatures changed. Do we need to keep the existing signatures too and

[Bug 61832] Unable to create a excel of 500,000 rows and 150 column using SXSSF workbook

2017-12-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61832 --- Comment #8 from Thamodharan --- Hi Greg Woolsey, SXSSF by default takes inline string, it can be changed to shared string for which some patch is available. Since Shared string takes the heap space memory, its

[Bug 61841] Unnecessary long computation when evaluating VLOOKUP on all column reference

2017-12-06 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61841 --- Comment #6 from Javen O'Neal --- (In reply to Greg Woolsey from comment #5) > 14.4s > when XSSFEvaluationSheet caches the value of getLastRowNum(), since it comes > from a TreeMap.lastKey() which has to navigate the tree