• see example application attached

1. Access /ExemploZK/test.faces

2. Begin TEST Ed Colab with External Ref -> there are 5 workbooks available

3. Enter some data on blue cells (whole numbers) in "dadosbasicos"

4. Go to "pasta1" workbook - blue cells (F2:I4) contains "dadosbasicos" values -> OK

5. On "pasta1", put data on red cells (A2:D3)

6. Go to "pasta2" workbook - purple cells contain "pasta1" values -> OK

7. Turn back to "pasta1" and change data on red cells (A2:D3)

8. Then go to pasta2 workbook. Purple cells (F6:I7) should have pasta1 values but they haven't. -> ERROR

• • • Go to "pasta3" or "geral" workbooks. They have references to other workbooks but, until this moment, haven't been opened. So they show external references correctly.

• • • If you erase a cell that is not updated due an update on referenced workbook then press Ctrl+Z, ZSS will re-enter the formula and bring updated data.

• • • What is this warning (for each field with external rference) that appears when ZKK will load a workbook?

"18:59:23,157 SEVERE [org.zkoss.zssex.model.sys.DependencyTableEx] (http-/0.0.0.0:8080-4) Cannot find the specified book "dadosbase.xlsx" in this book series: [pasta3.xlsx]"