Build failed in Jenkins: POI-DSL-1.8 #316

2017-12-01 Thread Apache Jenkins Server
See Changes: [onealj] bug 61840: close workbook to prevent resource leak in unit test [onealj] bug 61840: add unit test showing that shiftRows does not produce #REF! formula errors if cells are not shifted above the

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

2017-12-01 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61841 --- Comment #3 from Javen O'Neal --- Looking at the POI implementation of Vlookup.java, the class currently doesn't have a reference to the sheet that contains the lookup table. This will make a fix non-trivial. The function that creates the A

[Bug 61840] Shifting rows loses formula references

2017-12-01 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61840 Javen O'Neal changed: What|Removed |Added Status|NEW |RESOLVED Resolution|---

[Bug 61840] Shifting rows loses formula references

2017-12-01 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61840 --- Comment #4 from Javen O'Neal --- (In reply to Luca from comment #2) > setCellFormula(anotherCell.getCellFormula()); formula is treated as a mere > string and references are not updated. setCellFormula intentionally does not shift the formu

[Bug 61840] Shifting rows loses formula references

2017-12-01 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61840 --- Comment #3 from Javen O'Neal --- This works for me in the latest version of POI (and probably also 3.17). You will get #REF! errors if you shift references above the 1st row in the workbook, which is the same behavior as Excel. You are get

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

2017-12-01 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61841 --- Comment #2 from Luca Martini --- Nick, I have already contributed some patches in the past. However I am not sure to have the time to work to this fix at the moment. I opened the bug for future reference and to check if someone with more k

[Bug 61840] Shifting rows loses formula references

2017-12-01 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61840 Luca changed: What|Removed |Added Status|NEEDINFO|NEW --- Comment #2 from Luca --- I'm using 3.1

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

2017-12-01 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61841 Nick Burch changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #1 from Nick Burch

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

2017-12-01 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61841 Luca Martini changed: What|Removed |Added CC||chiaramarches...@tagetik.co

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

2017-12-01 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61841 Bug ID: 61841 Summary: Unnecessary long computation when evaluating VLOOKUP on all column reference Product: POI Version: 3.15-FINAL Hardware: PC Status: NEW

[Bug 61840] Shifting rows loses formula references

2017-12-01 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61840 Nick Burch changed: What|Removed |Added Status|NEW |NEEDINFO OS|

[Bug 61840] New: Shifting rows loses formula references

2017-12-01 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=61840 Bug ID: 61840 Summary: Shifting rows loses formula references Product: POI Version: unspecified Hardware: PC Status: NEW Severity: normal Priority: P2