Re: "Could not resolve external workbook name" after setupReferencedWorkbooks

2018-09-27 Thread Greg Woolsey
I recently got this working, but noticed these points of fragility in doing so with the current released code: 1. If the file names had spaces in them, I had to replace them with "%20" in the map keys passed to setupReferencedWorkbooks(), as that's the value used in the stored formula expressions

"Could not resolve external workbook name" after setupReferencedWorkbooks

2018-09-26 Thread wimgoeman
Hello, I need to evaluate all the formulas in a workbook which has references to other workbooks. Based on my findings I found that I had to use FormulaEvaluator#setupReferencedWorkbooks in order to link all the workbooks, but that did not work, and still resulted in a RuntimeException saying