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