1<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> 2<HTML> 3<HEAD> 4 <META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=iso-8859-1"> 5 <TITLE></TITLE> 6 <META NAME="GENERATOR" CONTENT="StarOffice 6.0 (Solaris Sparc)"> 7 <META NAME="AUTHOR" CONTENT="dermot mccluskey"> 8 <META NAME="CREATED" CONTENT="20011001;14124200"> 9 <META NAME="CHANGED" CONTENT="20020103;15592900"> 10 <STYLE> 11 <!-- 12 P.text-body-indent { margin-left: 0.5cm } 13 --> 14 </STYLE> 15</HEAD> 16<BODY> 17<H1 ALIGN=CENTER>Xmerge Test Spec</H1> 18<H2>1.0 Intorduction</H2> 19<BLOCKQUOTE>This document outlines the tests to be performed on 20Xmerge, the XML-to-PDB converter for the SunONE Webtop.</BLOCKQUOTE> 21<H2>1.1 Authors</H2> 22<UL> 23 <LI><P STYLE="margin-bottom: 0cm">Dermot McCluskey 24 (dermot.mccluskey@sun.com) 25 </P> 26 <LI><P>Keelin Boyle (keelin.boyle@sun.com) 27 </P> 28</UL> 29<H2>1.2 Project/Product Identifier</H2> 30<BLOCKQUOTE>XMerge</BLOCKQUOTE> 31<H2>1.3 Reision History</H2> 32<P STYLE="margin-bottom: 0cm"> 33</P> 34<TABLE COLS=4 WIDTH=100% BORDER=1 CELLPADDING=2 CELLSPACING=0> 35 <TR> 36 <TD> 37 <P><B>Date</B></P> 38 </TD> 39 <TD> 40 <P><B>Revision</B></P> 41 </TD> 42 <TD> 43 <P><B>Comments</B></P> 44 </TD> 45 <TD> 46 <P><B>Approval</B></P> 47 </TD> 48 </TR> 49 <TR> 50 <TD> 51 <P>28-Sep-2001</P> 52 </TD> 53 <TD> 54 <P>0.3</P> 55 </TD> 56 <TD> 57 <P>Draft 3.</P> 58 </TD> 59 <TD></TD> 60 </TR> 61 <TR> 62 <TD></TD> 63 <TD></TD> 64 <TD></TD> 65 <TD></TD> 66 </TR> 67</TABLE> 68<H2>1.4 Document Customers</H2> 69<UL> 70 <LI><P STYLE="margin-bottom: 0cm">XMerge Development team 71 </P> 72 <LI><P STYLE="margin-bottom: 0cm">Ireland Desktop Test team 73 </P> 74 <LI><P>SunONE Webtop C-team 75 </P> 76</UL> 77<H2>1.5 References</H2> 78<H2>2.0 Requirements & Dependencies</H2> 79<BLOCKQUOTE>Successful automation of the tests outlined in this 80specification is dependent on the stability and reliability of the 81POSE emulator and the EmRPC Perl module that allows test 82automation. There is a risk associated with this in that 83the emulator software may not accurately emulate every aspect of the 84PalmOS and so the automated tests may not discover bugs which occur 85in "real world" scenarios. Also, if the automation 86software we use proves not to be reliable enough to consistently 87return the same test results, then the effort spent creating the test 88automation scripts will not be worthwhile. 89</BLOCKQUOTE> 90<BLOCKQUOTE>Verification of test results will depend on the usability 91of the Java-based Comparator applications, developed by the US Webtop 92QA team, which will be used to compare the output XML and 93PDB files with the expected results. 94</BLOCKQUOTE> 95<BLOCKQUOTE>Many of the tests described in this specification are 96very time consuming and it would not be practical to execute them 97manually on a regular basis.</BLOCKQUOTE> 98<H2>2.1Required Tools & Technologies</H2> 99<UL> 100 <LI><P STYLE="margin-bottom: 0cm">PalmOS Emulator (POSE) 101 </P> 102 <LI><P STYLE="margin-bottom: 0cm">EmRPC Perl module and Test Driver 103 harness 104 </P> 105 <LI><P STYLE="margin-bottom: 0cm">Comparator applications (XML and 106 PDB comparison utilities) 107 </P> 108 <LI><P STYLE="margin-bottom: 0cm">Palm V device ??? 109 </P> 110 <LI><P>StarOffice 6.X. 111 </P> 112</UL> 113<H2>2.2 Test Framework Used</H2> 114<BLOCKQUOTE>These tests are to be automated using the POSE emulator 115and the Test Driver developed by the XMerge team, which interacts 116with the EmRPC module and allows test engineers to write test scripts 117to control the conversion of documents and the interaction with the 118POSE emulator. Using this software, it is possible to automate 119the process of loading documents into the appropriate Palm 120application, apply edits to the document within the Palm emulator and 121export the document.</BLOCKQUOTE> 122<H2>3.0 Scope of Work</H2> 123<H2>4.0 Test Strategy</H2> 124<H2>4.1Test Suite Location</H2> 125<H2>4.2 Strategy overview</H2> 126<H2>4.3 Test Cases and Assertions</H2> 127<H2>4.4 Testing Not Performed</H2> 128<UL> 129 <LI><P STYLE="margin-bottom: 0cm">Performance Testing 130 </P> 131 <LI><P>Internationalization (I18N) related testing. 132 </P> 133</UL> 134<H2>5.0 Test Cases</H2> 135<BLOCKQUOTE>The test cases are divided into seperate sections for 136each PDB format supported by XMerge, and further divided into 137Convert and Merge tests within each format. The Convert tests 138validate that XMerge can perform the round trip conversion from 139StarOffice XML-based file format to PalmOS PDB format and back to 140StarOffice XML format again, without any loss of content. The 141Merge tests validate that XMerge can merge edits made on the Palm 142device with the original StarOffice XML file, while retaining any 143information in the original document which could not to translated 144into PDB format, eg embedded tables. 145</BLOCKQUOTE> 146<BLOCKQUOTE>Each section is further divided into Content and Style 147tests. The Content tests deal with the ability of XMerge to 148retain all the meaningful content, eg text, after the conversion and 149merging process. The Style tests deal with the ability of 150XMerge to retain the stylistic details, eg bold face; justification; 151line breaks, from the same round-trip conversion. The 152Content-retaining functionality is considered of much higher priority 153than the Style-retaining functionality in version 1.1. <BR> </BLOCKQUOTE> 154<H2>5.1 AportisDoc Tests</H2> 155<H2>5.1.1 AportisDoc Convert Tests</H2> 156<H2>5.1.1.1 AportisDoc Convert Content Tests</H2> 157<TABLE WIDTH=100% BORDER=1 CELLPADDING=2 CELLSPACING=0> 158 <TR VALIGN=TOP> 159 <TD WIDTH=30%> 160 <P><BR> 161 </P> 162 </TD> 163 <TD> 164 <P><BR> 165 </P> 166 </TD> 167 </TR> 168 <TR VALIGN=TOP> 169 <TD> 170 <P><BR> 171 </P> 172 </TD> 173 <TD> 174 <P><BR> 175 </P> 176 </TD> 177 </TR> 178</TABLE> 179<H2>5.1.1.2 AportisDoc Convert Style Tests</H2> 180<P><BR> 181</P> 182<H2>5.1.2 Aportis Merge Tests</H2> 183<H2>5.1.2.1 AportisDoc Merge Content Tests</H2> 184<TABLE WIDTH=100% BORDER=1 CELLPADDING=2 CELLSPACING=0> 185 <COL WIDTH=77*> 186 <COL WIDTH=179*> 187 <TR VALIGN=TOP> 188 <TD WIDTH=30%> 189 <P><BR> 190 </P> 191 </TD> 192 <TD WIDTH=70%> 193 <P><BR> 194 </P> 195 </TD> 196 </TR> 197 <TR VALIGN=TOP> 198 <TD WIDTH=30%> 199 <P><BR> 200 </P> 201 </TD> 202 <TD WIDTH=70%> 203 <P><BR> 204 </P> 205 </TD> 206 </TR> 207 <TR VALIGN=TOP> 208 <TD WIDTH=30%> 209 <P><BR> 210 </P> 211 </TD> 212 <TD WIDTH=70%> 213 <P><BR> 214 </P> 215 </TD> 216 </TR> 217</TABLE> 218<H2>5.1.2.2 AportisDoc Merge Style Tests</H2> 219<TABLE WIDTH=100% BORDER=1 CELLPADDING=2 CELLSPACING=0> 220 <COL WIDTH=72*> 221 <COL WIDTH=184*> 222 <TR VALIGN=TOP> 223 <TD WIDTH=28%> 224 <P><B>aportis/merge/style/animatedgif</B></P> 225 </TD> 226 <TD WIDTH=72%> 227 <P><B>Summary</B>: document with an embedded image – 228 straight forward convert and merge</P> 229 <P><B>Procedure:</B> <BR>Use test file <B>a_animatedgif.sxw</B>. 230 </P> 231 <P>Convert a_animatedgif.sxw to a_animatedgif.pdb, in AportisDoc 232 PDB format. <BR>Start POSE with AportisDoc application and import 233 a_animatedgif.pdb. <BR>Export the doc back to a_animatedgif.pdb. 234 <BR>Merge a_animatedgif.pdb and the original document to 235 a_animatedgif.sxw. 236 </P> 237 <P><B>Expected result:</B> <BR>The resultant document should 238 contain: 239 </P> 240 <BLOCKQUOTE>This document has a animated gif embedded in it.</BLOCKQUOTE> 241 <BLOCKQUOTE>Start of animated gif.</BLOCKQUOTE> 242 <BLOCKQUOTE><Image of spinning globe></BLOCKQUOTE> 243 <BLOCKQUOTE>End of animated gif. 244 </BLOCKQUOTE> 245 </TD> 246 </TR> 247 <TR VALIGN=TOP> 248 <TD WIDTH=28%> 249 <P><B>aportis/content/style/bolddoc</B></P> 250 </TD> 251 <TD WIDTH=72%> 252 <P><B>Summary</B>: document with bold type and varying font – 253 straight forward convert</P> 254 <P><B>Procedure:</B> <BR>Use test file <B>a_bolddoc.sxw</B>. 255 </P> 256 <P>Convert a_bolddoc.sxw to a_bolddoc.pdb, in AportisDoc PDB 257 format. <BR>Start POSE with AportisDoc application and import 258 a_bolddoc.pdb. <BR>Export the doc back to a_bolddoc.pdb. <BR>Merge 259 a_bolddoc.pdb and the original document to a_bolddoc.sxw. 260 </P> 261 <P><B>Expected result:</B> <BR>The resultant document should 262 contain: 263 </P> 264 <BLOCKQUOTE><STRONG>This complete line is in <FONT SIZE=6 STYLE="font-size: 22pt">bold</FONT> 265 with font set to Times New Roman. The word bold is of size 22, 266 while rest of the words are of size 12. </STRONG> 267 </BLOCKQUOTE> 268 </TD> 269 </TR> 270 <TR VALIGN=TOP> 271 <TD WIDTH=28%> 272 <P><B>aportis/merge/style/bookmarks</B></P> 273 </TD> 274 <TD WIDTH=72%> 275 <P><B>Summary</B>: document with inserted bookmarks – 276 straight forward convert</P> 277 <P><B>Procedure:</B> <BR>Use test file <B>a_bookmarks.sxw</B>. 278 </P> 279 <P>Convert a_bookmarks.sxw to a_bookmarks.pdb, in AportisDoc PDB 280 format. <BR>Start POSE with AportisDoc application and import 281 a_bookmarks.pdb. <BR>Export the doc back to a_bookmarks.pdb. 282 <BR>Merge a_bookmarks.pdb and the original document to 283 a_bookmarks.sxw. 284 </P> 285 <P><B>Expected result:</B> <BR>The resultant document should 286 contain: 287 </P> 288 <BLOCKQUOTE>Two paragraphes of text with 2 bookmarks set. To 289 identify bookmarks, select Edit -> Navigator and bookmarks, 290 user should see BK1 and BK2 and clicking on these labels in the 291 navigator popup places the cursor in the position of the original 292 bookmark, .i.e. 293 </BLOCKQUOTE> 294 <BLOCKQUOTE>BK1 = Bookmark|</BLOCKQUOTE> 295 <BLOCKQUOTE>BK2 = Silicon 296 </BLOCKQUOTE> 297 </TD> 298 </TR> 299 <TR VALIGN=TOP> 300 <TD WIDTH=28%> 301 <P><B>aportis/merge/style/bulletorderedlist</B></P> 302 </TD> 303 <TD WIDTH=72%> 304 <P><B>Summary</B>: document with bulletorderedlist – 305 straight forward convert</P> 306 <P><B>Procedure:</B> <BR>Use test file <B>a_bulletorderedlist.sxw</B>. 307 </P> 308 <P>Convert a_bulletorderedlist.sxw to a_bulletorderedlist.pdb, in 309 AportisDoc PDB format. <BR>Start POSE with AportisDoc application 310 and import a_bulletorderedlist.pdb. <BR>Export the doc back to 311 a_bulletorderedlist.pdb. <BR>Merge a_bulletorderedlist.pdb and the 312 original document to a_bulletorderedlist.sxw. 313 </P> 314 <P><B>Expected result:</B> <BR>The resultant document should 315 contain: 316 </P> 317 <P STYLE="margin-bottom: 0cm; font-style: normal">This document is 318 an example of a simple bullet ordered list.</P> 319 <P STYLE="margin-bottom: 0cm"><BR> 320 </P> 321 <UL> 322 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Bullet 1</P> 323 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Bullet 2</P> 324 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Bullet 3</P> 325 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Bullet 4</P> 326 </UL> 327 <P STYLE="margin-bottom: 0cm"><BR> 328 </P> 329 <BLOCKQUOTE STYLE="font-style: normal">End of bullet Ordered list.</BLOCKQUOTE> 330 <BLOCKQUOTE><BR> 331 </BLOCKQUOTE> 332 </TD> 333 </TR> 334 <TR VALIGN=TOP> 335 <TD WIDTH=28%> 336 <P><B>aportis/content/style/emptydoc</B></P> 337 </TD> 338 <TD WIDTH=72%> 339 <P><B>Summary</B>: empty document – straight forward convert</P> 340 <P><B>Procedure:</B> <BR>Use test file <B>a_emptydoc.sxw</B>. 341 </P> 342 <P>Convert a_emptydoc.sxw to a_emptydoc.pdb, in AportisDoc PDB 343 format. <BR>Start POSE with AportisDoc application and import 344 a_emptydoc.pdb. <BR>Export the doc back to a_emptydoc.pdb. <BR>Merge 345 a_emptydoc.pdb and the original document to a_emptydoc.sxw. 346 </P> 347 <P><B>Expected result:</B> <BR>The resultant document should 348 contain: 349 </P> 350 <BLOCKQUOTE><STRONG><empty document>. </STRONG> 351 </BLOCKQUOTE> 352 </TD> 353 </TR> 354 <TR VALIGN=TOP> 355 <TD WIDTH=28%> 356 <P><B>aportis/merge/style/firstlineindent</B></P> 357 </TD> 358 <TD WIDTH=72%> 359 <P><B>Summary</B>: document with line indent – straight 360 forward convert</P> 361 <P><B>Procedure:</B> <BR>Use test file <B>a_firstlineindent.sxw</B>. 362 </P> 363 <P>Convert a_firstlineindent.sxw to a_firstlineindent.pdb, in 364 AportisDoc PDB format. <BR>Start POSE with AportisDoc application 365 and import a_firstlineindent.pdb. <BR>Export the doc back to 366 a_firstlineindent.pdb. <BR>Merge a_firstlineindent.pdb and the 367 original document to a_firstlineindent.sxw. 368 </P> 369 <P><B>Expected result:</B> <BR>The resultant document should 370 contain: 371 </P> 372 <BLOCKQUOTE>This line is using First Line indent style. Now isnt 373 that Kool... Also Im running short of words to say here, to wrap 374 this particular sentence.</BLOCKQUOTE> 375 </TD> 376 </TR> 377 <TR VALIGN=TOP> 378 <TD WIDTH=28%> 379 <P><B>aportis/content/style/fontsize</B></P> 380 </TD> 381 <TD WIDTH=72%> 382 <P><B>Summary</B>: document with varying font size – 383 straight forward convert</P> 384 <P><B>Procedure:</B> <BR>Use test file <B>a_fontsize.sxw</B>. 385 </P> 386 <P>Convert a_fontsize.sxw to a_fontsize.pdb, in AportisDoc PDB 387 format. <BR>Start POSE with AportisDoc application and import 388 a_fontsize.pdb. <BR>Export the doc back to a_fontsize.pdb. <BR>Merge 389 a_fontsize.pdb and the original document to a_fontsize.sxw. 390 </P> 391 <P><B>Expected result:</B> <BR>The resultant document should 392 contain: 393 </P> 394 <BLOCKQUOTE>Text with font size 10, 16, 20, 40, 96.</BLOCKQUOTE> 395 </TD> 396 </TR> 397 <TR VALIGN=TOP> 398 <TD WIDTH=28%> 399 <P><B>aportis/content/style/heading</B></P> 400 </TD> 401 <TD WIDTH=72%> 402 <P><B>Summary</B>: document with heading type style – 403 straight forward convert</P> 404 <P><B>Procedure:</B> <BR>Use test file <B>a_heading.sxw</B>. 405 </P> 406 <P>Convert a_heading.sxw to a_heading.pdb, in AportisDoc PDB 407 format. <BR>Start POSE with AportisDoc application and import 408 a_heading.pdb. <BR>Export the doc back to a_heading.pdb. <BR>Merge 409 a_heading.pdb and the original document to a_heading.sxw. 410 </P> 411 <P><B>Expected result:</B> <BR>The resultant document should 412 contain: 413 </P> 414 <P STYLE="margin-top: 0.42cm; page-break-after: avoid"><FONT FACE="Times New Roman, serif"><FONT SIZE=4>This 415 piece of text is in Heading paragraph style.</FONT></FONT></P> 416 </TD> 417 </TR> 418 <TR VALIGN=TOP> 419 <TD WIDTH=28%> 420 <P><B>aportis/content/style/heading1</B></P> 421 </TD> 422 <TD WIDTH=72%> 423 <P><B>Summary</B>: document with heading1 type style – 424 straight forward convert</P> 425 <P><B>Procedure:</B> <BR>Use test file <B>a_heading1.sxw</B>. 426 </P> 427 <P>Convert a_heading1.sxw to a_heading1.pdb, in AportisDoc PDB 428 format. <BR>Start POSE with AportisDoc application and import 429 a_heading1.pdb. <BR>Export the doc back to a_heading1.pdb. <BR>Merge 430 a_heading1.pdb and the original document to a_heading1.sxw. 431 </P> 432 <P><B>Expected result:</B> <BR>The resultant document should 433 contain: 434 </P> 435 <H1 STYLE="font-weight: medium">This piece of text is in Heading1 436 paragraph style</H1> 437 </TD> 438 </TR> 439 <TR VALIGN=TOP> 440 <TD WIDTH=28%> 441 <P><B>aportis/content/style/heading2</B></P> 442 </TD> 443 <TD WIDTH=72%> 444 <P><B>Summary</B>: document with heading2 type style – 445 straight forward convert</P> 446 <P><B>Procedure:</B> <BR>Use test file <B>a_heading2.sxw</B>. 447 </P> 448 <P>Convert a_heading2.sxw to a_heading2.pdb, in AportisDoc PDB 449 format. <BR>Start POSE with AportisDoc application and import 450 a_heading2.pdb. <BR>Export the doc back to a_heading2.pdb. <BR>Merge 451 a_heading2.pdb and the original document to a_heading2.sxw. 452 </P> 453 <P><B>Expected result:</B> <BR>The resultant document should 454 contain: 455 </P> 456 <H2>This document is set in Heading2 style.</H2> 457 </TD> 458 </TR> 459 <TR VALIGN=TOP> 460 <TD WIDTH=28%> 461 <P><B>aportis/content/style/hyperlink</B></P> 462 </TD> 463 <TD WIDTH=72%> 464 <P><B>Summary</B>: document with embedded hyperlink – 465 straight forward convert</P> 466 <P><B>Procedure:</B> <BR>Use test file <B>a_hyperlink.sxw</B>. 467 </P> 468 <P>Convert a_hyperlink.sxw to a_hyperlink.pdb, in AportisDoc PDB 469 format. <BR>Start POSE with AportisDoc application and import 470 a_hyperlink.pdb. <BR>Export the doc back to a_hyperlink.pdb. 471 <BR>Merge a_hyperlink.pdb and the original document to 472 a_hyperlink.sxw. 473 </P> 474 <P><B>Expected result:</B> <BR>The resultant document should 475 contain: 476 </P> 477 <P STYLE="margin-bottom: 0cm">This line is bookmarked to BK1 478 (Insert-Bookmark)</P> 479 <P STYLE="margin-bottom: 0cm"><BR> 480 </P> 481 <P STYLE="margin-bottom: 0cm">The line <A HREF="http://sunweb.central/allhome.html">SunWeb 482 Home Page</A> has a hyperlink to sunweb.central.</P> 483 <P STYLE="margin-bottom: 0cm"><BR> 484 </P> 485 <P STYLE="margin-bottom: 0cm">This line is a hyperlink to <A HREF="#BK1">BK1</A>. 486 Click here will take cursor to top of page.</P> 487 <P STYLE="margin-bottom: 0cm"><BR> 488 </P> 489 <P><Check hyperlink has the correct address.></P> 490 </TD> 491 </TR> 492 <TR VALIGN=TOP> 493 <TD WIDTH=28%> 494 <P><B>aportis/content/style/justified</B></P> 495 </TD> 496 <TD WIDTH=72%> 497 <P><B>Summary</B>: document with justified styling – 498 straight forward convert</P> 499 <P><B>Procedure:</B> <BR>Use test file <B>a_justified.sxw</B>. 500 </P> 501 <P>Convert a_justified.sxw to a_justified.pdb, in AportisDoc PDB 502 format. <BR>Start POSE with AportisDoc application and import 503 a_justified.pdb. <BR>Export the doc back to a_justified.pdb. 504 <BR>Merge a_justified.pdb and the original document to 505 a_justified.sxw. 506 </P> 507 <P><B>Expected result:</B> <BR>The resultant document should 508 contain: 509 </P> 510 <P STYLE="margin-bottom: 0cm; font-style: normal"><SUP><FONT SIZE=5 STYLE="font-size: 20pt">Left 511 aligned text</FONT></SUP></P> 512 <P ALIGN=CENTER STYLE="margin-bottom: 0cm; font-style: normal"><SUP><FONT SIZE=5 STYLE="font-size: 20pt">Centre 513 aligned</FONT></SUP></P> 514 <P ALIGN=RIGHT STYLE="margin-bottom: 0cm; font-style: normal"><SUP><FONT SIZE=5 STYLE="font-size: 20pt">Right 515 aligned </FONT></SUP> 516 </P> 517 <P ALIGN=JUSTIFY STYLE="font-style: normal"><SUP><FONT SIZE=5 STYLE="font-size: 20pt">Justified</FONT></SUP></P> 518 </TD> 519 </TR> 520 <TR VALIGN=TOP> 521 <TD WIDTH=28%> 522 <P><B>aportis/merge/style/linebreaks</B></P> 523 </TD> 524 <TD WIDTH=72%> 525 <P><B>Summary</B>: document with linebreaks – straight 526 forward convert</P> 527 <P><B>Procedure:</B> <BR>Use test file <B>a_linebreaks.sxw</B>. 528 </P> 529 <P>Convert a_linebreaks.sxw to a_linebreaks.pdb, in AportisDoc PDB 530 format. <BR>Start POSE with AportisDoc application and import 531 a_linebreaks.pdb. <BR>Export the doc back to a_linebreaks.pdb. 532 <BR>Merge a_linebreaks.pdb and the original document to 533 a_linebreaks.sxw. 534 </P> 535 <P><B>Expected result:</B> <BR>The resultant document should 536 contain: 537 </P> 538 <P STYLE="margin-bottom: 0cm">This page has a line breaks inserted 539 at end of this line.<BR>When coverted to doc format it should 540 accordingly be broken up at the same point.</P> 541 <P ALIGN=LEFT STYLE="text-indent: 0.2cm; margin-top: 0.4cm; margin-bottom: 0.41cm"> 542 A simple list</P> 543 <OL> 544 <LI><P ALIGN=LEFT>second entry. A line break follows<BR>the above 545 line has been broken with a line break</P> 546 </OL> 547 <P STYLE="font-style: normal"><SUP><FONT SIZE=5 STYLE="font-size: 20pt">Third 548 entry</FONT></SUP></P> 549 </TD> 550 </TR> 551 <TR VALIGN=TOP> 552 <TD WIDTH=28%> 553 <P><B>aportis/merge/style/linespacing</B></P> 554 </TD> 555 <TD WIDTH=72%> 556 <P><B>Summary</B>: document with varied linespacing – 557 straight forward convert</P> 558 <P><B>Procedure:</B> <BR>Use test file <B>a_linespacing.sxw</B>. 559 </P> 560 <P>Convert a_linespacing.sxw to a_linespacing.pdb, in AportisDoc 561 PDB format. <BR>Start POSE with AportisDoc application and import 562 a_linespacing.pdb. <BR>Export the doc back to a_linespacing.pdb. 563 <BR>Merge a_linespacing.pdb and the original document to 564 a_linespacing.sxw. 565 </P> 566 <P><B>Expected result:</B> <BR>The resultant document should 567 contain: 568 </P> 569 <P STYLE="margin-bottom: 0cm"><I>First: This line and thenext line 570 is spaced by double-line spacing</I></P> 571 <P STYLE="margin-bottom: 0cm"><I>Second: Note the line-distance 572 spacing</I></P> 573 <P STYLE="margin-bottom: 0cm"><BR> 574 </P> 575 <P STYLE="margin-bottom: 0cm"><BR> 576 </P> 577 <P STYLE="margin-bottom: 0cm"><B>First: This line and the next 578 line is spaced by single-line spacing</B></P> 579 <P STYLE="margin-bottom: 0cm"><B>Second: Note the line-distance 580 spacing</B></P> 581 <P STYLE="margin-bottom: 0cm"><BR> 582 </P> 583 <P STYLE="margin-bottom: 0cm; font-weight: medium">First: This 584 line and the next line is spaced by 1.5 line spacing</P> 585 <P STYLE="font-weight: medium">Second: Not the line-distance 586 spacing.</P> 587 </TD> 588 </TR> 589 <TR VALIGN=TOP> 590 <TD WIDTH=28%> 591 <P><B>aportis/merge/style/numberorderedlist</B></P> 592 </TD> 593 <TD WIDTH=72%> 594 <P><B>Summary</B>: document with numberorderedlist – 595 straight forward convert</P> 596 <P><B>Procedure:</B> <BR>Use test file <B>a_numberorderedlist.sxw</B>. 597 </P> 598 <P>Convert a_numberorderedlist.sxw to a_numberorderedlist.pdb, in 599 AportisDoc PDB format. <BR>Start POSE with AportisDoc application 600 and import a_numberorderedlist.pdb. <BR>Export the doc back to 601 a_numberorderedlist.pdb. <BR>Merge a_numberorderedlist.pdb and the 602 original document to a_numberorderedlist.sxw. 603 </P> 604 <P><B>Expected result:</B> <BR>The resultant document should 605 contain: 606 </P> 607 <P STYLE="margin-bottom: 0cm; font-style: normal">This document is 608 an example of a simple numbered ordered list.</P> 609 <P STYLE="margin-bottom: 0cm"><BR> 610 </P> 611 <OL> 612 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">First</P> 613 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Second</P> 614 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Third</P> 615 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Fourth</P> 616 </OL> 617 <P STYLE="margin-bottom: 0cm"><BR> 618 </P> 619 <P STYLE="margin-bottom: 0cm"><BR> 620 </P> 621 <P STYLE="margin-bottom: 0cm; font-style: normal">End of numbered 622 Ordered list</P> 623 <BLOCKQUOTE><BR> 624 </BLOCKQUOTE> 625 </TD> 626 </TR> 627 <TR VALIGN=TOP> 628 <TD WIDTH=28%> 629 <P><B>aportis/content/style/pagebreak</B></P> 630 </TD> 631 <TD WIDTH=72%> 632 <P><B>Summary</B>: document with pagebreaks – straight 633 forward convert</P> 634 <P><B>Procedure:</B> <BR>Use test file <B>a_pagebreak.sxw</B>. 635 </P> 636 <P>Convert a_pagebreak.sxw to a_pagebreak.pdb, in AportisDoc PDB 637 format. <BR>Start POSE with AportisDoc application and import 638 a_pagebreak.pdb. <BR>Export the doc back to a_pagebreak.pdb. 639 <BR>Merge a_pagebreak.pdb and the original document to 640 a_pagebreak.sxw. 641 </P> 642 <P><B>Expected result:</B> <BR>The resultant document should 643 contain: 644 </P> 645 <P STYLE="margin-bottom: 0cm">The document has page breaks</P> 646 <P STYLE="margin-bottom: 0cm">Page 1 647 </P> 648 <P>-now a page break-</P> 649 </TD> 650 </TR> 651 <TR VALIGN=TOP> 652 <TD WIDTH=28%> 653 <P><B>aportis/merge/style/paragraph</B></P> 654 </TD> 655 <TD WIDTH=72%> 656 <P><B>Summary</B>: document with set paragraph styling– 657 straight forward convert</P> 658 <P><B>Procedure:</B> <BR>Use test file <B>a_paragraph.sxw</B>. 659 </P> 660 <P>Convert a_paragraph.sxw to a_paragraph.pdb, in AportisDoc PDB 661 format. <BR>Start POSE with AportisDoc application and import 662 a_paragraph.pdb. <BR>Export the doc back to a_paragraph.pdb. 663 <BR>Merge a_paragraph.pdb and the original document to 664 a_paragraph.sxw. 665 </P> 666 <P><B>Expected result:</B> <BR>The resultant document should 667 contain: 668 </P> 669 <P STYLE="margin-bottom: 0cm">This line is a paragraph. It is 670 indented from left hand side by 1.0 inch and from right and side 671 by 1.0 inch (paragraph 672 </P> 673 <P>settings).</P> 674 </TD> 675 </TR> 676 <TR VALIGN=TOP> 677 <TD WIDTH=28%> 678 <P><B>aportis/content/style/standard</B></P> 679 </TD> 680 <TD WIDTH=72%> 681 <P><B>Summary</B>: document with standard text and default 682 settings – straight forward convert</P> 683 <P><B>Procedure:</B> <BR>Use test file <B>a_standard.sxw</B>. 684 </P> 685 <P>Convert a_standard.sxw to a_standard.pdb, in AportisDoc PDB 686 format. <BR>Start POSE with AportisDoc application and import 687 a_standard.pdb. <BR>Export the doc back to a_standard.pdb. <BR>Merge 688 a_standard.pdb and the original document to a_standard.sxw. 689 </P> 690 <P><B>Expected result:</B> <BR>The resultant document should 691 contain: 692 </P> 693 <P><FONT FACE="Times New Roman">This line of text is listed in 694 standard style.</FONT></P> 695 </TD> 696 </TR> 697 <TR VALIGN=TOP> 698 <TD WIDTH=28%> 699 <P><B>aportis/content/style/subscript</B></P> 700 </TD> 701 <TD WIDTH=72%> 702 <P><B>Summary</B>: document with subscript text setting – 703 straight forward convert</P> 704 <P><B>Procedure:</B> <BR>Use test file <B>a_subscript.sxw</B>. 705 </P> 706 <P>Convert a_subscript.sxw to a_subscript.pdb, in AportisDoc PDB 707 format. <BR>Start POSE with AportisDoc application and import 708 a_subscript.pdb. <BR>Export the doc back to a_subscript.pdb. 709 <BR>Merge a_subscript.pdb and the original document to 710 a_subscript.sxw. 711 </P> 712 <P><B>Expected result:</B> <BR>The resultant document should 713 contain: 714 </P> 715 <P STYLE="margin-bottom: 0cm"><FONT FACE="Times New Roman"><FONT SIZE=4>The 716 last word on this line is in subscript. <SPAN STYLE="font-style: normal"><SUB>Dude</SUB></SPAN></FONT></FONT></P> 717 <P><BR> 718 </P> 719 </TD> 720 </TR> 721 <TR VALIGN=TOP> 722 <TD WIDTH=28%> 723 <P><B>aportis/content/style/superscript</B></P> 724 </TD> 725 <TD WIDTH=72%> 726 <P><B>Summary</B>: document with superscript text setting – 727 straight forward convert</P> 728 <P><B>Procedure:</B> <BR>Use test file <B>a_subscript.sxw</B>. 729 </P> 730 <P>Convert a_superscript.sxw to a_superscript.pdb, in AportisDoc 731 PDB format. <BR>Start POSE with AportisDoc application and import 732 a_superscript.pdb. <BR>Export the doc back to a_superscript.pdb. 733 <BR>Merge a_superscript.pdb and the original document to 734 a_superscript.sxw. 735 </P> 736 <P><B>Expected result:</B> <BR>The resultant document should 737 contain: 738 </P> 739 <P STYLE="margin-bottom: 0cm"><FONT FACE="Times New Roman"><FONT SIZE=4>The 740 last word on this line is in superscript. <SPAN STYLE="font-style: normal"><SUP>Dude 741 </SUP></SPAN></FONT></FONT> 742 </P> 743 <P><BR> 744 </P> 745 </TD> 746 </TR> 747 <TR VALIGN=TOP> 748 <TD WIDTH=28%> 749 <P><B>aportis/content/style/symbols</B></P> 750 </TD> 751 <TD WIDTH=72%> 752 <P><B>Summary</B>: document with various symbol types – 753 straight forward convert</P> 754 <P><B>Procedure:</B> <BR>Use test file <B>a_symbols.sxw</B>. 755 </P> 756 <P>Convert a_symbols.sxw to a_symbols.pdb, in AportisDoc PDB 757 format. <BR>Start POSE with AportisDoc application and import 758 a_symbols.pdb. <BR>Export the doc back to a_symbols.pdb. <BR>Merge 759 a_symbols.pdb and the original document to a_symbols.sxw. 760 </P> 761 <P><B>Expected result:</B> <BR>The resultant document should 762 contain: 763 </P> 764 <P STYLE="margin-bottom: 0cm">'-'-'-'->->->->. 765 '''''''. -------. >>>>>>></P> 766 <P STYLE="margin-bottom: 0cm; font-style: normal"><SUP><FONT FACE="Times New Roman"><FONT SIZE=4>!”£$%^&*()_+}{~@:?><,./;'#][=-??? 767 </FONT></FONT></SUP> 768 </P> 769 <P><BR> 770 </P> 771 </TD> 772 </TR> 773 <TR VALIGN=TOP> 774 <TD WIDTH=28%> 775 <P><B>aportis/content/style/tab</B></P> 776 </TD> 777 <TD WIDTH=72%> 778 <P><B>Summary</B>: document with tab styling – straight 779 forward convert</P> 780 <P><B>Procedure:</B> <BR>Use test file <B>a_tab.sxw</B>. 781 </P> 782 <P>Convert a_tab.sxw to a_tab.pdb, in AportisDoc PDB format. 783 <BR>Start POSE with AportisDoc application and import a_tab.pdb. 784 <BR>Export the doc back to a_tab.pdb. <BR>Merge a_tab.pdb and the 785 original document to a_tab.sxw. 786 </P> 787 <P><B>Expected result:</B> <BR>The resultant document should 788 contain: 789 </P> 790 <P STYLE="margin-bottom: 0cm">This is a tabbed document</P> 791 <P STYLE="margin-bottom: 0cm">1 Tab line</P> 792 <P STYLE="margin-bottom: 0cm">2 tabbed line</P> 793 <P STYLE="margin-bottom: 0cm">3 tabbed line</P> 794 <P STYLE="margin-bottom: 0cm">2 tabbed line</P> 795 <P STYLE="margin-bottom: 0cm">1 Tab line</P> 796 <P STYLE="margin-bottom: 0cm">4 tab line</P> 797 <P STYLE="margin-bottom: 0cm">2 tab line</P> 798 <P><BR> 799 </P> 800 </TD> 801 </TR> 802 <TR VALIGN=TOP> 803 <TD WIDTH=28%> 804 <P><B>aportis/merge/style/table</B></P> 805 </TD> 806 <TD WIDTH=72%> 807 <P><B>Summary</B>: document with table – straight forward 808 convert</P> 809 <P><B>Procedure:</B> <BR>Use test file <B>a_table.sxw</B>. 810 </P> 811 <P>Convert a_table.sxw to a_table.pdb, in AportisDoc PDB format. 812 <BR>Start POSE with AportisDoc application and import a_table.pdb. 813 <BR>Export the doc back to a_table.pdb. <BR>Merge a_table.pdb and 814 the original document to a_table.sxw. 815 </P> 816 <P><B>Expected result:</B> 817 </P> 818 <P>The resultant document should contain: 819 </P> 820 <P STYLE="margin-bottom: 0cm"><Check table & contents are 821 identical to original.> 822 </P> 823 <P STYLE="margin-bottom: 0cm"><BR> 824 </P> 825 <P STYLE="margin-bottom: 0cm">This document has a table with 3 826 rows and 3 columns:</P> 827 <P STYLE="margin-bottom: 0cm"><BR> 828 </P> 829 <P><BR><BR> 830 </P> 831 <P STYLE="margin-bottom: 0cm"><TABLE & CONTENTS></P> 832 <P><BR> 833 </P> 834 </TD> 835 </TR> 836 <TR VALIGN=TOP> 837 <TD WIDTH=28%> 838 <P><B>aportis/content/style/textspan</B></P> 839 </TD> 840 <TD WIDTH=72%> 841 <P><B>Summary</B>: document testing textspan 842 italics,bolds,underline together– straight forward convert</P> 843 <P><B>Procedure:</B> <BR>Use test file <B>a_textspan.sxw</B>. 844 </P> 845 <P>Convert a_textspan.sxw to a_textspan.pdb, in AportisDoc PDB 846 format. <BR>Start POSE with AportisDoc application and import 847 a_textspan.pdb. <BR>Export the doc back to a_textspan.pdb. <BR>Merge 848 a_textspan.pdb and the original document to a_textspan.sxw. 849 </P> 850 <P><B>Expected result:</B> 851 </P> 852 <P>The resultant document should contain: 853 </P> 854 <P STYLE="margin-bottom: 0cm">Document indicating Text Span</P> 855 <P STYLE="margin-bottom: 0cm"><BR> 856 </P> 857 <P STYLE="margin-bottom: 0cm; font-weight: medium"><I>This is a 858 simple line with some amount of text. The whole line is in italic 859 except the next 3 words which is also <B>SET TO BOLD</B>. Also the 860 next word is <U>UNDERLINED</U>. The essence is differnet styles 861 within the same text span.</I></P> 862 <P><BR> 863 </P> 864 </TD> 865 </TR> 866 <TR VALIGN=TOP> 867 <TD WIDTH=28%> 868 <P><B>aportis/merge/style/unorderedlist</B></P> 869 </TD> 870 <TD WIDTH=72%> 871 <P><B>Summary</B>: document with unorderedlist – straight 872 forward convert</P> 873 <P><B>Procedure:</B> <BR>Use test file <B>a_unorderedlist.sxw</B>. 874 </P> 875 <P>Convert a_unorderedlist.sxw to a_unorderedlist.pdb, in 876 AportisDoc PDB format. <BR>Start POSE with AportisDoc application 877 and import a_unorderedlist.pdb. <BR>Export the doc back to 878 a_unorderedlist.pdb. <BR>Merge a_unorderedlist.pdb and the 879 original document to a_unorderedlist.sxw. 880 </P> 881 <P><B>Expected result:</B> 882 </P> 883 <P>The resultant document should contain: 884 </P> 885 <P STYLE="margin-bottom: 0cm; font-style: normal">This document is 886 an example of a simple un- ordered list</P> 887 <P STYLE="margin-bottom: 0cm"><BR> 888 </P> 889 <OL> 890 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Wag the Dog</P> 891 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Gladiator</P> 892 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Insider</P> 893 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Usual 894 Suspects</P> 895 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Glengarry 896 Glen Ross</P> 897 </OL> 898 <OL> 899 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Host Shots</P> 900 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Airplane</P> 901 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Monty 902 Python</P> 903 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">History of 904 the World</P> 905 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Sacry Movie</P> 906 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Austin 907 Powers</P> 908 </OL> 909 <UL> 910 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Scarlet and 911 the Black</P> 912 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Operation 913 Day Break</P> 914 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Life is 915 Beautiful</P> 916 <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Nephew 917 (beutfiul soundtrack)</P> 918 </UL> 919 <P STYLE="margin-bottom: 0cm"><BR> 920 </P> 921 <P STYLE="margin-bottom: 0cm; font-style: normal; font-weight: medium"> 922 End of un-ordered list.</P> 923 <P><BR> 924 </P> 925 </TD> 926 </TR> 927 <TR VALIGN=TOP> 928 <TD WIDTH=28%> 929 <P><B>aportis/content/style/wordwrap</B></P> 930 </TD> 931 <TD WIDTH=72%> 932 <P><B>Summary</B>: document which tests wordwrapping – 933 straight forward convert</P> 934 <P><B>Procedure:</B> <BR>Use test file <B>a_wordwrap.sxw</B>. 935 </P> 936 <P>Convert a_wordwrap.sxw to a_wordwrap.pdb, in AportisDoc PDB 937 format. <BR>Start POSE with AportisDoc application and import 938 a_wordwrap.pdb. <BR>Export the doc back to a_wordwrap.pdb. <BR>Merge 939 a_wordwrap.pdb and the original document to a_wordwrap.sxw. 940 </P> 941 <P><B>Expected result:</B> 942 </P> 943 <P>The resultant document should contain:</P> 944 <P STYLE="margin-bottom: 0cm; font-weight: medium"><I>This line is 945 a long line just to check if the word wrap feature works fine, 946 when it is synched onto the PDA..</I></P> 947 <P><BR> 948 </P> 949 </TD> 950 </TR> 951 <TR VALIGN=TOP> 952 <TD WIDTH=28%> 953 <P><B>aportis/merge/content/simple01</B></P> 954 </TD> 955 <TD WIDTH=72%> 956 <P><B>Summary</B>: simple document - insert text at beginning 957 </P> 958 <P><B>Procedure:</B> <BR>Use test file <B>a_standard.sxw</B>. 959 </P> 960 <P>Convert a_standard.sxw to a_standard.pdb, in AportisDoc PDB 961 format. <BR>Start POSE with AportisDoc application and import 962 a_standard.pdb. <BR>Insert the following text, including the 963 terminating line-feed, at the beginning of the first line: 964 </P> 965 <BLOCKQUOTE>New text added to simple file.</BLOCKQUOTE> 966 <P>Export the doc back to a_standard.pdb. <BR>Merge a_standard.pdb 967 and the original document to a_standard.sxw. 968 </P> 969 <P><B>Expected result:</B> <BR>The resultant file should contain: 970 </P> 971 <BLOCKQUOTE>New text added to simple file. <BR>This line of 972 text is listed in standard style </BLOCKQUOTE> 973 </TD> 974 </TR> 975 <TR VALIGN=TOP> 976 <TD WIDTH=28%> 977 <P><B>aportis/merge/content/simple02</B></P> 978 </TD> 979 <TD WIDTH=72%> 980 <P><B>Summary</B>: simple document - insert text in middle 981 </P> 982 <P><B>Procedure:</B> <BR>Use test file <B>a_standard.sxw</B>. 983 </P> 984 <P>Convert a_standard.sxw to a_standard.pdb, in AportisDoc PDB 985 format. <BR>Start POSE with AportisDoc application and import 986 a_standard.pdb. <BR>Insert the following text immediately after 987 the word "text": 988 </P> 989 <BLOCKQUOTE>, including this inserted phrase, </BLOCKQUOTE> 990 <P>Export the doc back to a_standard.pdb. <BR>Merge a_standard.pdb 991 and the original document to a_standard.sxw. 992 </P> 993 <P><B>Expected result:</B> <BR>The resultant file should contain: 994 </P> 995 <BLOCKQUOTE>This line of text, including this inserted 996 phrase, is listed in standard style </BLOCKQUOTE> 997 </TD> 998 </TR> 999 <TR VALIGN=TOP> 1000 <TD WIDTH=28%> 1001 <P><B>aportis/merge/content/simple03</B></P> 1002 </TD> 1003 <TD WIDTH=72%> 1004 <P><B>Summary</B>: simple document - append text 1005 </P> 1006 <P><B>Procedure:</B> <BR>Use test file <B>a_standard.sxw</B>. 1007 </P> 1008 <P>Convert a_standard.sxw to a_standard.pdb, in AportisDoc PDB 1009 format. <BR>Start POSE with AportisDoc application and import 1010 a_standard.pdb. <BR>Append a new-line at the end of the line and 1011 add the following line: 1012 </P> 1013 <BLOCKQUOTE>This is also in standard style</BLOCKQUOTE> 1014 <P>Export the doc back to a_standard.pdb. <BR>Merge a_standard.pdb 1015 and the original document to a_standard.sxw. 1016 </P> 1017 <P><B>Expected result:</B> <BR>The resultant file should contain: 1018 </P> 1019 <BLOCKQUOTE>This line of text is listed in standard 1020 style <BR>This is also in standard style</BLOCKQUOTE> 1021 </TD> 1022 </TR> 1023</TABLE> 1024<H2>5.2 MiniCalc Tests</H2> 1025<H2>5.2.1 MiniCalc Convert Tests</H2> 1026<H2>5.2.1.1 MiniCalc Merge Style Tests</H2> 1027<TABLE WIDTH=100% BORDER=1 CELLPADDING=2 CELLSPACING=0> 1028 <COL WIDTH=77*> 1029 <COL WIDTH=179*> 1030 <TR VALIGN=TOP> 1031 <TD WIDTH=30%> 1032 <P><B>minicalc/merge/style/columnswidth</B> <BR> </P> 1033 </TD> 1034 <TD WIDTH=70%> 1035 <P><B>Summary</B>: Spreadsheet with 5 columns 10 entries - 1036 Spreadsheet columnwidth variation. 1037 </P> 1038 <P><B>Procedure:</B> <BR>Use test file <B>c_columnswidth.sxc</B>. 1039 </P> 1040 <P>Convert c_columnswidth.sxc to c_columnswidth.pdb, in MiniCalc 1041 PDB format. <BR>Start POSE with MiniCalc application and 1042 import c_columnswidth.pdb. </P> 1043 <P>Choose Cell Reference "B1" & alter column width 1044 to 1.55 by selecting, Format -> Column -> Width... < make 1045 width change via spin button> -> OK, also decrease "E1" 1046 similarly to have a column width of 1.68.<BR><BR><BR> 1047 </P> 1048 <P>Export the doc back to c_columnswidth.pdb. <BR>Merge 1049 c_columnswidth.pdb to c_columnswidth.sxw. 1050 </P> 1051 <P><B>Expected result:</B> <BR> Spreadsheet should display 1052 column B with a width increase of 1.0 , and column E with a width 1053 decrease of 1.0, as compared with the original file, reflecting 1054 the changes stated above.</P> 1055 </TD> 1056 </TR> 1057 <TR VALIGN=TOP> 1058 <TD WIDTH=30%> 1059 <P><B>minicalc/merge/style/rowheight</B></P> 1060 </TD> 1061 <TD WIDTH=70%> 1062 <P><B>Summary</B>: Spreadsheet with 4 columns 3 rows 12 entries - 1063 Spreadsheet rowheight variation. 1064 </P> 1065 <P><B>Procedure:</B> <BR>Use test file <B>c_rowheight.sxc</B>. 1066 </P> 1067 <P>Convert c_rowheight.sxc to c_rowheight.pdb, in MiniCalc PDB 1068 format. <BR>Start POSE with MiniCalc application and import 1069 c_rowheight.pdb. </P> 1070 <P><BR>Choose Cell Reference "A1" & alter row height 1071 to 1.17 by selecting Format -> Row -> Height... <make 1072 height change via spin button> -> OK., also decrease "A3” 1073 similarly to have a row height of 0.30. 1074 </P> 1075 <P>Export the doc back to c_rowheight.pdb. <BR>Merge 1076 c_rowheight.pdb to c_rowheight.sxw. 1077 </P> 1078 <P><B>Expected result:</B> <BR> Spreadsheet should display 1079 row “Row 1” with a height increase of 1.0 and "Row 1080 3" with a height decrease of 0.41, as compared with the 1081 original file, reflecting the changes stated above.</P> 1082 </TD> 1083 </TR> 1084 <TR VALIGN=TOP> 1085 <TD WIDTH=30%> 1086 <P><B>minicalc/merge/style/rowstyles</B></P> 1087 </TD> 1088 <TD WIDTH=70%> 1089 <P><B>Summary</B>: Spreadsheet with 5 columns 6 rows 18 entries - 1090 Spreadsheet rowstyle variation. 1091 </P> 1092 <P><B>Procedure:</B> <BR>Use test file <B>c_rowstyle.sxc</B>. 1093 </P> 1094 <P>Convert c_rowstyles.sxc to c_rowstyles.pdb, in MiniCalc PDB 1095 format. <BR>Start POSE with MiniCalc application and import 1096 c_rowstyles.pdb. </P> 1097 <P>Choose Cell Reference "B3" and change Heading style 1098 to default, by selecting, Format -> Style Catelog -> <choose 1099 heading type from listbox>, also choose cellreference "D5" 1100 and change Heading style to Heading1, also change "C5" 1101 to remove bold, underline & italic. 1102 </P> 1103 <P><BR>Export the doc back to c_rowstyles.pdb. <BR>Merge 1104 c_rowstyles.pdb to c_rowstyles.sxw. 1105 </P> 1106 <P><B>Expected result:</B> <BR> Spreadsheet should display 1107 value's and style types as in original file, except cells "B3, 1108 & D5" which should display heading types default & 1109 Heading 1 resp. and "C5" which should be plain text, 1110 reflecting the changes stated above.</P> 1111 </TD> 1112 </TR> 1113</TABLE> 1114<H2>5.2.1.2 MiniCalc Convert Style Tests</H2> 1115<TABLE WIDTH=100% BORDER=1 CELLPADDING=2 CELLSPACING=0> 1116 <COL WIDTH=77*> 1117 <COL WIDTH=179*> 1118 <TR VALIGN=TOP> 1119 <TD WIDTH=30%> 1120 <P><B>minicalc/convert/style/styles</B> <BR> </P> 1121 </TD> 1122 <TD WIDTH=70%> 1123 <P><B>Summary</B>: Spreadsheet with 3 columns 10 rows 13 entries - 1124 Spreadsheet styles test. 1125 </P> 1126 <P><B>Procedure:</B> <BR>Use test file <B>c_styles.sxc</B>. 1127 </P> 1128 <P>Convert c_styles.sxc to c_styles.pdb, in MiniCalc PDB format. 1129 <BR>Start POSE with MiniCalc application and import c_styles.pdb. 1130 <BR>Export the doc back to c_styles.pdb. <BR>Merge 1131 c_styles.pdb to c_styles.sxw. </P> 1132 <P><B>Expected result:</B> <BR> Spreadsheet should display 1133 all original sheet values with style features, .i.e Bold, Italics, 1134 .</P> 1135 </TD> 1136 </TR> 1137 <TR VALIGN=TOP> 1138 <TD WIDTH=30%> 1139 <P><B>minicalc/convert/style/alignment</B><BR> </P> 1140 </TD> 1141 <TD WIDTH=70%> 1142 <P><B>Summary</B>: Spreadsheet with 4 columns 8 rows 24 entries - 1143 Spreadsheet alignment test. 1144 </P> 1145 <P><B>Procedure:</B> <BR>Use test file <B>c_alignment.sxc</B>. 1146 </P> 1147 <P>Convert c_alignment.sxc to c_alignment.pdb, in MiniCalc PDB 1148 format. <BR>Start POSE with MiniCalc application and import 1149 c_alignment.pdb. <BR>Export the doc back to 1150 c_alignment.pdb. <BR>Merge c_alignment.pdb to 1151 c_alignment.sxw. </P> 1152 <P><B>Expected result:</B> <BR> Spreadsheet should display 1153 all original sheet values with identical alignment to original 1154 file.</P> 1155 </TD> 1156 </TR> 1157</TABLE> 1158<H2><BR><BR> 1159</H2> 1160<H2>5.2.2.1 MiniCalc Merge Content Tests</H2> 1161<TABLE WIDTH=100% BORDER=1 CELLPADDING=2 CELLSPACING=0> 1162 <COL WIDTH=77*> 1163 <COL WIDTH=179*> 1164 <TR> 1165 <TD WIDTH=30% VALIGN=TOP> 1166 <P><B>minicalc/merge/content/insertimage</B><BR> </P> 1167 </TD> 1168 <TD WIDTH=70% VALIGN=BOTTOM> 1169 <P><B>Summary</B>: Spreadsheet with 6 columns 2 image inserts - 1170 Spreadsheet image insert. 1171 </P> 1172 <P><B>Procedure:</B> <BR>Use test file <B>c_insertimage.sxc</B>. 1173 </P> 1174 <P>Convert c_insertimage.sxc to c_insertimage.pdb, in MiniCalc PDB 1175 format. <BR>Start POSE with MiniCalc application and import 1176 c_insertimage.pdb. <BR>Export the doc back to 1177 c_insertimage.pdb. <BR>Merge c_insertimage.pdb to 1178 c_insertimage.sxw. 1179 </P> 1180 <P><B>Expected result:</B> <BR> Spreadsheet should display 1181 original file with both original images.</P> 1182 </TD> 1183 </TR> 1184 <TR> 1185 <TD WIDTH=30% VALIGN=TOP> 1186 <P><B>minicalc/merge/content/textimage</B><BR> </P> 1187 </TD> 1188 <TD WIDTH=70% VALIGN=BOTTOM> 1189 <P><B>Summary</B>: Spreadsheet with 6 columns 2 image inserts - 1190 Spreadsheet image text insert. 1191 </P> 1192 <P><B>Procedure:</B> <BR>Use test file <B>c_textimage.sxc</B>. 1193 </P> 1194 <P>Convert c_textimage.sxc to c_textimage.pdb, in MiniCalc PDB 1195 format. <BR>Start POSE with MiniCalc application and import 1196 c_textimage.pdb. </P> 1197 <P>Insert text immediately before and directly after the inserted 1198 image.</P> 1199 <P>Export the doc back to c_textimage.pdb. <BR>Merge 1200 c_textimage.pdb to c_textimage.sxw. 1201 </P> 1202 <P><B>Expected result:</B> <BR> Spreadsheet should display 1203 original image surrounded by text .i.e text before & after the 1204 insert.</P> 1205 </TD> 1206 </TR> 1207</TABLE> 1208<H2>5.2.2.2 MiniCalc Convert Contents Tests</H2> 1209<TABLE WIDTH=1025 BORDER=1 CELLPADDING=2 CELLSPACING=0> 1210 <COL WIDTH=431> 1211 <COL WIDTH=584> 1212 <TR VALIGN=TOP> 1213 <TD WIDTH=431> 1214 <P><BR> 1215 </P> 1216 </TD> 1217 <TD WIDTH=584> 1218 <P><BR> 1219 </P> 1220 </TD> 1221 </TR> 1222 <TR VALIGN=TOP> 1223 <TD WIDTH=431> 1224 <P><B>minicalc/convert/content/basic</B></P> 1225 </TD> 1226 <TD WIDTH=584> 1227 <P><B>Summary: </B>simple spreadsheet - round-trip conversion 1228 </P> 1229 <P><B>Procedure:</B> <BR>Use test file <B>c_standard.sxc</B>. 1230 </P> 1231 <P>Convert c_standard.sxc to c_standard.pdb, in MiniCalc PDB 1232 format. <BR>Start POSE with MiniCalc application and import 1233 c_standard.pdb. Export the doc back to c_standard.pdb, without 1234 making and changes to the spreadsheet. <BR>Merge 1235 c_standard.pdb to c_standard.sxc. 1236 </P> 1237 <P><B>Expected result:</B> <BR>The resultant file should be 1238 equivalent to the original spreadsheet. <BR> </P> 1239 </TD> 1240 </TR> 1241 <TR VALIGN=TOP> 1242 <TD WIDTH=431> 1243 <P><B>minicalc/convert/content/simple01</B></P> 1244 </TD> 1245 <TD WIDTH=584> 1246 <P><B>Summary</B>: simple spreadsheet - insert text & column 1247 of numeric values at beginning of empty sheet. 1248 </P> 1249 <P><B>Procedure:</B> <BR>Use test file <B>c_standard.sxc</B>. 1250 </P> 1251 <P>Convert c_standard.sxc to c_standard.pdb, in Minicalc PDB 1252 format. <BR>Start POSE with Minicalc application and import 1253 c_standard.pdb. <BR>Insert the following text & values 1254 at the beginning of the the spreadsheet, .i.e in Column 1: 1255 </P> 1256 <BLOCKQUOTE>Col 1</BLOCKQUOTE> 1257 <BLOCKQUOTE>1</BLOCKQUOTE> 1258 <BLOCKQUOTE>1</BLOCKQUOTE> 1259 <BLOCKQUOTE>1</BLOCKQUOTE> 1260 <P>Export the doc back to c_standard.pdb. <BR>Merge 1261 c_standard.pdb to c_standard.sxc. 1262 </P> 1263 <P><B>Expected result:</B> <BR>The resultant file should contain: 1264 </P> 1265 <BLOCKQUOTE STYLE="margin-left: 6.05cm">New column of values as 1266 shown above. </BLOCKQUOTE> 1267 </TD> 1268 </TR> 1269 <TR VALIGN=TOP> 1270 <TD WIDTH=431> 1271 <P><B>minicalc/convert/content/simple02</B></P> 1272 </TD> 1273 <TD WIDTH=584> 1274 <P><B>Summary</B>: simple spreadsheet - append a new column to 1275 end 1276 </P> 1277 <P><B>Procedure:</B> <BR>Use test file <B>c_standard.sxc</B>. 1278 </P> 1279 <P>Convert c_standard.sxc to c_standard.pdb, in MiniCalc PDB 1280 format. <BR>Start POSE with MiniCalc application and import 1281 c_standard.pdb. <BR>Insert the following column immediately 1282 after the first: 1283 </P> 1284 <BLOCKQUOTE>Col 3</BLOCKQUOTE> 1285 <BLOCKQUOTE>3</BLOCKQUOTE> 1286 <BLOCKQUOTE>3</BLOCKQUOTE> 1287 <BLOCKQUOTE>3</BLOCKQUOTE> 1288 <P>Export the doc back to c_standard.pdb. <BR>Merge 1289 c_standard.pdb to c_standard.sxc. 1290 </P> 1291 <P><B>Expected result:</B> <BR>The resultant file should contain: 1292 </P> 1293 <P CLASS="text-body-indent">Col 1 Col 3</P> 1294 <BLOCKQUOTE>1 3 1295 </BLOCKQUOTE> 1296 <BLOCKQUOTE>1 3</BLOCKQUOTE> 1297 <BLOCKQUOTE>1 3</BLOCKQUOTE> 1298 </TD> 1299 </TR> 1300 <TR VALIGN=TOP> 1301 <TD WIDTH=431> 1302 <P><B>minicalc/convert/content/simple03</B></P> 1303 </TD> 1304 <TD WIDTH=584> 1305 <P><B>Summary</B>: simple spreadsheet - insert a new column in 1306 middle 1307 </P> 1308 <P><B>Procedure:</B> <BR>Use test file <B>c_standard.sxc</B>. 1309 </P> 1310 <P>Convert c_standard.sxc to c_standard.pdb, in MiniCalc PDB 1311 format. <BR>Start POSE with MiniCalc application and import 1312 c_standard.pdb. <BR>Insert the following column immediately 1313 after the first and before the second: 1314 </P> 1315 <BLOCKQUOTE>Col 2</BLOCKQUOTE> 1316 <BLOCKQUOTE>2</BLOCKQUOTE> 1317 <BLOCKQUOTE>2</BLOCKQUOTE> 1318 <BLOCKQUOTE>2</BLOCKQUOTE> 1319 <P>Export the doc back to c_standard.pdb. <BR>Merge 1320 c_standard.pdb to c_standard.sxc. 1321 </P> 1322 <P><B>Expected result:</B> <BR>The resultant file should contain: 1323 </P> 1324 <BLOCKQUOTE>Col 1 Col 2 Col 3</BLOCKQUOTE> 1325 <BLOCKQUOTE>1 2 3</BLOCKQUOTE> 1326 <BLOCKQUOTE>1 2 3</BLOCKQUOTE> 1327 <BLOCKQUOTE>1 2 3</BLOCKQUOTE> 1328 </TD> 1329 </TR> 1330 <TR VALIGN=TOP> 1331 <TD WIDTH=431> 1332 <P><B>minicalc/convert/content/simple04</B></P> 1333 </TD> 1334 <TD WIDTH=584> 1335 <P><B>Summary</B>: simple spreadsheet - delete text 1336 </P> 1337 <P><B>Procedure:</B> <BR>Use test file <B>c_standard.sxc</B>. 1338 </P> 1339 <P>Convert c_standard.sxc to c_standard.pdb, in MiniCalc PDB 1340 format. <BR>Start POSE with MiniCalc application and import 1341 c_standard.pdb. <BR>Delete “Column 3”, so that 1342 it reads: 1343 </P> 1344 <BLOCKQUOTE>Col 1 Col 2</BLOCKQUOTE> 1345 <BLOCKQUOTE>1 2</BLOCKQUOTE> 1346 <BLOCKQUOTE>1 2</BLOCKQUOTE> 1347 <P>Export the doc back to c_standard.pdb. <BR>Merge 1348 c_standard.pdb to c_standard.sxc. 1349 </P> 1350 <P><B>Expected result:</B> <BR>The resultant file should contain: 1351 </P> 1352 <BLOCKQUOTE>Col 1 Col 2</BLOCKQUOTE> 1353 <BLOCKQUOTE>1 2</BLOCKQUOTE> 1354 <BLOCKQUOTE>1 2</BLOCKQUOTE> 1355 </TD> 1356 </TR> 1357 <TR VALIGN=TOP> 1358 <TD WIDTH=431> 1359 <P><B>minicalc/convert/content/addition</B></P> 1360 </TD> 1361 <TD WIDTH=584> 1362 <P><B>Summary</B>: Spreadsheet with 4 columns 10 entries - 1363 Spreadsheet Simple Addition using various formulae. 1364 </P> 1365 <P><B>Procedure:</B> <BR>Use test file <B>c_addition.sxc</B>. 1366 </P> 1367 <P>Convert c_addition.sxc to c_addition.pdb, in MiniCalc PDB 1368 format. <BR>Start POSE with MiniCalc application and import 1369 c_addition.pdb. <BR>Change Cell Reference "A1" = 3 1370 in formula bar. <BR>Export the doc back to c_addition.pdb. 1371 <BR>Merge c_addition.pdb to c_addition.sxc. 1372 </P> 1373 <P>A1 =3 ; B1 = 3 ; C1 =4 ;D1 =5; 1374 </P> 1375 <P>Addition types: 1376 </P> 1377 <P>Cell reference + Integer = A1+2 =5 1378 </P> 1379 <P>Integer + Decimal = 3+0.1 =3.1 1380 </P> 1381 <P>Cell Reference + Cell Reference = A1+B1 = 6 1382 </P> 1383 <P>(Bracketed Cell Reference) + (Integer + Integer) = 1384 (A1+B1)+(2+45) = 53 1385 </P> 1386 <P>Integer + (Integer) + (Integer+Integer) = 2+(0)+(3+0) = 5 1387 </P> 1388 <P>(SUM(Cell Ref;Cell Ref) +SUM(Cell Ref;Cell Ref) = 1389 (SUM(A1;B1)+SUM(B1;C1) = 13 1390 </P> 1391 <P><B>Expected result:</B> <BR> All spreadsheet entered 1392 values & the standard formula SUM of each cell should be 1393 displayed as above, formulae as stated above should be visible in 1394 the Formula Bar. </P> 1395 </TD> 1396 </TR> 1397 <TR VALIGN=TOP> 1398 <TD WIDTH=431> 1399 <P><B>minicalc/convert/content/backwardrange</B></P> 1400 </TD> 1401 <TD WIDTH=584> 1402 <P><B>Summary</B>: Spreadsheet with 2 columns 7 entries - 1403 Spreadsheet backwardranging using various formulae. 1404 </P> 1405 <P><B>Procedure:</B> <BR>Use test file <B>c_backwardrange.sxc</B>. 1406 </P> 1407 <P>Convert c_alignment.sxc to c_alignment.pdb, in MiniCalc PDB 1408 format. <BR>Start POSE with MiniCalc application and import 1409 c_alignment.pdb. <BR>Change Cell Reference "B2" = 1410 AVERAGE(2;5;5) in formula bar. <BR>Export the doc back to 1411 c_alignment.pdb. <BR>Merge c_alignment.pdb to 1412 c_alignment.sxc. 1413 </P> 1414 <P>Logical Funtion test B4: 1415 </P> 1416 <P>IF(Logical Test; Then Value;Else Value) 1417 </P> 1418 <P>.e.g. IF(23;45.45;54.54) = 45.45 1419 </P> 1420 <P>read as if logical test TRUE then place THEN VALUE in cell else 1421 place ELSE VALUE. <BR> <BR> <BR> 1422 </P> 1423 <P>Statistical Functional tests B2 , B3 resp.: 1424 </P> 1425 <P>AVERAGE(2;5;5) - Returns sum of arguments divided by number of 1426 arguments =4 . 1427 </P> 1428 <P>MAX(10;3;3) - Returns the maximum value in a list of arguments 1429 =10. <BR> <BR> <BR> 1430 </P> 1431 <P>Negative addition test B1: 1432 </P> 1433 <P>=B2-B3 = 4 - 10 = -6 <BR> <BR> <BR> 1434 </P> 1435 <P>Range Addition tests A1, A5, B5: 1436 </P> 1437 <P>SUM(B2;B4) = B2 + B3 + B4 = 4 + 10 + 45.45 = 59.45. 1438 </P> 1439 <P>SUM(A1:B2) -B4 = (59.45 + (-6) +4) - 45.45 = 12</P> 1440 <P>SUM(A1;B1)-A2 = (59.45 + (-6)) - 0 = 53.45 1441 </P> 1442 <P><B>Expected result:</B> <BR> All spreadsheet entered 1443 values & the standard formula SUM of each cell should be 1444 displayed on sheet as detailed above, formulae as stated above 1445 should be visible in the Formula Bar.</P> 1446 </TD> 1447 </TR> 1448 <TR VALIGN=TOP> 1449 <TD WIDTH=431> 1450 <P><B>minicalc/convert/content/boolean</B></P> 1451 </TD> 1452 <TD WIDTH=584> 1453 <P><B>Summary</B>: Spreadsheet with 1 column 2 entries - 1454 Spreadsheet boolean entry. 1455 </P> 1456 <P><B>Procedure:</B> <BR>Use test file <B>c_boolean.sxc</B>. 1457 </P> 1458 <P>Convert c_boolean.sxc to c_boolean.pdb, in MiniCalc PDB 1459 format. <BR>Start POSE with MiniCalc application and import 1460 c_boolean.pdb. <BR>Change Cell Reference "A2" = 1461 TRUE in formula bar. <BR>Export the doc back to 1462 c_boolean.pdb. <BR>Merge c_boolean.pdb to c_boolean.sxc. 1463 </P> 1464 <P>Logical Funtion test : cells A1, A2: 1465 </P> 1466 <P>A1=TRUE 1467 </P> 1468 <P>A2=TRUE 1469 </P> 1470 <P>Returns the logical values TRUE to the cells resp. 1471 </P> 1472 <P><B>Expected result:</B> <BR> The logical entry of each 1473 cell should be displayed on the sheet as stated above.</P> 1474 </TD> 1475 </TR> 1476 <TR VALIGN=TOP> 1477 <TD WIDTH=431> 1478 <P><B>minicalc/convert/content/cellcurrencyvalue</B></P> 1479 </TD> 1480 <TD WIDTH=584> 1481 <P><B>Summary</B>: Spreadsheet with 2 columns 10 entries - 1482 Spreadsheet Currency number Format conversion test. 1483 </P> 1484 <P><B>Procedure:</B> <BR>Use test file <B>c_cellcurrencyvalue.sxc</B>. 1485 </P> 1486 <P>Convert c_cellcurrencyvalue.sxc to c_cellcurrencyvalue.pdb, in 1487 MiniCalc PDB format. <BR>Start POSE with MiniCalc 1488 application and import c_cellcurrencyvalue.pdb. <BR>Export 1489 the doc back to c_cellcurrencyvalue.pdb. <BR>Merge 1490 c_cellcurrencyvalue.pdb to c_cellcurrencyvalue.sxc. 1491 </P> 1492 <P>Display Sheet : 12 DM. 1493 </P> 1494 <P><B>Expected result:</B> <BR> Spreadsheet entered values or 1495 the sum of each cell should be displayed with specified Currency 1496 symbol, formulae should be visible in the Formula Bar but not the 1497 currency symbol.</P> 1498 </TD> 1499 </TR> 1500 <TR VALIGN=TOP> 1501 <TD WIDTH=431> 1502 <P><B>minicalc/convert/content/cellcurrencychange</B></P> 1503 </TD> 1504 <TD WIDTH=584> 1505 <P><B>Summary</B>: Spreadsheet with 2 columns 10 entries - 1506 Spreadsheet Currency number Format modification test. 1507 </P> 1508 <P><B>Procedure:</B> <BR>Use test file <B>c_cellcurrencychange.sxc</B>. 1509 </P> 1510 <P>Convert c_cellcurrencychange.sxc to c_cellcurrencychange.pdb, 1511 in MiniCalc PDB format. <BR>Start POSE with MiniCalc 1512 application and import c_cellcurrencychange.pdb. <BR>Change 1513 Cell Reference "A1" to have currency format in Danish 1514 Marks (DM). <BR>Export the doc back to 1515 c_cellcurrencychange.pdb. <BR>Merge c_cellcurrencychange.pdb 1516 to c_cellcurrencychange.sxc. 1517 </P> 1518 <P>Select cell A1 = 12 ; then tap pen icon option on palm, choose 1519 Currency from palm listbox, tap on the down arrow to the right of 1520 the flashing cursor, tap on the intended currency type .e.g DM 1521 (Danish Mark) and tap apply & OK. 1522 </P> 1523 <P>Display Sheet : 12 DM. 1524 </P> 1525 <P><B>Expected result:</B> <BR> Spreadsheet entered values or 1526 the sum of each cell should be displayed with specified Currency 1527 symbol, formulae should be visible in the Formula Bar but not the 1528 currency symbol.</P> 1529 </TD> 1530 </TR> 1531 <TR VALIGN=TOP> 1532 <TD WIDTH=431> 1533 <P><B>minicalc/convert/content/cellfloatvalue</B></P> 1534 </TD> 1535 <TD WIDTH=584> 1536 <P><B>Summary</B>: Spreadsheet with 2 columns 6 entries - 1537 Spreadsheet float values. 1538 </P> 1539 <P><B>Procedure:</B> <BR>Use test file <B>c_cellfloatvalue.sxc</B>. 1540 </P> 1541 <P>Convert c_cellfloatvalue.sxc to c_cellfloatvalue.pdb, in 1542 MiniCalc PDB format. <BR>Start POSE with MiniCalc 1543 application and import c_cellfloatvalue.pdb. <BR>Change Cell 1544 Reference "A1" = 11 & "A2" = 2.38 & B3 1545 100.02450 in formula bar. <BR>Export the doc back to 1546 c_cellfloatvalue.pdb. <BR>Merge c_cellfloatvalue.pdb to 1547 c_cellfloatvalue.sxc. 1548 </P> 1549 <P>The original sheet has selected Format -> Cells... -> 1550 Numbers Tab -> & Numbers from the list box, choosen 1551 -1234.12, tho set the Format Code to 0.00 preventing the sheet 1552 display rounding values to two decimal places. It also has 1553 fraction display enabled in certain cells.</P> 1554 <P>Formula Bar : Display Sheet: 1555 </P> 1556 <P>A1 = 11 -> 11.00 1557 </P> 1558 <P>A2 = 2.38 -> 2 19/50 1559 </P> 1560 <P>A3 = 0.45 -> 0.45 1561 </P> 1562 <P>B2 = 0.23 -> 2/9 1563 </P> 1564 <P>B3 = 100.02450 -> 100.02 1565 </P> 1566 <P><B>Expected result:</B> <BR> Spreadsheet fractional & 1567 decimal values should be displayed with specified precision as 1568 stated above, formulae should be visible in the Formula Bar.</P> 1569 </TD> 1570 </TR> 1571 <TR VALIGN=TOP> 1572 <TD WIDTH=431> 1573 <P><B>minicalc/convert/content/cellpercentvalue</B></P> 1574 </TD> 1575 <TD WIDTH=584> 1576 <P><B>Summary</B>: Spreadsheet with 2 columns 3 entries - 1577 Spreadsheet percentage value precision. 1578 </P> 1579 <P><B>Procedure:</B> <BR>Use test file <B>c_cellpercentvalue.sxc</B>. 1580 </P> 1581 <P>Convert c_cellpercentvalue.sxc to c_cellpercentvalue.pdb, in 1582 MiniCalc PDB format. <BR>Start POSE with MiniCalc 1583 application and import c_cellpercentvalue.pdb. <BR>Change 1584 Cell Reference "A1" = 120% & "B1" = 10% in 1585 formula bar. <BR>Export the doc back to 1586 c_cellpercentvalue.pdb. <BR>Merge c_cellpercentvalue.pdb to 1587 c_cellpercentvalue.sxc. 1588 </P> 1589 <P>For cell A1 enter 120% in the Formula Bar. Sheet Display = 1590 120.00% 1591 </P> 1592 <P>For cell B1 enter 10% in the Formula Bar. Sheet Display = 10% 1593 </P> 1594 <P><B>Expected result:</B> <BR> Spreadsheet percentage values 1595 should be displayed with specified precision as stated above, 1596 formulae should be visible in the Formula Bar.</P> 1597 </TD> 1598 </TR> 1599 <TR VALIGN=TOP> 1600 <TD WIDTH=431> 1601 <P><B>minicalc/convert/content/cellstringvalue</B></P> 1602 </TD> 1603 <TD WIDTH=584> 1604 <P><B>Summary</B>: Spreadsheet with 4 columns 11 entries - 1605 Spreadsheet String values. 1606 </P> 1607 <P><B>Procedure:</B> <BR>Use test file <B>c_cellstringvalue.sxc</B>. 1608 </P> 1609 <P>Convert c_cellstringvalue.sxc to c_cellstringvalue.pdb, in 1610 MiniCalc PDB format. <BR>Start POSE with MiniCalc 1611 application and import c_cellstringvalue.pdb. <BR>Change 1612 Cell Reference "C2" = Testing & DELETE contents of 1613 "D2" & insert a ';' in "B3" in formula 1614 bar. <BR>Export the doc back to c_cellstringvalue.pdb. 1615 <BR>Merge c_cellstringvalue.pdb to c_cellstringvalue.sxc. 1616 </P> 1617 <P>A1 = This A2 = With A3 = For 1618 </P> 1619 <P>B1 = Cell B2 = Strings B3 = ; 1620 </P> 1621 <P>C1 = Is C2 = Testing C3 = string values 1622 </P> 1623 <P>D1 = Filled D2 = "blank" 1624 </P> 1625 <P><B>Expected result:</B> <BR> Spreadsheet strings values 1626 should be displayed as stated above.</P> 1627 </TD> 1628 </TR> 1629 <TR VALIGN=TOP> 1630 <TD WIDTH=431> 1631 <P><B>minicalc/convert/content/character</B> <BR> </P> 1632 </TD> 1633 <TD WIDTH=584> 1634 <P><B>Summary</B>: Spreadsheet with 4 columns 23 entries - 1635 Spreadsheet character values. 1636 </P> 1637 <P><B>Procedure:</B> <BR>Use test file <B>c_character.sxc</B>. 1638 </P> 1639 <P>Convert c_character.sxc to c_character.pdb, in MiniCalc PDB 1640 format. <BR>Start POSE with MiniCalc application and import 1641 c_character.pdb. <BR>Change Cell Reference "C7" = 1642 -??%, .i.e appending a % sign. <BR>Export the doc back to 1643 c_character.pdb. <BR>Merge c_character.pdb to 1644 c_character.sxc. 1645 </P> 1646 <P>C7 = -??% 1647 </P> 1648 <P><B>Expected result:</B> <BR> Spreadsheet character values 1649 should be displayed as in original file including minor change 1650 stated above.</P> 1651 </TD> 1652 </TR> 1653 <TR VALIGN=TOP> 1654 <TD WIDTH=431> 1655 <P><B>minicalc/convert/content/cyclic</B> <BR> </P> 1656 </TD> 1657 <TD WIDTH=584> 1658 <P><B>Summary</B>: Spreadsheet with 2 columns 8 entries - 1659 Spreadsheet error messages. 1660 </P> 1661 <P><B>Procedure:</B> <BR>Use test file <B>c_cyclic.sxc</B>. 1662 </P> 1663 <P>Convert c_cyclic.sxc to c_cyclic.pdb, in MiniCalc PDB format. 1664 <BR>Start POSE with MiniCalc application and import c_cyclic.pdb. 1665 <BR>Change Cell Reference "A4" & "A5" = 0 1666 & "B4" = A1/A4, "B5"= A4/A5 in formula 1667 bar. <BR>Export the doc back to c_cyclic.pdb. <BR>Merge 1668 c_cyclic.pdb to c_cyclic.sxc. 1669 </P> 1670 <P>Changes should generate 2 extra errors shown below. 1671 </P> 1672 <P>B4 = Err.503</P> 1673 <P>B5 = #VALUE! 1674 </P> 1675 <P><B>Expected result:</B> <BR> Spreadsheet should display 1676 all original sheet values including 2 extra errors generated by 1677 the changes detailed above.</P> 1678 </TD> 1679 </TR> 1680 <TR VALIGN=TOP> 1681 <TD WIDTH=431> 1682 <P><B>minicalc/convert/content/dividefloating</B> <BR> </P> 1683 </TD> 1684 <TD WIDTH=584> 1685 <P><B>Summary</B>: Spreadsheet with 2 columns 7 entries - 1686 Spreadsheet dividing floating points. 1687 </P> 1688 <P><B>Procedure:</B> <BR>Use test file <B>c_dividefloating.sxc</B>. 1689 </P> 1690 <P>Convert c_dividefloating.sxc to c_dividefloating.pdb, in 1691 MiniCalc PDB format. <BR>Start POSE with MiniCalc 1692 application and import c_dividefloating.pdb. <BR>Change Cell 1693 Reference "A4" = -(12.2)/(5-1) & "B2" = to 1694 be positive, in formula bar. <BR>Export the doc back to 1695 c_dividefloating.pdb. <BR>Merge c_dividefloating.pdb to 1696 c_dividefloating.sxc. 1697 </P> 1698 <P>B2 = 03.050000 1699 </P> 1700 <P>A4 = -03.05</P> 1701 <P>Spreadsheet setting : Format -> Cells... -> Decimal 1702 Places=6, Negative numbers red= TRUE, Leading zero's =2 -> OK. 1703 </P> 1704 <P><B>Expected result:</B> <BR> Spreadsheet should display 1705 all original sheet values and newly entered floating point 1706 division with specified precision & colour, as stated above.</P> 1707 </TD> 1708 </TR> 1709 <TR VALIGN=TOP> 1710 <TD WIDTH=431> 1711 <P><B>minicalc/convert/content/forwardrange</B> <BR> </P> 1712 </TD> 1713 <TD WIDTH=584> 1714 <P><B>Summary</B>: Spreadsheet with 2 columns 4 rows 5 entries - 1715 Spreadsheet tests forwardranging. 1716 </P> 1717 <P><B>Procedure:</B> <BR>Use test file <B>c_forwardrange.sxc</B>. 1718 </P> 1719 <P>Convert c_forwardrange.sxc to c_forwardrange.pdb, in MiniCalc 1720 PDB format. <BR>Start POSE with MiniCalc application and 1721 import c_forwardrange.pdb. <BR>Change Cell Reference "B4" 1722 = IF(0;45.45;54.54), in formula bar. <BR>Export the doc back 1723 to c_forwardrange.pdb. <BR>Merge c_forwardrange.pdb to 1724 c_forwardrange.sxc. 1725 </P> 1726 <P>Changes IF statement to False so ELSE VALUE now valid. 1727 </P> 1728 <P>B4 = 54.54 1729 </P> 1730 <P>A1 = SUM(B2;B4) = B2+B3+B4 =56.23 + 560 + 54.54 = 670.77 1731 </P> 1732 <P><B>Expected result:</B> <BR>Spreadsheet values & the 1733 modified standard formula SUM'sl should be displayed in each cell 1734 on sheet to reflect the changes as stated above, formulae should 1735 be visible in the Formula Bar. </P> 1736 </TD> 1737 </TR> 1738 <TR VALIGN=TOP> 1739 <TD WIDTH=431> 1740 <P><B>minicalc/convert/content/hiddenrow</B> <BR> </P> 1741 </TD> 1742 <TD WIDTH=584> 1743 <P><B>Summary</B>: Spreadsheet with 5 columns 2 rows 9 entries - 1744 Spreadsheet tests hidden row. 1745 </P> 1746 <P><B>Procedure:</B> <BR>Use test file <B>c_hiddenrow.sxc</B>. 1747 </P> 1748 <P>Convert c_hiddenrow.sxc to c_hiddenrow.pdb, in MiniCalc PDB 1749 format. <BR>Start POSE with MiniCalc application and import 1750 c_hiddenrow.pdb. <BR>Select Format -> Row -> Show. 1751 <BR>Export the doc back to c_hiddenrow.pdb. <BR>Merge 1752 c_hiddenrow.pdb to c_hiddenrow.sxc. 1753 </P> 1754 <P>A previously hidden row 2 appears. 1755 </P> 1756 <P><B>Expected result:</B> <BR>Spreadsheet values & standard 1757 formula SUM's should be displayed in each cell on sheet as before 1758 including a new row #2 which reflects the change stated above. </P> 1759 </TD> 1760 </TR> 1761 <TR VALIGN=TOP> 1762 <TD WIDTH=431> 1763 <P><B>minicalc/convert/content/invalidcellref</B> <BR> </P> 1764 </TD> 1765 <TD WIDTH=584> 1766 <P><B>Summary</B>: Spreadsheet with 3 columns 3 rows 8 entries - 1767 Spreadsheet invalid cell references. 1768 </P> 1769 <P><B>Procedure:</B> <BR>Use test file <B>c_invalidcellref.sxc</B>. 1770 </P> 1771 <P>Convert c_invalidcellref.sxc to c_invalidcellref.pdb, in 1772 MiniCalc PDB format. <BR>Start POSE with MiniCalc 1773 application and import c_invalidcellref.pdb. <BR>Change Cell 1774 Reference "A3" = MAX(1;2;3) , "C2" = "blank", 1775 "C3" = a0, in formula bar. <BR>Export the doc back 1776 to c_invalidcellref.pdb. <BR>Merge c_invalidcellref.pdb to 1777 c_invalidcellref.sxc. 1778 </P> 1779 <P>Changes should generate 2 extra errors shown below. 1780 </P> 1781 <P>A3 = 3 1782 </P> 1783 <P>C2 = "blank" 1784 </P> 1785 <P>C3 = #NAME? 1786 </P> 1787 <P><B>Expected result:</B> <BR> Spreadsheet should display 1788 all original sheet values, excpet "C3" which holds new 1789 invalid input warning generated by the change detailed above, 1790 sheet should also show removal of 2 types of invalid input with 1791 valid input replacements "A3" & "C2".</P> 1792 </TD> 1793 </TR> 1794 <TR VALIGN=TOP> 1795 <TD WIDTH=431> 1796 <P><B>minicalc/convert/content/largerange</B> <BR> </P> 1797 </TD> 1798 <TD WIDTH=584> 1799 <P><B>Summary</B>: Spreadsheet with 3 columns 3 rows 8 entries - 1800 Spreadsheet large range test. 1801 </P> 1802 <P><B>Procedure:</B> <BR>Use test file <B>c_largerange.sxc</B>. 1803 </P> 1804 <P>Convert c_largerange.sxc to c_largerange.pdb, in MiniCalc PDB 1805 format. <BR>Start POSE with MiniCalc application and import 1806 c_largerange.pdb. <BR>Change Cell Reference "B3" = 1807 SUM(E7:G10), in formula bar. <BR>Export the doc back to 1808 c_largerange.pdb. <BR>Merge c_largerange.pdb to 1809 c_largerange.sxc. 1810 </P> 1811 <P>Increases the range by an extra row. 1812 </P> 1813 <P>B3 = SUM(E7:G10) = E7+F7+G7+E8+F8+G8+E9+F9+G9+E10+F10+G10 = 1814 </P> 1815 <P>= 4+4+4+2+2+4+1+4+4+1+1+12 = 31 +12 = 43 1816 </P> 1817 <P><B>Expected result:</B> <BR> Spreadsheet should display 1818 all original sheet values, except "B3" which holds new 1819 larger range standard formula SUM generated by the change detailed 1820 above.</P> 1821 </TD> 1822 </TR> 1823 <TR VALIGN=TOP> 1824 <TD WIDTH=431> 1825 <P><B>minicalc/convert/content/listrange</B> <BR> </P> 1826 </TD> 1827 <TD WIDTH=584> 1828 <P><B>Summary</B>: Spreadsheet with 5 columns 4 rows 20 entries - 1829 Spreadsheet listrange test. 1830 </P> 1831 <P><B>Procedure:</B> <BR>Use test file <B>c_listrange.sxc</B>. 1832 1833 </P> 1834 <P>Convert c_listrange.sxc to c_listrange.pdb, in MiniCalc PDB 1835 format. <BR>Start POSE with MiniCalc application and import 1836 c_listrange.pdb. <BR>Change Cell Reference "D3" = 1837 24, in formula bar. <BR>Export the doc back to 1838 c_listrange.pdb. <BR>Merge c_listrange.pdb to 1839 c_listrange.sxc. 1840 </P> 1841 <P>D3 = 24 1842 </P> 1843 <P>A4 = SUM(A1:A3) = 256.1 1844 </P> 1845 <P>B4 = AVERAGE(A1:A3) = 17.07 1846 </P> 1847 <P>C4 = AVERAGE(A4:B4) = AVERAGE( 256.1+17.07) = 136.59 1848 </P> 1849 <P>D4 = AVERAGE(D1;D2;D3) = AVERAGE( 13.1+18+24) = 18.37 1850 </P> 1851 <P>E5 = SUM(A4:B4:C4:D4) = (256.1+17.07+136.59+18.37) = 428.13<BR> 1852 <BR> <BR> 1853 </P> 1854 <P><B>Expected result:</B> <BR> Spreadsheet should display 1855 all original sheet values, except cells "A4-E4" which 1856 hold the modified standard formula SUM & AVERAGE value's 1857 generated by the change in D3 detailed above.</P> 1858 </TD> 1859 </TR> 1860 <TR VALIGN=TOP> 1861 <TD WIDTH=431> 1862 <P><B>minicalc/convert/content/mathematical</B> <BR> </P> 1863 </TD> 1864 <TD WIDTH=584> 1865 <P><B>Summary</B>: Spreadsheet with 5 columns 3 rows 15 entries - 1866 Spreadsheet stanadard math functs test in (Rad). 1867 </P> 1868 <P><B>Procedure:</B> <BR>Use test file <B>c_mathematical.sxc</B>. 1869 1870 </P> 1871 <P>Convert c_mathematical.sxc to c_mathematical.pdb, in MiniCalc 1872 PDB format. <BR>Start POSE with MiniCalc application and 1873 import c_mathematical.pdb. <BR>Change Cell Reference "B1" 1874 = SIN(3.14/2), "B2" =COS(0), "C3"= TAN(1.57/2) 1875 in formula bar. <BR>Export the doc back to 1876 c_mathematical.pdb. <BR>Merge c_mathematical.pdb to 1877 c_mathematical.sxc. 1878 </P> 1879 <P>B1 = 1</P> 1880 <P>B2 = 1 1881 </P> 1882 <P>C3 =1 1883 </P> 1884 <P><B>Expected result:</B> <BR> Spreadsheet should display 1885 all original sheet values except cells "B1,B2,C3" which 1886 hold modified sin,cos & tan value's generated by the changes 1887 stated above.</P> 1888 </TD> 1889 </TR> 1890 <TR VALIGN=TOP> 1891 <TD WIDTH=431> 1892 <P><B>minicalc/convert/content/protection</B> <BR> </P> 1893 </TD> 1894 <TD WIDTH=584> 1895 <P><B>Summary</B>: Spreadsheet with 1 column 3 rows 3 entries - 1896 Spreadsheet protection test. 1897 </P> 1898 <P><B>Procedure:</B> <BR>Use test file <B>c_protection.sxc</B>. 1899 1900 </P> 1901 <P>Convert c_protection.sxc to c_protection.pdb, in MiniCalc PDB 1902 format. <BR>Start POSE with MiniCalc application and import 1903 c_protection.pdb. <BR>Attempt to Change Cell Reference "A1" 1904 either directly or in formula bar from the value 12 to 1. 1905 <BR>Export the doc back to c_protection.pdb. <BR>Merge 1906 c_protection.pdb to c_protection.sxc. 1907 </P> 1908 <P>User should be unable to change cell contents, popup error 1909 message "Protected cells can not be modified" should 1910 appear. 1911 </P> 1912 <P>This is because the Tools -> Protect Document -> Sheet 1913 option has been enabled with a password and therefore all cells on 1914 sheet are write protected. 1915 </P> 1916 <P><B>Expected result:</B> <BR> Spreadsheet should display 1917 all original sheet values.</P> 1918 </TD> 1919 </TR> 1920 <TR VALIGN=TOP> 1921 <TD WIDTH=431> 1922 <P><B>minicalc/convert/content/renamedsheet</B> <BR> </P> 1923 </TD> 1924 <TD WIDTH=584> 1925 <P><B>Summary</B>: Spreadsheet with 3 sheets 0 entries - 1926 Spreadsheet rename test. 1927 </P> 1928 <P><B>Procedure:</B> <BR>Use test file <B>c_renamedsheet.sxc</B>. 1929 1930 </P> 1931 <P>Convert c_renamedsheet.sxc to c_renamedsheet.pdb, in MiniCalc 1932 PDB format. <BR>Start POSE with MiniCalc application and 1933 import c_renamedsheet.pdb. <BR>Change sheet named "testplan" 1934 to "renamed". <BR>Export the doc back to 1935 c_renamedsheet.pdb. <BR>Merge c_renamedsheet.pdb to 1936 c_renamedsheet.sxc. 1937 </P> 1938 <P>Click on "testplan" sheet tab, and using 3<SUP>rd</SUP> 1939 mouse button, choose Rename..., from popup menu, enter new sheet 1940 name & OK. 1941 </P> 1942 <P>OR choose Format -> Sheet -> Rename... enter new sheet 1943 name & OK. 1944 </P> 1945 <P><B>Expected result:</B> <BR> Spreadsheet should display 1946 all original sheets & names, with the exception of the 1947 "testplan" sheet which should now be labelled "renamed" 1948 .</P> 1949 </TD> 1950 </TR> 1951 <TR VALIGN=TOP> 1952 <TD WIDTH=431> 1953 <P><B>minicalc/convert/content/sheetreference</B></P> 1954 </TD> 1955 <TD WIDTH=584> 1956 <P><B>Summary</B>: Spreadsheet with 3 sheets 4 columns 4 rows 11 1957 entries - Spreadsheet sheetreference test. 1958 </P> 1959 <P><B>Procedure:</B> <BR>Use test file <B>c_sheetreference.sxc</B>. 1960 1961 </P> 1962 <P>Convert c_sheetreference.sxc to c_sheetreference.pdb, in 1963 MiniCalc PDB format. <BR>Start POSE with MiniCalc 1964 application and import c_sheetreference.pdb. <BR>Change Cell 1965 Reference "A3" = Sheet3.B1. <BR>Export the doc 1966 back to c_sheetrefernce.pdb. <BR>Merge c_sheetreference.pdb 1967 to c_sheetreference.sxc. 1968 </P> 1969 <P>A3 = 3. 1970 </P> 1971 <P>B4 =26.</P> 1972 <P><B>Expected result:</B> <BR> Spreadsheet should display 1973 all original value's & formulae as in original file, except 1974 cells "A3"& "A4" which should display a 1975 different sheet reference value and the modified sheet reference 1976 formula, reflecting the changes stated above.</P> 1977 </TD> 1978 </TR> 1979 <TR VALIGN=TOP> 1980 <TD WIDTH=431> 1981 <P><B>minicalc/convert/content/smallrange</B> <BR> </P> 1982 </TD> 1983 <TD WIDTH=584> 1984 <P><B>Summary</B>: Spreadsheet with 4 columns 3 rows 10 entries - 1985 Spreadsheet small range test. 1986 </P> 1987 <P><B>Procedure:</B> <BR>Use test file <B>c_smallrange.sxc</B>. 1988 1989 </P> 1990 <P>Convert c_smallrange.sxc to c_smallrange.pdb, in MiniCalc PDB 1991 format. <BR>Start POSE with MiniCalc application and import 1992 c_smallrange.pdb. <BR>Change Cell Reference "B3" = 1993 AVERAGE(A1:B2), in formula bar. <BR>Export the doc back to 1994 c_smallrange.pdb. <BR>Merge c_smallrange.pdb to 1995 c_smallrange.sxc. 1996 </P> 1997 <P>Decrease the range by 1 row. 1998 </P> 1999 <P>B3 = AVERAGE(A1:B2) = (1+2+3+3)/4 = 2.25 2000 </P> 2001 <P><B>Expected result:</B> <BR> Spreadsheet should display 2002 all original sheet values, except "A3" which now holds 2003 average value of new smaller range generated by the change 2004 detailed above.</P> 2005 </TD> 2006 </TR> 2007 <TR VALIGN=TOP> 2008 <TD WIDTH=431> 2009 <P><B>minicalc/convert/content/cancel</B><BR> </P> 2010 </TD> 2011 <TD WIDTH=584> 2012 <P><B>Summary</B>: Spreadsheet with 1 columns 4 rows 4entries - 2013 Spreadsheet palm confirm &cancel test. 2014 </P> 2015 <P><B>Procedure:</B> <BR>Use test file <B>c_cancel.sxc</B>. 2016 </P> 2017 <P>Convert c_cancel.sxc to c_cancel.pdb, in MiniCalc PDB format. 2018 <BR>Start POSE with MiniCalc application and import c_cancel.pdb. 2019 <BR>Select with mouse Cell Reference "A2" on dotted line 2020 on palm type 14, tap “TICK” option (leftmost option on 2021 palm) to confirm, repeat this step this time Changing Cell 2022 Reference “A2” = 1, except this time tap the “X” 2023 option to cancel. <BR>Export the doc back to c_cancel.pdb. 2024 <BR>Merge c_cancel.pdb to c_cancel.sxc. 2025 </P> 2026 <P>A2 = 14. 2027 </P> 2028 <P><B>Expected result:</B> <BR> Spreadsheet should display 2029 all original sheet values, except "A2" which now holds 2030 the value 14 generated by the change detailed above.</P> 2031 </TD> 2032 </TR> 2033 <TR VALIGN=TOP> 2034 <TD WIDTH=431> 2035 <P><B>minicalc/convert/content/cut&paste</B><BR> </P> 2036 </TD> 2037 <TD WIDTH=584> 2038 <P><B>Summary</B>: Spreadsheet with 1 columns 4 rows 4entries - 2039 Spreadsheet palm cut&paste test. 2040 </P> 2041 <P><B>Procedure:</B> <BR>Use test file <B>c_cut&paste.sxc</B>. 2042 2043 </P> 2044 <P>Convert c_cut&paste.sxc to c_cut&paste.pdb, in MiniCalc 2045 PDB format. <BR>Start POSE with MiniCalc application and 2046 import c_cut&paste.pdb. <BR>Choose Cell Reference "A2" 2047 with mouse, tap cut option on palm, choose Cell Reference “A5” 2048 and tap paste option. <BR>Export the doc back to 2049 c_cut&paste.pdb. <BR>Merge c_cut&paste.pdb to 2050 c_cut&paste.sxc. 2051 </P> 2052 <P>A2 = “blank”.</P> 2053 <P>A5 = 14. 2054 </P> 2055 <P><B>Expected result:</B> <BR> Spreadsheet should display 2056 all original sheet values, except "A2" & “A5” 2057 which now holds the values blank & 14 resp. generated by the 2058 changes detailed above.</P> 2059 </TD> 2060 </TR> 2061 <TR VALIGN=TOP> 2062 <TD WIDTH=431> 2063 <P><B>minicalc/convert/content/copy&paste</B><BR> </P> 2064 </TD> 2065 <TD WIDTH=584> 2066 <P><B>Summary</B>: Spreadsheet with 1 columns 4 rows 4entries - 2067 Spreadsheet palm copy&paste test. 2068 </P> 2069 <P><B>Procedure:</B> <BR>Use test file <B>c_copy&paste.sxc</B>. 2070 2071 </P> 2072 <P>Convert c_copy&paste.sxc to c_copy&paste.pdb, in 2073 MiniCalc PDB format. <BR>Start POSE with MiniCalc 2074 application and import c_copy&paste.pdb. <BR>Choose Cell 2075 Reference "A5" with mouse, tap copy option on palm, 2076 choose Cell Reference “A2” and tap paste option. 2077 <BR>Export the doc back to c_copy&paste.pdb. <BR>Merge 2078 c_copy&paste.pdb to c_copy&paste.sxc. 2079 </P> 2080 <P>A2 = 14.</P> 2081 <P>A5 = 14. 2082 </P> 2083 <P><B>Expected result:</B> <BR> Spreadsheet should display 2084 all original sheet values, except "A2" which now holds 2085 the value 14 generated by the change detailed above.</P> 2086 </TD> 2087 </TR> 2088 <TR VALIGN=TOP> 2089 <TD WIDTH=431> 2090 <P><B>minicalc/convert/content/textentry</B><BR> </P> 2091 </TD> 2092 <TD WIDTH=584> 2093 <P><B>Summary</B>: Spreadsheet with 1 columns 4 rows 4entries - 2094 Spreadsheet palm text entry test. 2095 </P> 2096 <P><B>Procedure:</B> <BR>Use test file <B>c_textentry.sxc</B>. 2097 2098 </P> 2099 <P>Convert c_textentry.sxc to c_textentry.pdb, in MiniCalc PDB 2100 format. <BR>Start POSE with MiniCalc application and import 2101 c_textentry.pdb. <BR>Choose Cell Reference "A1" 2102 with mouse, tap textentry option on palm, type the following text 2103 string into the popup text box “This is a MiniCalc text 2104 entry test.”.<BR>Export the doc back to c_textentry.pdb. 2105 <BR>Merge c_textentry.pdb to c_textentry.sxc. 2106 </P> 2107 <P>A1 = “This is a MiniCalc text entry test.”</P> 2108 <P><B>Expected result:</B> <BR> Spreadsheet should display 2109 all original sheet values, except "A1" which now holds 2110 the string “This is a MiniCalc text entry test”, 2111 generated by the change detailed above.</P> 2112 </TD> 2113 </TR> 2114 <TR VALIGN=TOP> 2115 <TD WIDTH=431> 2116 <P><B>minicalc/convert/content/function</B><BR> </P> 2117 </TD> 2118 <TD WIDTH=584> 2119 <P><B>Summary</B>: Spreadsheet with 1 columns 4 rows 4entries - 2120 Spreadsheet palm function test. 2121 </P> 2122 <P><B>Procedure:</B> <BR>Use test file <B>c_function.sxc</B>. 2123 2124 </P> 2125 <P>Convert c_function.sxc to c_function.pdb, in MiniCalc PDB 2126 format. <BR>Start POSE with MiniCalc application and import 2127 c_function.pdb. <BR>Choose Cell Reference "A1" 2128 with mouse, tap standard function option on palm, choose the 2129 function AVERAGE from the popup list by tapping, type the values 2130 “1;2;3” between the function brackets on the dotted 2131 line were the cursor is placed and press return.<BR>Export the doc 2132 back to c_function.pdb. <BR>Merge c_function.pdb to 2133 c_function.sxc. 2134 </P> 2135 <P>A1 = AVERAGE(1;2;3) = 2.</P> 2136 <P><B>Expected result:</B> <BR> Spreadsheet should display 2137 all original sheet values, except "A1" which now holds 2138 the result of the average function given args (1;2;3) = 2 2139 generated by the change detailed above.</P> 2140 </TD> 2141 </TR> 2142 <TR VALIGN=TOP> 2143 <TD WIDTH=431> 2144 <P><B>minicalc/convert/content/numberpad</B><BR> </P> 2145 </TD> 2146 <TD WIDTH=584> 2147 <P><B>Summary</B>: Spreadsheet with 1 columns 4 rows 4entries - 2148 Spreadsheet palm numberpad test. 2149 </P> 2150 <P><B>Procedure:</B> <BR>Use test file <B>c_numberpad.sxc</B>. 2151 2152 </P> 2153 <P>Convert c_numberpad.sxc to c_numberpad.pdb, in MiniCalc PDB 2154 format. <BR>Start POSE with MiniCalc application and import 2155 c_numberpad.pdb. <BR>Choose Cell Reference "A1" 2156 with mouse, tap the “123” option on the palm, tap 2157 “->”, “=”, “5-0+2” from 2158 popup numberpad, and press return.<BR>Export the doc back to 2159 c_numberpad.pdb. <BR>Merge c_numberpad.pdb to 2160 c_numberpad.sxc. 2161 </P> 2162 <P>A1 = 5-0+2 = 7.</P> 2163 <P><B>Expected result:</B> <BR> Spreadsheet should display 2164 all original sheet values, except "A1" which now holds 2165 the result of the formula 5-0+2, generated by the change detailed 2166 above.</P> 2167 </TD> 2168 </TR> 2169 <TR VALIGN=TOP> 2170 <TD WIDTH=431> 2171 <P><B>minicalc/convert/content/math_funcs</B></P> 2172 </TD> 2173 <TD WIDTH=584> 2174 <P><B>Summary</B>: Spreadsheet with 1 columns 4 rows 4entries - 2175 Spreadsheet palm numberpad test. 2176 </P> 2177 <P><B>Procedure:</B> <BR>Use test file <B>c_math_funcs.sxc</B>. 2178 2179 </P> 2180 <P>Convert c_math_funcs.sxc to c_math_funcs.pdb, in MiniCalc PDB 2181 format. <BR>Start POSE with MiniCalc application and import 2182 c_math_funcs.pdb. <BR>Choose the Cell References below with 2183 mouse,and for each type on the palm the corresponding entry before 2184 pressing return.</P> 2185 <P>A1 = <BR>Export the doc back to c_math_funcs.pdb. <BR>Merge 2186 c_math_funcs.pdb to c_math_funcs.sxc. 2187 </P> 2188 <P>A1 = .</P> 2189 <P>A2 =</P> 2190 <P>A3 = 2191 </P> 2192 <P>A4 =</P> 2193 <P><BR><BR> 2194 </P> 2195 <P><B>Expected result:</B> <BR> Spreadsheet should display 2196 all original sheet values, except "A1" which now holds 2197 the result of the formula 5-0+2, generated by the change detailed 2198 above.</P> 2199 </TD> 2200 </TR> 2201 <TR VALIGN=TOP> 2202 <TD WIDTH=431> 2203 <P><B>minicalc/convert/content/insertrow</B><BR> </P> 2204 </TD> 2205 <TD WIDTH=584> 2206 <P><B>Summary</B>: Spreadsheet with 1 columns 4 rows 4entries - 2207 Spreadsheet palm insert row test. 2208 </P> 2209 <P><B>Procedure:</B> <BR>Use test file <B>c_insertrow.sxc</B>. 2210 2211 </P> 2212 <P>Convert c_insertrow.sxc to c_insertrow.pdb, in MiniCalc PDB 2213 format. <BR>Start POSE with MiniCalc application and import 2214 c_insertrow.pdb. </P> 2215 <P><BR>Select Cell Reference "A3" with mouse, tap the 2216 side bar of the spreadsheet at position 3 on the palm, tap 2217 “Insert” from popup menu, and press return. Select the 2218 newly inserted Cell Reference with mouse and enter the number “2”, 2219 press return.<BR><BR><BR> 2220 </P> 2221 <P>Export the doc back to c_insertrow.pdb. <BR>Merge 2222 c_insertrow.pdb to c_insertrow.sxc. 2223 </P> 2224 <P>A1 = .</P> 2225 <P><B>Expected result:</B> <BR> Spreadsheet should display 2226 all original sheet values, except "A1" which now holds 2227 the result of the formula 5-0+2, generated by the change detailed 2228 above.</P> 2229 </TD> 2230 </TR> 2231 <TR VALIGN=TOP> 2232 <TD WIDTH=431> 2233 <P><B>minicalc/convert/content/multi_boolean</B></P> 2234 </TD> 2235 <TD WIDTH=584> 2236 <P><B>Summary</B>: Spreadsheet with 1 column 8 entries - 2237 Spreadsheet multi boolean entry. 2238 </P> 2239 <P><B>Procedure:</B> <BR>Use test file <B>c_multi_boolean.sxc</B>. 2240 2241 </P> 2242 <P>Convert c_multi_boolean.sxc to c_multi_boolean.pdb, in MiniCalc 2243 PDB format. <BR>Start POSE with MiniCalc application and 2244 import c_multi_boolean.pdb. <BR>Export the doc back to 2245 c_multi_boolean.pdb. <BR>Merge c_multi_boolean.pdb to 2246 c_multi_boolean.sxc. 2247 </P> 2248 <P>Logical Funtion test : cells A1-A4: 2249 </P> 2250 <P>A1-A4 = FALSE 2251 </P> 2252 <P>A5-A8 = TRUE 2253 </P> 2254 <P>Returns 4 logical FALSE & TRUE values resp.. 2255 </P> 2256 <P><B>Expected result:</B> <BR> The logical entry of each 2257 cell should be displayed on the sheet as stated above.</P> 2258 </TD> 2259 </TR> 2260 <TR VALIGN=TOP> 2261 <TD WIDTH=431> 2262 <P><BR> 2263 </P> 2264 </TD> 2265 <TD WIDTH=584> 2266 <P><BR> 2267 </P> 2268 </TD> 2269 </TR> 2270</TABLE> 2271<P><BR> <BR> <BR> 2272</P> 2273</BODY> 2274</HTML>