| <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> |
| <html><head> |
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Print Test Case: Link Sheet from other file</title> |
| <link type="text/css" rel="stylesheet" href="tl_documents.css"> |
| <style type="text/css" media="print">.notprintable { display:none;}</style> |
| <style></style></head> |
| <body><p> </p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-20: Link Sheet from other file <span style="font-size: 80%;">[Version : 1]</span></th></tr> |
| <tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 23/08/2012 08:30:51</td></tr> |
| <tr><td colspan="3"><span class="label">Summary:</span><br><p>Link sheet form other file, there are 3 mode in API level, NONE,VALUE,NORMAL</p> |
| <p>NONE:No link</p> |
| <p>VALUE:only link the formula result, not include the formula</p> |
| <p>NORMAL: link the formula and formula result</p></td></tr><tr><td><span class="label">#:</span></td><td><span class="label">Step actions:</span></td><td><span class="label">Expected Results:</span></td></tr><tr><td width="5">1</td><td><p>Create a new SpreadSheet document SC1, input some value and formula in every sheet, save it to file and close it.</p></td><td><p>Save and close successfully</p></td></tr><tr><td width="5">2</td><td><p>Create a new SpreadSheet document SC2, Insert 3 new sheet into SC2, link them to SC1 Sheet, the 3 link mode is NONE,VALUE,NORMAL</p></td><td><p>Link successfully,</p> |
| <p>For NONE mode link, no content display,</p> |
| <p>for VALUE mode link, only the formula result link, the formula not link</p> |
| <p>For NORMAL mode link, formula and formula result will link</p></td></tr><tr><td width="5">3</td><td><p>Save the document and reopen </p></td><td><p>Same as step 2</p></td></tr><tr><td width="5">4</td><td><p>Change the formula in SC1 and close, then open SC2 document and update the link.</p></td><td><p>The result should update correct</p></td></tr><tr><td width="20%" valign="top"><span class="label">Execution type:</span></td><td colspan="2">Automated</td></tr> |
| <tr><td width="20%" valign="top"><span class="label">Importance:</span></td><td colspan="2">Medium</td></tr> |
| <tr><td colspan="3"></td></tr><tr><td> Test Focus:</td><td colspan="2">Usability</td></tr> |
| <tr><td> Feature first available at which release:</td><td colspan="2"></td></tr> |
| <tr><td> Automation script name:</td><td colspan="2">/testuno/source/testcase/uno/sc/sheet/SheetBasicTest.java</td></tr> |
| <tr><td> Testsuite set:</td><td colspan="2">Functionality</td></tr> |
| <tr><td width="20%" valign="top"><span class="label">Requirements</span></td><td colspan="2"> None<br></td></tr> |
| <tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2">FVT(Function Verification Test)<br></td></tr> |
| </tbody></table> |
| </div> |
| </body></html> |
