https://bz.apache.org/bugzilla/show_bug.cgi?id=57840
--- Comment #40 from Greg Woolsey <[email protected]> --- (In reply to Javen O'Neal from comment #39) Thanks. I'm moving on to the Vaadin Spreadsheet side of things for my POC, as the POI feature set and performance are acceptable at this stage. I'll likely file new issues/patches in the future if I get the project accepted. I've submitted Vaadin bug https://dev.vaadin.com/ticket/19952 with a very significant improvement to their current formula performance, especially related to conditional formatting. They were creating a new evaluation context for every _cell_ evaluated. And to do it, they were inserting a new row in an existing sheet, and modifying the first cell's formula. The row # is in the middle of the data for one of my sample workbooks, and that whole scheme was an ugly hack. I showed them how they could evaluate a formula without a Cell using an existing WorkbookEvaluator, using code I found in the unit test framework. That, along with the cached results it could now leverage, took my sample workbook from HOURS to marginally more time than the unit test I added to POI. I also have a patch to use POI 3.15 that I hope they take. But that has more in it, as they have some ugly code I couldn't bear to leave alone. I want a real-looking API along with the updated compatibility. -- 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]
