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