| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> |
| <!--*********************************************************** |
| * |
| * Licensed to the Apache Software Foundation (ASF) under one |
| * or more contributor license agreements. See the NOTICE file |
| * distributed with this work for additional information |
| * regarding copyright ownership. The ASF licenses this file |
| * to you under the Apache License, Version 2.0 (the |
| * "License"); you may not use this file except in compliance |
| * with the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| * |
| ***********************************************************--> |
| <HTML> |
| <HEAD> |
| <META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=iso-8859-1"> |
| <TITLE></TITLE> |
| <META NAME="GENERATOR" CONTENT="StarOffice 6.0 (Solaris Sparc)"> |
| <META NAME="AUTHOR" CONTENT="dermot mccluskey"> |
| <META NAME="CREATED" CONTENT="20011001;14124200"> |
| <META NAME="CHANGED" CONTENT="20020103;15592900"> |
| <STYLE> |
| <!-- |
| P.text-body-indent { margin-left: 0.5cm } |
| --> |
| </STYLE> |
| </HEAD> |
| <BODY> |
| <H1 ALIGN=CENTER>Xmerge Test Spec</H1> |
| <H2>1.0 Intorduction</H2> |
| <BLOCKQUOTE>This document outlines the tests to be performed on |
| Xmerge, the XML-to-PDB converter for the SunONE Webtop.</BLOCKQUOTE> |
| <H2>1.1 Authors</H2> |
| <UL> |
| <LI><P STYLE="margin-bottom: 0cm">Dermot McCluskey |
| (dermot.mccluskey@sun.com) |
| </P> |
| <LI><P>Keelin Boyle (keelin.boyle@sun.com) |
| </P> |
| </UL> |
| <H2>1.2 Project/Product Identifier</H2> |
| <BLOCKQUOTE>XMerge</BLOCKQUOTE> |
| <H2>1.3 Reision History</H2> |
| <P STYLE="margin-bottom: 0cm"> |
| </P> |
| <TABLE COLS=4 WIDTH=100% BORDER=1 CELLPADDING=2 CELLSPACING=0> |
| <TR> |
| <TD> |
| <P><B>Date</B></P> |
| </TD> |
| <TD> |
| <P><B>Revision</B></P> |
| </TD> |
| <TD> |
| <P><B>Comments</B></P> |
| </TD> |
| <TD> |
| <P><B>Approval</B></P> |
| </TD> |
| </TR> |
| <TR> |
| <TD> |
| <P>28-Sep-2001</P> |
| </TD> |
| <TD> |
| <P>0.3</P> |
| </TD> |
| <TD> |
| <P>Draft 3.</P> |
| </TD> |
| <TD></TD> |
| </TR> |
| <TR> |
| <TD></TD> |
| <TD></TD> |
| <TD></TD> |
| <TD></TD> |
| </TR> |
| </TABLE> |
| <H2>1.4 Document Customers</H2> |
| <UL> |
| <LI><P STYLE="margin-bottom: 0cm">XMerge Development team |
| </P> |
| <LI><P STYLE="margin-bottom: 0cm">Ireland Desktop Test team |
| </P> |
| <LI><P>SunONE Webtop C-team |
| </P> |
| </UL> |
| <H2>1.5 References</H2> |
| <H2>2.0 Requirements & Dependencies</H2> |
| <BLOCKQUOTE>Successful automation of the tests outlined in this |
| specification is dependent on the stability and reliability of the |
| POSE emulator and the EmRPC Perl module that allows test |
| automation. There is a risk associated with this in that |
| the emulator software may not accurately emulate every aspect of the |
| PalmOS and so the automated tests may not discover bugs which occur |
| in "real world" scenarios. Also, if the automation |
| software we use proves not to be reliable enough to consistently |
| return the same test results, then the effort spent creating the test |
| automation scripts will not be worthwhile. |
| </BLOCKQUOTE> |
| <BLOCKQUOTE>Verification of test results will depend on the usability |
| of the Java-based Comparator applications, developed by the US Webtop |
| QA team, which will be used to compare the output XML and |
| PDB files with the expected results. |
| </BLOCKQUOTE> |
| <BLOCKQUOTE>Many of the tests described in this specification are |
| very time consuming and it would not be practical to execute them |
| manually on a regular basis.</BLOCKQUOTE> |
| <H2>2.1Required Tools & Technologies</H2> |
| <UL> |
| <LI><P STYLE="margin-bottom: 0cm">PalmOS Emulator (POSE) |
| </P> |
| <LI><P STYLE="margin-bottom: 0cm">EmRPC Perl module and Test Driver |
| harness |
| </P> |
| <LI><P STYLE="margin-bottom: 0cm">Comparator applications (XML and |
| PDB comparison utilities) |
| </P> |
| <LI><P STYLE="margin-bottom: 0cm">Palm V device ??? |
| </P> |
| <LI><P>StarOffice 6.X. |
| </P> |
| </UL> |
| <H2>2.2 Test Framework Used</H2> |
| <BLOCKQUOTE>These tests are to be automated using the POSE emulator |
| and the Test Driver developed by the XMerge team, which interacts |
| with the EmRPC module and allows test engineers to write test scripts |
| to control the conversion of documents and the interaction with the |
| POSE emulator. Using this software, it is possible to automate |
| the process of loading documents into the appropriate Palm |
| application, apply edits to the document within the Palm emulator and |
| export the document.</BLOCKQUOTE> |
| <H2>3.0 Scope of Work</H2> |
| <H2>4.0 Test Strategy</H2> |
| <H2>4.1Test Suite Location</H2> |
| <H2>4.2 Strategy overview</H2> |
| <H2>4.3 Test Cases and Assertions</H2> |
| <H2>4.4 Testing Not Performed</H2> |
| <UL> |
| <LI><P STYLE="margin-bottom: 0cm">Performance Testing |
| </P> |
| <LI><P>Internationalization (I18N) related testing. |
| </P> |
| </UL> |
| <H2>5.0 Test Cases</H2> |
| <BLOCKQUOTE>The test cases are divided into seperate sections for |
| each PDB format supported by XMerge, and further divided into |
| Convert and Merge tests within each format. The Convert tests |
| validate that XMerge can perform the round trip conversion from |
| StarOffice XML-based file format to PalmOS PDB format and back to |
| StarOffice XML format again, without any loss of content. The |
| Merge tests validate that XMerge can merge edits made on the Palm |
| device with the original StarOffice XML file, while retaining any |
| information in the original document which could not to translated |
| into PDB format, eg embedded tables. |
| </BLOCKQUOTE> |
| <BLOCKQUOTE>Each section is further divided into Content and Style |
| tests. The Content tests deal with the ability of XMerge to |
| retain all the meaningful content, eg text, after the conversion and |
| merging process. The Style tests deal with the ability of |
| XMerge to retain the stylistic details, eg bold face; justification; |
| line breaks, from the same round-trip conversion. The |
| Content-retaining functionality is considered of much higher priority |
| than the Style-retaining functionality in version 1.1. <BR> </BLOCKQUOTE> |
| <H2>5.1 AportisDoc Tests</H2> |
| <H2>5.1.1 AportisDoc Convert Tests</H2> |
| <H2>5.1.1.1 AportisDoc Convert Content Tests</H2> |
| <TABLE WIDTH=100% BORDER=1 CELLPADDING=2 CELLSPACING=0> |
| <TR VALIGN=TOP> |
| <TD WIDTH=30%> |
| <P><BR> |
| </P> |
| </TD> |
| <TD> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD> |
| <P><BR> |
| </P> |
| </TD> |
| <TD> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| </TABLE> |
| <H2>5.1.1.2 AportisDoc Convert Style Tests</H2> |
| <P><BR> |
| </P> |
| <H2>5.1.2 Aportis Merge Tests</H2> |
| <H2>5.1.2.1 AportisDoc Merge Content Tests</H2> |
| <TABLE WIDTH=100% BORDER=1 CELLPADDING=2 CELLSPACING=0> |
| <COL WIDTH=77*> |
| <COL WIDTH=179*> |
| <TR VALIGN=TOP> |
| <TD WIDTH=30%> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=70%> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=30%> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=70%> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=30%> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=70%> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| </TABLE> |
| <H2>5.1.2.2 AportisDoc Merge Style Tests</H2> |
| <TABLE WIDTH=100% BORDER=1 CELLPADDING=2 CELLSPACING=0> |
| <COL WIDTH=72*> |
| <COL WIDTH=184*> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/merge/style/animatedgif</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with an embedded image – |
| straight forward convert and merge</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_animatedgif.sxw</B>. |
| </P> |
| <P>Convert a_animatedgif.sxw to a_animatedgif.pdb, in AportisDoc |
| PDB format. <BR>Start POSE with AportisDoc application and import |
| a_animatedgif.pdb. <BR>Export the doc back to a_animatedgif.pdb. |
| <BR>Merge a_animatedgif.pdb and the original document to |
| a_animatedgif.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <BLOCKQUOTE>This document has a animated gif embedded in it.</BLOCKQUOTE> |
| <BLOCKQUOTE>Start of animated gif.</BLOCKQUOTE> |
| <BLOCKQUOTE><Image of spinning globe></BLOCKQUOTE> |
| <BLOCKQUOTE>End of animated gif. |
| </BLOCKQUOTE> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/content/style/bolddoc</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with bold type and varying font – |
| straight forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_bolddoc.sxw</B>. |
| </P> |
| <P>Convert a_bolddoc.sxw to a_bolddoc.pdb, in AportisDoc PDB |
| format. <BR>Start POSE with AportisDoc application and import |
| a_bolddoc.pdb. <BR>Export the doc back to a_bolddoc.pdb. <BR>Merge |
| a_bolddoc.pdb and the original document to a_bolddoc.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <BLOCKQUOTE><STRONG>This complete line is in <FONT SIZE=6 STYLE="font-size: 22pt">bold</FONT> |
| with font set to Times New Roman. The word bold is of size 22, |
| while rest of the words are of size 12. </STRONG> |
| </BLOCKQUOTE> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/merge/style/bookmarks</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with inserted bookmarks – |
| straight forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_bookmarks.sxw</B>. |
| </P> |
| <P>Convert a_bookmarks.sxw to a_bookmarks.pdb, in AportisDoc PDB |
| format. <BR>Start POSE with AportisDoc application and import |
| a_bookmarks.pdb. <BR>Export the doc back to a_bookmarks.pdb. |
| <BR>Merge a_bookmarks.pdb and the original document to |
| a_bookmarks.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <BLOCKQUOTE>Two paragraphes of text with 2 bookmarks set. To |
| identify bookmarks, select Edit -> Navigator and bookmarks, |
| user should see BK1 and BK2 and clicking on these labels in the |
| navigator popup places the cursor in the position of the original |
| bookmark, .i.e. |
| </BLOCKQUOTE> |
| <BLOCKQUOTE>BK1 = Bookmark|</BLOCKQUOTE> |
| <BLOCKQUOTE>BK2 = Silicon |
| </BLOCKQUOTE> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/merge/style/bulletorderedlist</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with bulletorderedlist – |
| straight forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_bulletorderedlist.sxw</B>. |
| </P> |
| <P>Convert a_bulletorderedlist.sxw to a_bulletorderedlist.pdb, in |
| AportisDoc PDB format. <BR>Start POSE with AportisDoc application |
| and import a_bulletorderedlist.pdb. <BR>Export the doc back to |
| a_bulletorderedlist.pdb. <BR>Merge a_bulletorderedlist.pdb and the |
| original document to a_bulletorderedlist.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <P STYLE="margin-bottom: 0cm; font-style: normal">This document is |
| an example of a simple bullet ordered list.</P> |
| <P STYLE="margin-bottom: 0cm"><BR> |
| </P> |
| <UL> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Bullet 1</P> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Bullet 2</P> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Bullet 3</P> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Bullet 4</P> |
| </UL> |
| <P STYLE="margin-bottom: 0cm"><BR> |
| </P> |
| <BLOCKQUOTE STYLE="font-style: normal">End of bullet Ordered list.</BLOCKQUOTE> |
| <BLOCKQUOTE><BR> |
| </BLOCKQUOTE> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/content/style/emptydoc</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: empty document – straight forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_emptydoc.sxw</B>. |
| </P> |
| <P>Convert a_emptydoc.sxw to a_emptydoc.pdb, in AportisDoc PDB |
| format. <BR>Start POSE with AportisDoc application and import |
| a_emptydoc.pdb. <BR>Export the doc back to a_emptydoc.pdb. <BR>Merge |
| a_emptydoc.pdb and the original document to a_emptydoc.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <BLOCKQUOTE><STRONG><empty document>. </STRONG> |
| </BLOCKQUOTE> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/merge/style/firstlineindent</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with line indent – straight |
| forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_firstlineindent.sxw</B>. |
| </P> |
| <P>Convert a_firstlineindent.sxw to a_firstlineindent.pdb, in |
| AportisDoc PDB format. <BR>Start POSE with AportisDoc application |
| and import a_firstlineindent.pdb. <BR>Export the doc back to |
| a_firstlineindent.pdb. <BR>Merge a_firstlineindent.pdb and the |
| original document to a_firstlineindent.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <BLOCKQUOTE>This line is using First Line indent style. Now isnt |
| that Kool... Also Im running short of words to say here, to wrap |
| this particular sentence.</BLOCKQUOTE> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/content/style/fontsize</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with varying font size – |
| straight forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_fontsize.sxw</B>. |
| </P> |
| <P>Convert a_fontsize.sxw to a_fontsize.pdb, in AportisDoc PDB |
| format. <BR>Start POSE with AportisDoc application and import |
| a_fontsize.pdb. <BR>Export the doc back to a_fontsize.pdb. <BR>Merge |
| a_fontsize.pdb and the original document to a_fontsize.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <BLOCKQUOTE>Text with font size 10, 16, 20, 40, 96.</BLOCKQUOTE> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/content/style/heading</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with heading type style – |
| straight forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_heading.sxw</B>. |
| </P> |
| <P>Convert a_heading.sxw to a_heading.pdb, in AportisDoc PDB |
| format. <BR>Start POSE with AportisDoc application and import |
| a_heading.pdb. <BR>Export the doc back to a_heading.pdb. <BR>Merge |
| a_heading.pdb and the original document to a_heading.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <P STYLE="margin-top: 0.42cm; page-break-after: avoid"><FONT FACE="Times New Roman, serif"><FONT SIZE=4>This |
| piece of text is in Heading paragraph style.</FONT></FONT></P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/content/style/heading1</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with heading1 type style – |
| straight forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_heading1.sxw</B>. |
| </P> |
| <P>Convert a_heading1.sxw to a_heading1.pdb, in AportisDoc PDB |
| format. <BR>Start POSE with AportisDoc application and import |
| a_heading1.pdb. <BR>Export the doc back to a_heading1.pdb. <BR>Merge |
| a_heading1.pdb and the original document to a_heading1.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <H1 STYLE="font-weight: medium">This piece of text is in Heading1 |
| paragraph style</H1> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/content/style/heading2</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with heading2 type style – |
| straight forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_heading2.sxw</B>. |
| </P> |
| <P>Convert a_heading2.sxw to a_heading2.pdb, in AportisDoc PDB |
| format. <BR>Start POSE with AportisDoc application and import |
| a_heading2.pdb. <BR>Export the doc back to a_heading2.pdb. <BR>Merge |
| a_heading2.pdb and the original document to a_heading2.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <H2>This document is set in Heading2 style.</H2> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/content/style/hyperlink</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with embedded hyperlink – |
| straight forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_hyperlink.sxw</B>. |
| </P> |
| <P>Convert a_hyperlink.sxw to a_hyperlink.pdb, in AportisDoc PDB |
| format. <BR>Start POSE with AportisDoc application and import |
| a_hyperlink.pdb. <BR>Export the doc back to a_hyperlink.pdb. |
| <BR>Merge a_hyperlink.pdb and the original document to |
| a_hyperlink.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <P STYLE="margin-bottom: 0cm">This line is bookmarked to BK1 |
| (Insert-Bookmark)</P> |
| <P STYLE="margin-bottom: 0cm"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0cm">The line <A HREF="http://sunweb.central/allhome.html">SunWeb |
| Home Page</A> has a hyperlink to sunweb.central.</P> |
| <P STYLE="margin-bottom: 0cm"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0cm">This line is a hyperlink to <A HREF="#BK1">BK1</A>. |
| Click here will take cursor to top of page.</P> |
| <P STYLE="margin-bottom: 0cm"><BR> |
| </P> |
| <P><Check hyperlink has the correct address.></P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/content/style/justified</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with justified styling – |
| straight forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_justified.sxw</B>. |
| </P> |
| <P>Convert a_justified.sxw to a_justified.pdb, in AportisDoc PDB |
| format. <BR>Start POSE with AportisDoc application and import |
| a_justified.pdb. <BR>Export the doc back to a_justified.pdb. |
| <BR>Merge a_justified.pdb and the original document to |
| a_justified.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <P STYLE="margin-bottom: 0cm; font-style: normal"><SUP><FONT SIZE=5 STYLE="font-size: 20pt">Left |
| aligned text</FONT></SUP></P> |
| <P ALIGN=CENTER STYLE="margin-bottom: 0cm; font-style: normal"><SUP><FONT SIZE=5 STYLE="font-size: 20pt">Centre |
| aligned</FONT></SUP></P> |
| <P ALIGN=RIGHT STYLE="margin-bottom: 0cm; font-style: normal"><SUP><FONT SIZE=5 STYLE="font-size: 20pt">Right |
| aligned </FONT></SUP> |
| </P> |
| <P ALIGN=JUSTIFY STYLE="font-style: normal"><SUP><FONT SIZE=5 STYLE="font-size: 20pt">Justified</FONT></SUP></P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/merge/style/linebreaks</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with linebreaks – straight |
| forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_linebreaks.sxw</B>. |
| </P> |
| <P>Convert a_linebreaks.sxw to a_linebreaks.pdb, in AportisDoc PDB |
| format. <BR>Start POSE with AportisDoc application and import |
| a_linebreaks.pdb. <BR>Export the doc back to a_linebreaks.pdb. |
| <BR>Merge a_linebreaks.pdb and the original document to |
| a_linebreaks.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <P STYLE="margin-bottom: 0cm">This page has a line breaks inserted |
| at end of this line.<BR>When coverted to doc format it should |
| accordingly be broken up at the same point.</P> |
| <P ALIGN=LEFT STYLE="text-indent: 0.2cm; margin-top: 0.4cm; margin-bottom: 0.41cm"> |
| A simple list</P> |
| <OL> |
| <LI><P ALIGN=LEFT>second entry. A line break follows<BR>the above |
| line has been broken with a line break</P> |
| </OL> |
| <P STYLE="font-style: normal"><SUP><FONT SIZE=5 STYLE="font-size: 20pt">Third |
| entry</FONT></SUP></P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/merge/style/linespacing</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with varied linespacing – |
| straight forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_linespacing.sxw</B>. |
| </P> |
| <P>Convert a_linespacing.sxw to a_linespacing.pdb, in AportisDoc |
| PDB format. <BR>Start POSE with AportisDoc application and import |
| a_linespacing.pdb. <BR>Export the doc back to a_linespacing.pdb. |
| <BR>Merge a_linespacing.pdb and the original document to |
| a_linespacing.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <P STYLE="margin-bottom: 0cm"><I>First: This line and thenext line |
| is spaced by double-line spacing</I></P> |
| <P STYLE="margin-bottom: 0cm"><I>Second: Note the line-distance |
| spacing</I></P> |
| <P STYLE="margin-bottom: 0cm"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0cm"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0cm"><B>First: This line and the next |
| line is spaced by single-line spacing</B></P> |
| <P STYLE="margin-bottom: 0cm"><B>Second: Note the line-distance |
| spacing</B></P> |
| <P STYLE="margin-bottom: 0cm"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0cm; font-weight: medium">First: This |
| line and the next line is spaced by 1.5 line spacing</P> |
| <P STYLE="font-weight: medium">Second: Not the line-distance |
| spacing.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/merge/style/numberorderedlist</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with numberorderedlist – |
| straight forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_numberorderedlist.sxw</B>. |
| </P> |
| <P>Convert a_numberorderedlist.sxw to a_numberorderedlist.pdb, in |
| AportisDoc PDB format. <BR>Start POSE with AportisDoc application |
| and import a_numberorderedlist.pdb. <BR>Export the doc back to |
| a_numberorderedlist.pdb. <BR>Merge a_numberorderedlist.pdb and the |
| original document to a_numberorderedlist.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <P STYLE="margin-bottom: 0cm; font-style: normal">This document is |
| an example of a simple numbered ordered list.</P> |
| <P STYLE="margin-bottom: 0cm"><BR> |
| </P> |
| <OL> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">First</P> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Second</P> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Third</P> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Fourth</P> |
| </OL> |
| <P STYLE="margin-bottom: 0cm"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0cm"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0cm; font-style: normal">End of numbered |
| Ordered list</P> |
| <BLOCKQUOTE><BR> |
| </BLOCKQUOTE> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/content/style/pagebreak</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with pagebreaks – straight |
| forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_pagebreak.sxw</B>. |
| </P> |
| <P>Convert a_pagebreak.sxw to a_pagebreak.pdb, in AportisDoc PDB |
| format. <BR>Start POSE with AportisDoc application and import |
| a_pagebreak.pdb. <BR>Export the doc back to a_pagebreak.pdb. |
| <BR>Merge a_pagebreak.pdb and the original document to |
| a_pagebreak.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <P STYLE="margin-bottom: 0cm">The document has page breaks</P> |
| <P STYLE="margin-bottom: 0cm">Page 1 |
| </P> |
| <P>-now a page break-</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/merge/style/paragraph</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with set paragraph styling– |
| straight forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_paragraph.sxw</B>. |
| </P> |
| <P>Convert a_paragraph.sxw to a_paragraph.pdb, in AportisDoc PDB |
| format. <BR>Start POSE with AportisDoc application and import |
| a_paragraph.pdb. <BR>Export the doc back to a_paragraph.pdb. |
| <BR>Merge a_paragraph.pdb and the original document to |
| a_paragraph.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <P STYLE="margin-bottom: 0cm">This line is a paragraph. It is |
| indented from left hand side by 1.0 inch and from right and side |
| by 1.0 inch (paragraph |
| </P> |
| <P>settings).</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/content/style/standard</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with standard text and default |
| settings – straight forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_standard.sxw</B>. |
| </P> |
| <P>Convert a_standard.sxw to a_standard.pdb, in AportisDoc PDB |
| format. <BR>Start POSE with AportisDoc application and import |
| a_standard.pdb. <BR>Export the doc back to a_standard.pdb. <BR>Merge |
| a_standard.pdb and the original document to a_standard.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <P><FONT FACE="Times New Roman">This line of text is listed in |
| standard style.</FONT></P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/content/style/subscript</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with subscript text setting – |
| straight forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_subscript.sxw</B>. |
| </P> |
| <P>Convert a_subscript.sxw to a_subscript.pdb, in AportisDoc PDB |
| format. <BR>Start POSE with AportisDoc application and import |
| a_subscript.pdb. <BR>Export the doc back to a_subscript.pdb. |
| <BR>Merge a_subscript.pdb and the original document to |
| a_subscript.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <P STYLE="margin-bottom: 0cm"><FONT FACE="Times New Roman"><FONT SIZE=4>The |
| last word on this line is in subscript. <SPAN STYLE="font-style: normal"><SUB>Dude</SUB></SPAN></FONT></FONT></P> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/content/style/superscript</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with superscript text setting – |
| straight forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_subscript.sxw</B>. |
| </P> |
| <P>Convert a_superscript.sxw to a_superscript.pdb, in AportisDoc |
| PDB format. <BR>Start POSE with AportisDoc application and import |
| a_superscript.pdb. <BR>Export the doc back to a_superscript.pdb. |
| <BR>Merge a_superscript.pdb and the original document to |
| a_superscript.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <P STYLE="margin-bottom: 0cm"><FONT FACE="Times New Roman"><FONT SIZE=4>The |
| last word on this line is in superscript. <SPAN STYLE="font-style: normal"><SUP>Dude |
| </SUP></SPAN></FONT></FONT> |
| </P> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/content/style/symbols</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with various symbol types – |
| straight forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_symbols.sxw</B>. |
| </P> |
| <P>Convert a_symbols.sxw to a_symbols.pdb, in AportisDoc PDB |
| format. <BR>Start POSE with AportisDoc application and import |
| a_symbols.pdb. <BR>Export the doc back to a_symbols.pdb. <BR>Merge |
| a_symbols.pdb and the original document to a_symbols.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <P STYLE="margin-bottom: 0cm">'-'-'-'->->->->. |
| '''''''. -------. >>>>>>></P> |
| <P STYLE="margin-bottom: 0cm; font-style: normal"><SUP><FONT FACE="Times New Roman"><FONT SIZE=4>!ӣ$%^&*()_+}{~@:?><,./;'#][=-??? |
| </FONT></FONT></SUP> |
| </P> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/content/style/tab</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with tab styling – straight |
| forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_tab.sxw</B>. |
| </P> |
| <P>Convert a_tab.sxw to a_tab.pdb, in AportisDoc PDB format. |
| <BR>Start POSE with AportisDoc application and import a_tab.pdb. |
| <BR>Export the doc back to a_tab.pdb. <BR>Merge a_tab.pdb and the |
| original document to a_tab.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant document should |
| contain: |
| </P> |
| <P STYLE="margin-bottom: 0cm">This is a tabbed document</P> |
| <P STYLE="margin-bottom: 0cm">1 Tab line</P> |
| <P STYLE="margin-bottom: 0cm">2 tabbed line</P> |
| <P STYLE="margin-bottom: 0cm">3 tabbed line</P> |
| <P STYLE="margin-bottom: 0cm">2 tabbed line</P> |
| <P STYLE="margin-bottom: 0cm">1 Tab line</P> |
| <P STYLE="margin-bottom: 0cm">4 tab line</P> |
| <P STYLE="margin-bottom: 0cm">2 tab line</P> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/merge/style/table</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with table – straight forward |
| convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_table.sxw</B>. |
| </P> |
| <P>Convert a_table.sxw to a_table.pdb, in AportisDoc PDB format. |
| <BR>Start POSE with AportisDoc application and import a_table.pdb. |
| <BR>Export the doc back to a_table.pdb. <BR>Merge a_table.pdb and |
| the original document to a_table.sxw. |
| </P> |
| <P><B>Expected result:</B> |
| </P> |
| <P>The resultant document should contain: |
| </P> |
| <P STYLE="margin-bottom: 0cm"><Check table & contents are |
| identical to original.> |
| </P> |
| <P STYLE="margin-bottom: 0cm"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0cm">This document has a table with 3 |
| rows and 3 columns:</P> |
| <P STYLE="margin-bottom: 0cm"><BR> |
| </P> |
| <P><BR><BR> |
| </P> |
| <P STYLE="margin-bottom: 0cm"><TABLE & CONTENTS></P> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/content/style/textspan</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document testing textspan |
| italics,bolds,underline together– straight forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_textspan.sxw</B>. |
| </P> |
| <P>Convert a_textspan.sxw to a_textspan.pdb, in AportisDoc PDB |
| format. <BR>Start POSE with AportisDoc application and import |
| a_textspan.pdb. <BR>Export the doc back to a_textspan.pdb. <BR>Merge |
| a_textspan.pdb and the original document to a_textspan.sxw. |
| </P> |
| <P><B>Expected result:</B> |
| </P> |
| <P>The resultant document should contain: |
| </P> |
| <P STYLE="margin-bottom: 0cm">Document indicating Text Span</P> |
| <P STYLE="margin-bottom: 0cm"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0cm; font-weight: medium"><I>This is a |
| simple line with some amount of text. The whole line is in italic |
| except the next 3 words which is also <B>SET TO BOLD</B>. Also the |
| next word is <U>UNDERLINED</U>. The essence is differnet styles |
| within the same text span.</I></P> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/merge/style/unorderedlist</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document with unorderedlist – straight |
| forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_unorderedlist.sxw</B>. |
| </P> |
| <P>Convert a_unorderedlist.sxw to a_unorderedlist.pdb, in |
| AportisDoc PDB format. <BR>Start POSE with AportisDoc application |
| and import a_unorderedlist.pdb. <BR>Export the doc back to |
| a_unorderedlist.pdb. <BR>Merge a_unorderedlist.pdb and the |
| original document to a_unorderedlist.sxw. |
| </P> |
| <P><B>Expected result:</B> |
| </P> |
| <P>The resultant document should contain: |
| </P> |
| <P STYLE="margin-bottom: 0cm; font-style: normal">This document is |
| an example of a simple un- ordered list</P> |
| <P STYLE="margin-bottom: 0cm"><BR> |
| </P> |
| <OL> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Wag the Dog</P> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Gladiator</P> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Insider</P> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Usual |
| Suspects</P> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Glengarry |
| Glen Ross</P> |
| </OL> |
| <OL> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Host Shots</P> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Airplane</P> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Monty |
| Python</P> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">History of |
| the World</P> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Sacry Movie</P> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Austin |
| Powers</P> |
| </OL> |
| <UL> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Scarlet and |
| the Black</P> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Operation |
| Day Break</P> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Life is |
| Beautiful</P> |
| <LI><P STYLE="margin-bottom: 0cm; font-style: normal">Nephew |
| (beutfiul soundtrack)</P> |
| </UL> |
| <P STYLE="margin-bottom: 0cm"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0cm; font-style: normal; font-weight: medium"> |
| End of un-ordered list.</P> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/content/style/wordwrap</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: document which tests wordwrapping – |
| straight forward convert</P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_wordwrap.sxw</B>. |
| </P> |
| <P>Convert a_wordwrap.sxw to a_wordwrap.pdb, in AportisDoc PDB |
| format. <BR>Start POSE with AportisDoc application and import |
| a_wordwrap.pdb. <BR>Export the doc back to a_wordwrap.pdb. <BR>Merge |
| a_wordwrap.pdb and the original document to a_wordwrap.sxw. |
| </P> |
| <P><B>Expected result:</B> |
| </P> |
| <P>The resultant document should contain:</P> |
| <P STYLE="margin-bottom: 0cm; font-weight: medium"><I>This line is |
| a long line just to check if the word wrap feature works fine, |
| when it is synched onto the PDA..</I></P> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/merge/content/simple01</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: simple document - insert text at beginning |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_standard.sxw</B>. |
| </P> |
| <P>Convert a_standard.sxw to a_standard.pdb, in AportisDoc PDB |
| format. <BR>Start POSE with AportisDoc application and import |
| a_standard.pdb. <BR>Insert the following text, including the |
| terminating line-feed, at the beginning of the first line: |
| </P> |
| <BLOCKQUOTE>New text added to simple file.</BLOCKQUOTE> |
| <P>Export the doc back to a_standard.pdb. <BR>Merge a_standard.pdb |
| and the original document to a_standard.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant file should contain: |
| </P> |
| <BLOCKQUOTE>New text added to simple file. <BR>This line of |
| text is listed in standard style </BLOCKQUOTE> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/merge/content/simple02</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: simple document - insert text in middle |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_standard.sxw</B>. |
| </P> |
| <P>Convert a_standard.sxw to a_standard.pdb, in AportisDoc PDB |
| format. <BR>Start POSE with AportisDoc application and import |
| a_standard.pdb. <BR>Insert the following text immediately after |
| the word "text": |
| </P> |
| <BLOCKQUOTE>, including this inserted phrase, </BLOCKQUOTE> |
| <P>Export the doc back to a_standard.pdb. <BR>Merge a_standard.pdb |
| and the original document to a_standard.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant file should contain: |
| </P> |
| <BLOCKQUOTE>This line of text, including this inserted |
| phrase, is listed in standard style </BLOCKQUOTE> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=28%> |
| <P><B>aportis/merge/content/simple03</B></P> |
| </TD> |
| <TD WIDTH=72%> |
| <P><B>Summary</B>: simple document - append text |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>a_standard.sxw</B>. |
| </P> |
| <P>Convert a_standard.sxw to a_standard.pdb, in AportisDoc PDB |
| format. <BR>Start POSE with AportisDoc application and import |
| a_standard.pdb. <BR>Append a new-line at the end of the line and |
| add the following line: |
| </P> |
| <BLOCKQUOTE>This is also in standard style</BLOCKQUOTE> |
| <P>Export the doc back to a_standard.pdb. <BR>Merge a_standard.pdb |
| and the original document to a_standard.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant file should contain: |
| </P> |
| <BLOCKQUOTE>This line of text is listed in standard |
| style <BR>This is also in standard style</BLOCKQUOTE> |
| </TD> |
| </TR> |
| </TABLE> |
| <H2>5.2 MiniCalc Tests</H2> |
| <H2>5.2.1 MiniCalc Convert Tests</H2> |
| <H2>5.2.1.1 MiniCalc Merge Style Tests</H2> |
| <TABLE WIDTH=100% BORDER=1 CELLPADDING=2 CELLSPACING=0> |
| <COL WIDTH=77*> |
| <COL WIDTH=179*> |
| <TR VALIGN=TOP> |
| <TD WIDTH=30%> |
| <P><B>minicalc/merge/style/columnswidth</B> <BR> </P> |
| </TD> |
| <TD WIDTH=70%> |
| <P><B>Summary</B>: Spreadsheet with 5 columns 10 entries - |
| Spreadsheet columnwidth variation. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_columnswidth.sxc</B>. |
| </P> |
| <P>Convert c_columnswidth.sxc to c_columnswidth.pdb, in MiniCalc |
| PDB format. <BR>Start POSE with MiniCalc application and |
| import c_columnswidth.pdb. </P> |
| <P>Choose Cell Reference "B1" & alter column width |
| to 1.55 by selecting, Format -> Column -> Width... < make |
| width change via spin button> -> OK, also decrease "E1" |
| similarly to have a column width of 1.68.<BR><BR><BR> |
| </P> |
| <P>Export the doc back to c_columnswidth.pdb. <BR>Merge |
| c_columnswidth.pdb to c_columnswidth.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| column B with a width increase of 1.0 , and column E with a width |
| decrease of 1.0, as compared with the original file, reflecting |
| the changes stated above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=30%> |
| <P><B>minicalc/merge/style/rowheight</B></P> |
| </TD> |
| <TD WIDTH=70%> |
| <P><B>Summary</B>: Spreadsheet with 4 columns 3 rows 12 entries - |
| Spreadsheet rowheight variation. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_rowheight.sxc</B>. |
| </P> |
| <P>Convert c_rowheight.sxc to c_rowheight.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_rowheight.pdb. </P> |
| <P><BR>Choose Cell Reference "A1" & alter row height |
| to 1.17 by selecting Format -> Row -> Height... <make |
| height change via spin button> -> OK., also decrease "A3” |
| similarly to have a row height of 0.30. |
| </P> |
| <P>Export the doc back to c_rowheight.pdb. <BR>Merge |
| c_rowheight.pdb to c_rowheight.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| row “Row 1” with a height increase of 1.0 and "Row |
| 3" with a height decrease of 0.41, as compared with the |
| original file, reflecting the changes stated above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=30%> |
| <P><B>minicalc/merge/style/rowstyles</B></P> |
| </TD> |
| <TD WIDTH=70%> |
| <P><B>Summary</B>: Spreadsheet with 5 columns 6 rows 18 entries - |
| Spreadsheet rowstyle variation. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_rowstyle.sxc</B>. |
| </P> |
| <P>Convert c_rowstyles.sxc to c_rowstyles.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_rowstyles.pdb. </P> |
| <P>Choose Cell Reference "B3" and change Heading style |
| to default, by selecting, Format -> Style Catelog -> <choose |
| heading type from listbox>, also choose cellreference "D5" |
| and change Heading style to Heading1, also change "C5" |
| to remove bold, underline & italic. |
| </P> |
| <P><BR>Export the doc back to c_rowstyles.pdb. <BR>Merge |
| c_rowstyles.pdb to c_rowstyles.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| value's and style types as in original file, except cells "B3, |
| & D5" which should display heading types default & |
| Heading 1 resp. and "C5" which should be plain text, |
| reflecting the changes stated above.</P> |
| </TD> |
| </TR> |
| </TABLE> |
| <H2>5.2.1.2 MiniCalc Convert Style Tests</H2> |
| <TABLE WIDTH=100% BORDER=1 CELLPADDING=2 CELLSPACING=0> |
| <COL WIDTH=77*> |
| <COL WIDTH=179*> |
| <TR VALIGN=TOP> |
| <TD WIDTH=30%> |
| <P><B>minicalc/convert/style/styles</B> <BR> </P> |
| </TD> |
| <TD WIDTH=70%> |
| <P><B>Summary</B>: Spreadsheet with 3 columns 10 rows 13 entries - |
| Spreadsheet styles test. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_styles.sxc</B>. |
| </P> |
| <P>Convert c_styles.sxc to c_styles.pdb, in MiniCalc PDB format. |
| <BR>Start POSE with MiniCalc application and import c_styles.pdb. |
| <BR>Export the doc back to c_styles.pdb. <BR>Merge |
| c_styles.pdb to c_styles.sxw. </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| all original sheet values with style features, .i.e Bold, Italics, |
| .</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=30%> |
| <P><B>minicalc/convert/style/alignment</B><BR> </P> |
| </TD> |
| <TD WIDTH=70%> |
| <P><B>Summary</B>: Spreadsheet with 4 columns 8 rows 24 entries - |
| Spreadsheet alignment test. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_alignment.sxc</B>. |
| </P> |
| <P>Convert c_alignment.sxc to c_alignment.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_alignment.pdb. <BR>Export the doc back to |
| c_alignment.pdb. <BR>Merge c_alignment.pdb to |
| c_alignment.sxw. </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| all original sheet values with identical alignment to original |
| file.</P> |
| </TD> |
| </TR> |
| </TABLE> |
| <H2><BR><BR> |
| </H2> |
| <H2>5.2.2.1 MiniCalc Merge Content Tests</H2> |
| <TABLE WIDTH=100% BORDER=1 CELLPADDING=2 CELLSPACING=0> |
| <COL WIDTH=77*> |
| <COL WIDTH=179*> |
| <TR> |
| <TD WIDTH=30% VALIGN=TOP> |
| <P><B>minicalc/merge/content/insertimage</B><BR> </P> |
| </TD> |
| <TD WIDTH=70% VALIGN=BOTTOM> |
| <P><B>Summary</B>: Spreadsheet with 6 columns 2 image inserts - |
| Spreadsheet image insert. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_insertimage.sxc</B>. |
| </P> |
| <P>Convert c_insertimage.sxc to c_insertimage.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_insertimage.pdb. <BR>Export the doc back to |
| c_insertimage.pdb. <BR>Merge c_insertimage.pdb to |
| c_insertimage.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| original file with both original images.</P> |
| </TD> |
| </TR> |
| <TR> |
| <TD WIDTH=30% VALIGN=TOP> |
| <P><B>minicalc/merge/content/textimage</B><BR> </P> |
| </TD> |
| <TD WIDTH=70% VALIGN=BOTTOM> |
| <P><B>Summary</B>: Spreadsheet with 6 columns 2 image inserts - |
| Spreadsheet image text insert. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_textimage.sxc</B>. |
| </P> |
| <P>Convert c_textimage.sxc to c_textimage.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_textimage.pdb. </P> |
| <P>Insert text immediately before and directly after the inserted |
| image.</P> |
| <P>Export the doc back to c_textimage.pdb. <BR>Merge |
| c_textimage.pdb to c_textimage.sxw. |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| original image surrounded by text .i.e text before & after the |
| insert.</P> |
| </TD> |
| </TR> |
| </TABLE> |
| <H2>5.2.2.2 MiniCalc Convert Contents Tests</H2> |
| <TABLE WIDTH=1025 BORDER=1 CELLPADDING=2 CELLSPACING=0> |
| <COL WIDTH=431> |
| <COL WIDTH=584> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/basic</B></P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary: </B>simple spreadsheet - round-trip conversion |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_standard.sxc</B>. |
| </P> |
| <P>Convert c_standard.sxc to c_standard.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_standard.pdb. Export the doc back to c_standard.pdb, without |
| making and changes to the spreadsheet. <BR>Merge |
| c_standard.pdb to c_standard.sxc. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant file should be |
| equivalent to the original spreadsheet. <BR> </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/simple01</B></P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: simple spreadsheet - insert text & column |
| of numeric values at beginning of empty sheet. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_standard.sxc</B>. |
| </P> |
| <P>Convert c_standard.sxc to c_standard.pdb, in Minicalc PDB |
| format. <BR>Start POSE with Minicalc application and import |
| c_standard.pdb. <BR>Insert the following text & values |
| at the beginning of the the spreadsheet, .i.e in Column 1: |
| </P> |
| <BLOCKQUOTE>Col 1</BLOCKQUOTE> |
| <BLOCKQUOTE>1</BLOCKQUOTE> |
| <BLOCKQUOTE>1</BLOCKQUOTE> |
| <BLOCKQUOTE>1</BLOCKQUOTE> |
| <P>Export the doc back to c_standard.pdb. <BR>Merge |
| c_standard.pdb to c_standard.sxc. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant file should contain: |
| </P> |
| <BLOCKQUOTE STYLE="margin-left: 6.05cm">New column of values as |
| shown above. </BLOCKQUOTE> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/simple02</B></P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: simple spreadsheet - append a new column to |
| end |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_standard.sxc</B>. |
| </P> |
| <P>Convert c_standard.sxc to c_standard.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_standard.pdb. <BR>Insert the following column immediately |
| after the first: |
| </P> |
| <BLOCKQUOTE>Col 3</BLOCKQUOTE> |
| <BLOCKQUOTE>3</BLOCKQUOTE> |
| <BLOCKQUOTE>3</BLOCKQUOTE> |
| <BLOCKQUOTE>3</BLOCKQUOTE> |
| <P>Export the doc back to c_standard.pdb. <BR>Merge |
| c_standard.pdb to c_standard.sxc. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant file should contain: |
| </P> |
| <P CLASS="text-body-indent">Col 1 Col 3</P> |
| <BLOCKQUOTE>1 3 |
| </BLOCKQUOTE> |
| <BLOCKQUOTE>1 3</BLOCKQUOTE> |
| <BLOCKQUOTE>1 3</BLOCKQUOTE> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/simple03</B></P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: simple spreadsheet - insert a new column in |
| middle |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_standard.sxc</B>. |
| </P> |
| <P>Convert c_standard.sxc to c_standard.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_standard.pdb. <BR>Insert the following column immediately |
| after the first and before the second: |
| </P> |
| <BLOCKQUOTE>Col 2</BLOCKQUOTE> |
| <BLOCKQUOTE>2</BLOCKQUOTE> |
| <BLOCKQUOTE>2</BLOCKQUOTE> |
| <BLOCKQUOTE>2</BLOCKQUOTE> |
| <P>Export the doc back to c_standard.pdb. <BR>Merge |
| c_standard.pdb to c_standard.sxc. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant file should contain: |
| </P> |
| <BLOCKQUOTE>Col 1 Col 2 Col 3</BLOCKQUOTE> |
| <BLOCKQUOTE>1 2 3</BLOCKQUOTE> |
| <BLOCKQUOTE>1 2 3</BLOCKQUOTE> |
| <BLOCKQUOTE>1 2 3</BLOCKQUOTE> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/simple04</B></P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: simple spreadsheet - delete text |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_standard.sxc</B>. |
| </P> |
| <P>Convert c_standard.sxc to c_standard.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_standard.pdb. <BR>Delete “Column 3”, so that |
| it reads: |
| </P> |
| <BLOCKQUOTE>Col 1 Col 2</BLOCKQUOTE> |
| <BLOCKQUOTE>1 2</BLOCKQUOTE> |
| <BLOCKQUOTE>1 2</BLOCKQUOTE> |
| <P>Export the doc back to c_standard.pdb. <BR>Merge |
| c_standard.pdb to c_standard.sxc. |
| </P> |
| <P><B>Expected result:</B> <BR>The resultant file should contain: |
| </P> |
| <BLOCKQUOTE>Col 1 Col 2</BLOCKQUOTE> |
| <BLOCKQUOTE>1 2</BLOCKQUOTE> |
| <BLOCKQUOTE>1 2</BLOCKQUOTE> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/addition</B></P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 4 columns 10 entries - |
| Spreadsheet Simple Addition using various formulae. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_addition.sxc</B>. |
| </P> |
| <P>Convert c_addition.sxc to c_addition.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_addition.pdb. <BR>Change Cell Reference "A1" = 3 |
| in formula bar. <BR>Export the doc back to c_addition.pdb. |
| <BR>Merge c_addition.pdb to c_addition.sxc. |
| </P> |
| <P>A1 =3 ; B1 = 3 ; C1 =4 ;D1 =5; |
| </P> |
| <P>Addition types: |
| </P> |
| <P>Cell reference + Integer = A1+2 =5 |
| </P> |
| <P>Integer + Decimal = 3+0.1 =3.1 |
| </P> |
| <P>Cell Reference + Cell Reference = A1+B1 = 6 |
| </P> |
| <P>(Bracketed Cell Reference) + (Integer + Integer) = |
| (A1+B1)+(2+45) = 53 |
| </P> |
| <P>Integer + (Integer) + (Integer+Integer) = 2+(0)+(3+0) = 5 |
| </P> |
| <P>(SUM(Cell Ref;Cell Ref) +SUM(Cell Ref;Cell Ref) = |
| (SUM(A1;B1)+SUM(B1;C1) = 13 |
| </P> |
| <P><B>Expected result:</B> <BR> All spreadsheet entered |
| values & the standard formula SUM of each cell should be |
| displayed as above, formulae as stated above should be visible in |
| the Formula Bar. </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/backwardrange</B></P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 2 columns 7 entries - |
| Spreadsheet backwardranging using various formulae. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_backwardrange.sxc</B>. |
| </P> |
| <P>Convert c_alignment.sxc to c_alignment.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_alignment.pdb. <BR>Change Cell Reference "B2" = |
| AVERAGE(2;5;5) in formula bar. <BR>Export the doc back to |
| c_alignment.pdb. <BR>Merge c_alignment.pdb to |
| c_alignment.sxc. |
| </P> |
| <P>Logical Funtion test B4: |
| </P> |
| <P>IF(Logical Test; Then Value;Else Value) |
| </P> |
| <P>.e.g. IF(23;45.45;54.54) = 45.45 |
| </P> |
| <P>read as if logical test TRUE then place THEN VALUE in cell else |
| place ELSE VALUE. <BR> <BR> <BR> |
| </P> |
| <P>Statistical Functional tests B2 , B3 resp.: |
| </P> |
| <P>AVERAGE(2;5;5) - Returns sum of arguments divided by number of |
| arguments =4 . |
| </P> |
| <P>MAX(10;3;3) - Returns the maximum value in a list of arguments |
| =10. <BR> <BR> <BR> |
| </P> |
| <P>Negative addition test B1: |
| </P> |
| <P>=B2-B3 = 4 - 10 = -6 <BR> <BR> <BR> |
| </P> |
| <P>Range Addition tests A1, A5, B5: |
| </P> |
| <P>SUM(B2;B4) = B2 + B3 + B4 = 4 + 10 + 45.45 = 59.45. |
| </P> |
| <P>SUM(A1:B2) -B4 = (59.45 + (-6) +4) - 45.45 = 12</P> |
| <P>SUM(A1;B1)-A2 = (59.45 + (-6)) - 0 = 53.45 |
| </P> |
| <P><B>Expected result:</B> <BR> All spreadsheet entered |
| values & the standard formula SUM of each cell should be |
| displayed on sheet as detailed above, formulae as stated above |
| should be visible in the Formula Bar.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/boolean</B></P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 1 column 2 entries - |
| Spreadsheet boolean entry. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_boolean.sxc</B>. |
| </P> |
| <P>Convert c_boolean.sxc to c_boolean.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_boolean.pdb. <BR>Change Cell Reference "A2" = |
| TRUE in formula bar. <BR>Export the doc back to |
| c_boolean.pdb. <BR>Merge c_boolean.pdb to c_boolean.sxc. |
| </P> |
| <P>Logical Funtion test : cells A1, A2: |
| </P> |
| <P>A1=TRUE |
| </P> |
| <P>A2=TRUE |
| </P> |
| <P>Returns the logical values TRUE to the cells resp. |
| </P> |
| <P><B>Expected result:</B> <BR> The logical entry of each |
| cell should be displayed on the sheet as stated above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/cellcurrencyvalue</B></P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 2 columns 10 entries - |
| Spreadsheet Currency number Format conversion test. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_cellcurrencyvalue.sxc</B>. |
| </P> |
| <P>Convert c_cellcurrencyvalue.sxc to c_cellcurrencyvalue.pdb, in |
| MiniCalc PDB format. <BR>Start POSE with MiniCalc |
| application and import c_cellcurrencyvalue.pdb. <BR>Export |
| the doc back to c_cellcurrencyvalue.pdb. <BR>Merge |
| c_cellcurrencyvalue.pdb to c_cellcurrencyvalue.sxc. |
| </P> |
| <P>Display Sheet : 12 DM. |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet entered values or |
| the sum of each cell should be displayed with specified Currency |
| symbol, formulae should be visible in the Formula Bar but not the |
| currency symbol.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/cellcurrencychange</B></P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 2 columns 10 entries - |
| Spreadsheet Currency number Format modification test. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_cellcurrencychange.sxc</B>. |
| </P> |
| <P>Convert c_cellcurrencychange.sxc to c_cellcurrencychange.pdb, |
| in MiniCalc PDB format. <BR>Start POSE with MiniCalc |
| application and import c_cellcurrencychange.pdb. <BR>Change |
| Cell Reference "A1" to have currency format in Danish |
| Marks (DM). <BR>Export the doc back to |
| c_cellcurrencychange.pdb. <BR>Merge c_cellcurrencychange.pdb |
| to c_cellcurrencychange.sxc. |
| </P> |
| <P>Select cell A1 = 12 ; then tap pen icon option on palm, choose |
| Currency from palm listbox, tap on the down arrow to the right of |
| the flashing cursor, tap on the intended currency type .e.g DM |
| (Danish Mark) and tap apply & OK. |
| </P> |
| <P>Display Sheet : 12 DM. |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet entered values or |
| the sum of each cell should be displayed with specified Currency |
| symbol, formulae should be visible in the Formula Bar but not the |
| currency symbol.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/cellfloatvalue</B></P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 2 columns 6 entries - |
| Spreadsheet float values. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_cellfloatvalue.sxc</B>. |
| </P> |
| <P>Convert c_cellfloatvalue.sxc to c_cellfloatvalue.pdb, in |
| MiniCalc PDB format. <BR>Start POSE with MiniCalc |
| application and import c_cellfloatvalue.pdb. <BR>Change Cell |
| Reference "A1" = 11 & "A2" = 2.38 & B3 |
| 100.02450 in formula bar. <BR>Export the doc back to |
| c_cellfloatvalue.pdb. <BR>Merge c_cellfloatvalue.pdb to |
| c_cellfloatvalue.sxc. |
| </P> |
| <P>The original sheet has selected Format -> Cells... -> |
| Numbers Tab -> & Numbers from the list box, choosen |
| -1234.12, tho set the Format Code to 0.00 preventing the sheet |
| display rounding values to two decimal places. It also has |
| fraction display enabled in certain cells.</P> |
| <P>Formula Bar : Display Sheet: |
| </P> |
| <P>A1 = 11 -> 11.00 |
| </P> |
| <P>A2 = 2.38 -> 2 19/50 |
| </P> |
| <P>A3 = 0.45 -> 0.45 |
| </P> |
| <P>B2 = 0.23 -> 2/9 |
| </P> |
| <P>B3 = 100.02450 -> 100.02 |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet fractional & |
| decimal values should be displayed with specified precision as |
| stated above, formulae should be visible in the Formula Bar.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/cellpercentvalue</B></P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 2 columns 3 entries - |
| Spreadsheet percentage value precision. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_cellpercentvalue.sxc</B>. |
| </P> |
| <P>Convert c_cellpercentvalue.sxc to c_cellpercentvalue.pdb, in |
| MiniCalc PDB format. <BR>Start POSE with MiniCalc |
| application and import c_cellpercentvalue.pdb. <BR>Change |
| Cell Reference "A1" = 120% & "B1" = 10% in |
| formula bar. <BR>Export the doc back to |
| c_cellpercentvalue.pdb. <BR>Merge c_cellpercentvalue.pdb to |
| c_cellpercentvalue.sxc. |
| </P> |
| <P>For cell A1 enter 120% in the Formula Bar. Sheet Display = |
| 120.00% |
| </P> |
| <P>For cell B1 enter 10% in the Formula Bar. Sheet Display = 10% |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet percentage values |
| should be displayed with specified precision as stated above, |
| formulae should be visible in the Formula Bar.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/cellstringvalue</B></P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 4 columns 11 entries - |
| Spreadsheet String values. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_cellstringvalue.sxc</B>. |
| </P> |
| <P>Convert c_cellstringvalue.sxc to c_cellstringvalue.pdb, in |
| MiniCalc PDB format. <BR>Start POSE with MiniCalc |
| application and import c_cellstringvalue.pdb. <BR>Change |
| Cell Reference "C2" = Testing & DELETE contents of |
| "D2" & insert a ';' in "B3" in formula |
| bar. <BR>Export the doc back to c_cellstringvalue.pdb. |
| <BR>Merge c_cellstringvalue.pdb to c_cellstringvalue.sxc. |
| </P> |
| <P>A1 = This A2 = With A3 = For |
| </P> |
| <P>B1 = Cell B2 = Strings B3 = ; |
| </P> |
| <P>C1 = Is C2 = Testing C3 = string values |
| </P> |
| <P>D1 = Filled D2 = "blank" |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet strings values |
| should be displayed as stated above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/character</B> <BR> </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 4 columns 23 entries - |
| Spreadsheet character values. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_character.sxc</B>. |
| </P> |
| <P>Convert c_character.sxc to c_character.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_character.pdb. <BR>Change Cell Reference "C7" = |
| -??%, .i.e appending a % sign. <BR>Export the doc back to |
| c_character.pdb. <BR>Merge c_character.pdb to |
| c_character.sxc. |
| </P> |
| <P>C7 = -??% |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet character values |
| should be displayed as in original file including minor change |
| stated above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/cyclic</B> <BR> </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 2 columns 8 entries - |
| Spreadsheet error messages. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_cyclic.sxc</B>. |
| </P> |
| <P>Convert c_cyclic.sxc to c_cyclic.pdb, in MiniCalc PDB format. |
| <BR>Start POSE with MiniCalc application and import c_cyclic.pdb. |
| <BR>Change Cell Reference "A4" & "A5" = 0 |
| & "B4" = A1/A4, "B5"= A4/A5 in formula |
| bar. <BR>Export the doc back to c_cyclic.pdb. <BR>Merge |
| c_cyclic.pdb to c_cyclic.sxc. |
| </P> |
| <P>Changes should generate 2 extra errors shown below. |
| </P> |
| <P>B4 = Err.503</P> |
| <P>B5 = #VALUE! |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| all original sheet values including 2 extra errors generated by |
| the changes detailed above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/dividefloating</B> <BR> </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 2 columns 7 entries - |
| Spreadsheet dividing floating points. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_dividefloating.sxc</B>. |
| </P> |
| <P>Convert c_dividefloating.sxc to c_dividefloating.pdb, in |
| MiniCalc PDB format. <BR>Start POSE with MiniCalc |
| application and import c_dividefloating.pdb. <BR>Change Cell |
| Reference "A4" = -(12.2)/(5-1) & "B2" = to |
| be positive, in formula bar. <BR>Export the doc back to |
| c_dividefloating.pdb. <BR>Merge c_dividefloating.pdb to |
| c_dividefloating.sxc. |
| </P> |
| <P>B2 = 03.050000 |
| </P> |
| <P>A4 = -03.05</P> |
| <P>Spreadsheet setting : Format -> Cells... -> Decimal |
| Places=6, Negative numbers red= TRUE, Leading zero's =2 -> OK. |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| all original sheet values and newly entered floating point |
| division with specified precision & colour, as stated above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/forwardrange</B> <BR> </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 2 columns 4 rows 5 entries - |
| Spreadsheet tests forwardranging. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_forwardrange.sxc</B>. |
| </P> |
| <P>Convert c_forwardrange.sxc to c_forwardrange.pdb, in MiniCalc |
| PDB format. <BR>Start POSE with MiniCalc application and |
| import c_forwardrange.pdb. <BR>Change Cell Reference "B4" |
| = IF(0;45.45;54.54), in formula bar. <BR>Export the doc back |
| to c_forwardrange.pdb. <BR>Merge c_forwardrange.pdb to |
| c_forwardrange.sxc. |
| </P> |
| <P>Changes IF statement to False so ELSE VALUE now valid. |
| </P> |
| <P>B4 = 54.54 |
| </P> |
| <P>A1 = SUM(B2;B4) = B2+B3+B4 =56.23 + 560 + 54.54 = 670.77 |
| </P> |
| <P><B>Expected result:</B> <BR>Spreadsheet values & the |
| modified standard formula SUM'sl should be displayed in each cell |
| on sheet to reflect the changes as stated above, formulae should |
| be visible in the Formula Bar. </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/hiddenrow</B> <BR> </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 5 columns 2 rows 9 entries - |
| Spreadsheet tests hidden row. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_hiddenrow.sxc</B>. |
| </P> |
| <P>Convert c_hiddenrow.sxc to c_hiddenrow.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_hiddenrow.pdb. <BR>Select Format -> Row -> Show. |
| <BR>Export the doc back to c_hiddenrow.pdb. <BR>Merge |
| c_hiddenrow.pdb to c_hiddenrow.sxc. |
| </P> |
| <P>A previously hidden row 2 appears. |
| </P> |
| <P><B>Expected result:</B> <BR>Spreadsheet values & standard |
| formula SUM's should be displayed in each cell on sheet as before |
| including a new row #2 which reflects the change stated above. </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/invalidcellref</B> <BR> </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 3 columns 3 rows 8 entries - |
| Spreadsheet invalid cell references. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_invalidcellref.sxc</B>. |
| </P> |
| <P>Convert c_invalidcellref.sxc to c_invalidcellref.pdb, in |
| MiniCalc PDB format. <BR>Start POSE with MiniCalc |
| application and import c_invalidcellref.pdb. <BR>Change Cell |
| Reference "A3" = MAX(1;2;3) , "C2" = "blank", |
| "C3" = a0, in formula bar. <BR>Export the doc back |
| to c_invalidcellref.pdb. <BR>Merge c_invalidcellref.pdb to |
| c_invalidcellref.sxc. |
| </P> |
| <P>Changes should generate 2 extra errors shown below. |
| </P> |
| <P>A3 = 3 |
| </P> |
| <P>C2 = "blank" |
| </P> |
| <P>C3 = #NAME? |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| all original sheet values, excpet "C3" which holds new |
| invalid input warning generated by the change detailed above, |
| sheet should also show removal of 2 types of invalid input with |
| valid input replacements "A3" & "C2".</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/largerange</B> <BR> </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 3 columns 3 rows 8 entries - |
| Spreadsheet large range test. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_largerange.sxc</B>. |
| </P> |
| <P>Convert c_largerange.sxc to c_largerange.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_largerange.pdb. <BR>Change Cell Reference "B3" = |
| SUM(E7:G10), in formula bar. <BR>Export the doc back to |
| c_largerange.pdb. <BR>Merge c_largerange.pdb to |
| c_largerange.sxc. |
| </P> |
| <P>Increases the range by an extra row. |
| </P> |
| <P>B3 = SUM(E7:G10) = E7+F7+G7+E8+F8+G8+E9+F9+G9+E10+F10+G10 = |
| </P> |
| <P>= 4+4+4+2+2+4+1+4+4+1+1+12 = 31 +12 = 43 |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| all original sheet values, except "B3" which holds new |
| larger range standard formula SUM generated by the change detailed |
| above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/listrange</B> <BR> </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 5 columns 4 rows 20 entries - |
| Spreadsheet listrange test. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_listrange.sxc</B>. |
| |
| </P> |
| <P>Convert c_listrange.sxc to c_listrange.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_listrange.pdb. <BR>Change Cell Reference "D3" = |
| 24, in formula bar. <BR>Export the doc back to |
| c_listrange.pdb. <BR>Merge c_listrange.pdb to |
| c_listrange.sxc. |
| </P> |
| <P>D3 = 24 |
| </P> |
| <P>A4 = SUM(A1:A3) = 256.1 |
| </P> |
| <P>B4 = AVERAGE(A1:A3) = 17.07 |
| </P> |
| <P>C4 = AVERAGE(A4:B4) = AVERAGE( 256.1+17.07) = 136.59 |
| </P> |
| <P>D4 = AVERAGE(D1;D2;D3) = AVERAGE( 13.1+18+24) = 18.37 |
| </P> |
| <P>E5 = SUM(A4:B4:C4:D4) = (256.1+17.07+136.59+18.37) = 428.13<BR> |
| <BR> <BR> |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| all original sheet values, except cells "A4-E4" which |
| hold the modified standard formula SUM & AVERAGE value's |
| generated by the change in D3 detailed above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/mathematical</B> <BR> </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 5 columns 3 rows 15 entries - |
| Spreadsheet stanadard math functs test in (Rad). |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_mathematical.sxc</B>. |
| |
| </P> |
| <P>Convert c_mathematical.sxc to c_mathematical.pdb, in MiniCalc |
| PDB format. <BR>Start POSE with MiniCalc application and |
| import c_mathematical.pdb. <BR>Change Cell Reference "B1" |
| = SIN(3.14/2), "B2" =COS(0), "C3"= TAN(1.57/2) |
| in formula bar. <BR>Export the doc back to |
| c_mathematical.pdb. <BR>Merge c_mathematical.pdb to |
| c_mathematical.sxc. |
| </P> |
| <P>B1 = 1</P> |
| <P>B2 = 1 |
| </P> |
| <P>C3 =1 |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| all original sheet values except cells "B1,B2,C3" which |
| hold modified sin,cos & tan value's generated by the changes |
| stated above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/protection</B> <BR> </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 1 column 3 rows 3 entries - |
| Spreadsheet protection test. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_protection.sxc</B>. |
| |
| </P> |
| <P>Convert c_protection.sxc to c_protection.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_protection.pdb. <BR>Attempt to Change Cell Reference "A1" |
| either directly or in formula bar from the value 12 to 1. |
| <BR>Export the doc back to c_protection.pdb. <BR>Merge |
| c_protection.pdb to c_protection.sxc. |
| </P> |
| <P>User should be unable to change cell contents, popup error |
| message "Protected cells can not be modified" should |
| appear. |
| </P> |
| <P>This is because the Tools -> Protect Document -> Sheet |
| option has been enabled with a password and therefore all cells on |
| sheet are write protected. |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| all original sheet values.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/renamedsheet</B> <BR> </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 3 sheets 0 entries - |
| Spreadsheet rename test. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_renamedsheet.sxc</B>. |
| |
| </P> |
| <P>Convert c_renamedsheet.sxc to c_renamedsheet.pdb, in MiniCalc |
| PDB format. <BR>Start POSE with MiniCalc application and |
| import c_renamedsheet.pdb. <BR>Change sheet named "testplan" |
| to "renamed". <BR>Export the doc back to |
| c_renamedsheet.pdb. <BR>Merge c_renamedsheet.pdb to |
| c_renamedsheet.sxc. |
| </P> |
| <P>Click on "testplan" sheet tab, and using 3<SUP>rd</SUP> |
| mouse button, choose Rename..., from popup menu, enter new sheet |
| name & OK. |
| </P> |
| <P>OR choose Format -> Sheet -> Rename... enter new sheet |
| name & OK. |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| all original sheets & names, with the exception of the |
| "testplan" sheet which should now be labelled "renamed" |
| .</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/sheetreference</B></P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 3 sheets 4 columns 4 rows 11 |
| entries - Spreadsheet sheetreference test. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_sheetreference.sxc</B>. |
| |
| </P> |
| <P>Convert c_sheetreference.sxc to c_sheetreference.pdb, in |
| MiniCalc PDB format. <BR>Start POSE with MiniCalc |
| application and import c_sheetreference.pdb. <BR>Change Cell |
| Reference "A3" = Sheet3.B1. <BR>Export the doc |
| back to c_sheetrefernce.pdb. <BR>Merge c_sheetreference.pdb |
| to c_sheetreference.sxc. |
| </P> |
| <P>A3 = 3. |
| </P> |
| <P>B4 =26.</P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| all original value's & formulae as in original file, except |
| cells "A3"& "A4" which should display a |
| different sheet reference value and the modified sheet reference |
| formula, reflecting the changes stated above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/smallrange</B> <BR> </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 4 columns 3 rows 10 entries - |
| Spreadsheet small range test. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_smallrange.sxc</B>. |
| |
| </P> |
| <P>Convert c_smallrange.sxc to c_smallrange.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_smallrange.pdb. <BR>Change Cell Reference "B3" = |
| AVERAGE(A1:B2), in formula bar. <BR>Export the doc back to |
| c_smallrange.pdb. <BR>Merge c_smallrange.pdb to |
| c_smallrange.sxc. |
| </P> |
| <P>Decrease the range by 1 row. |
| </P> |
| <P>B3 = AVERAGE(A1:B2) = (1+2+3+3)/4 = 2.25 |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| all original sheet values, except "A3" which now holds |
| average value of new smaller range generated by the change |
| detailed above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/cancel</B><BR> </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 1 columns 4 rows 4entries - |
| Spreadsheet palm confirm &cancel test. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_cancel.sxc</B>. |
| </P> |
| <P>Convert c_cancel.sxc to c_cancel.pdb, in MiniCalc PDB format. |
| <BR>Start POSE with MiniCalc application and import c_cancel.pdb. |
| <BR>Select with mouse Cell Reference "A2" on dotted line |
| on palm type 14, tap “TICK” option (leftmost option on |
| palm) to confirm, repeat this step this time Changing Cell |
| Reference “A2” = 1, except this time tap the “X” |
| option to cancel. <BR>Export the doc back to c_cancel.pdb. |
| <BR>Merge c_cancel.pdb to c_cancel.sxc. |
| </P> |
| <P>A2 = 14. |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| all original sheet values, except "A2" which now holds |
| the value 14 generated by the change detailed above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/cut&paste</B><BR> </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 1 columns 4 rows 4entries - |
| Spreadsheet palm cut&paste test. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_cut&paste.sxc</B>. |
| |
| </P> |
| <P>Convert c_cut&paste.sxc to c_cut&paste.pdb, in MiniCalc |
| PDB format. <BR>Start POSE with MiniCalc application and |
| import c_cut&paste.pdb. <BR>Choose Cell Reference "A2" |
| with mouse, tap cut option on palm, choose Cell Reference “A5” |
| and tap paste option. <BR>Export the doc back to |
| c_cut&paste.pdb. <BR>Merge c_cut&paste.pdb to |
| c_cut&paste.sxc. |
| </P> |
| <P>A2 = “blank”.</P> |
| <P>A5 = 14. |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| all original sheet values, except "A2" & “A5” |
| which now holds the values blank & 14 resp. generated by the |
| changes detailed above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/copy&paste</B><BR> </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 1 columns 4 rows 4entries - |
| Spreadsheet palm copy&paste test. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_copy&paste.sxc</B>. |
| |
| </P> |
| <P>Convert c_copy&paste.sxc to c_copy&paste.pdb, in |
| MiniCalc PDB format. <BR>Start POSE with MiniCalc |
| application and import c_copy&paste.pdb. <BR>Choose Cell |
| Reference "A5" with mouse, tap copy option on palm, |
| choose Cell Reference “A2” and tap paste option. |
| <BR>Export the doc back to c_copy&paste.pdb. <BR>Merge |
| c_copy&paste.pdb to c_copy&paste.sxc. |
| </P> |
| <P>A2 = 14.</P> |
| <P>A5 = 14. |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| all original sheet values, except "A2" which now holds |
| the value 14 generated by the change detailed above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/textentry</B><BR> </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 1 columns 4 rows 4entries - |
| Spreadsheet palm text entry test. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_textentry.sxc</B>. |
| |
| </P> |
| <P>Convert c_textentry.sxc to c_textentry.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_textentry.pdb. <BR>Choose Cell Reference "A1" |
| with mouse, tap textentry option on palm, type the following text |
| string into the popup text box “This is a MiniCalc text |
| entry test.”.<BR>Export the doc back to c_textentry.pdb. |
| <BR>Merge c_textentry.pdb to c_textentry.sxc. |
| </P> |
| <P>A1 = “This is a MiniCalc text entry test.”</P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| all original sheet values, except "A1" which now holds |
| the string “This is a MiniCalc text entry test”, |
| generated by the change detailed above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/function</B><BR> </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 1 columns 4 rows 4entries - |
| Spreadsheet palm function test. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_function.sxc</B>. |
| |
| </P> |
| <P>Convert c_function.sxc to c_function.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_function.pdb. <BR>Choose Cell Reference "A1" |
| with mouse, tap standard function option on palm, choose the |
| function AVERAGE from the popup list by tapping, type the values |
| “1;2;3” between the function brackets on the dotted |
| line were the cursor is placed and press return.<BR>Export the doc |
| back to c_function.pdb. <BR>Merge c_function.pdb to |
| c_function.sxc. |
| </P> |
| <P>A1 = AVERAGE(1;2;3) = 2.</P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| all original sheet values, except "A1" which now holds |
| the result of the average function given args (1;2;3) = 2 |
| generated by the change detailed above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/numberpad</B><BR> </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 1 columns 4 rows 4entries - |
| Spreadsheet palm numberpad test. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_numberpad.sxc</B>. |
| |
| </P> |
| <P>Convert c_numberpad.sxc to c_numberpad.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_numberpad.pdb. <BR>Choose Cell Reference "A1" |
| with mouse, tap the “123” option on the palm, tap |
| “->”, “=”, “5-0+2” from |
| popup numberpad, and press return.<BR>Export the doc back to |
| c_numberpad.pdb. <BR>Merge c_numberpad.pdb to |
| c_numberpad.sxc. |
| </P> |
| <P>A1 = 5-0+2 = 7.</P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| all original sheet values, except "A1" which now holds |
| the result of the formula 5-0+2, generated by the change detailed |
| above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/math_funcs</B></P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 1 columns 4 rows 4entries - |
| Spreadsheet palm numberpad test. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_math_funcs.sxc</B>. |
| |
| </P> |
| <P>Convert c_math_funcs.sxc to c_math_funcs.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_math_funcs.pdb. <BR>Choose the Cell References below with |
| mouse,and for each type on the palm the corresponding entry before |
| pressing return.</P> |
| <P>A1 = <BR>Export the doc back to c_math_funcs.pdb. <BR>Merge |
| c_math_funcs.pdb to c_math_funcs.sxc. |
| </P> |
| <P>A1 = .</P> |
| <P>A2 =</P> |
| <P>A3 = |
| </P> |
| <P>A4 =</P> |
| <P><BR><BR> |
| </P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| all original sheet values, except "A1" which now holds |
| the result of the formula 5-0+2, generated by the change detailed |
| above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/insertrow</B><BR> </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 1 columns 4 rows 4entries - |
| Spreadsheet palm insert row test. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_insertrow.sxc</B>. |
| |
| </P> |
| <P>Convert c_insertrow.sxc to c_insertrow.pdb, in MiniCalc PDB |
| format. <BR>Start POSE with MiniCalc application and import |
| c_insertrow.pdb. </P> |
| <P><BR>Select Cell Reference "A3" with mouse, tap the |
| side bar of the spreadsheet at position 3 on the palm, tap |
| “Insert” from popup menu, and press return. Select the |
| newly inserted Cell Reference with mouse and enter the number “2”, |
| press return.<BR><BR><BR> |
| </P> |
| <P>Export the doc back to c_insertrow.pdb. <BR>Merge |
| c_insertrow.pdb to c_insertrow.sxc. |
| </P> |
| <P>A1 = .</P> |
| <P><B>Expected result:</B> <BR> Spreadsheet should display |
| all original sheet values, except "A1" which now holds |
| the result of the formula 5-0+2, generated by the change detailed |
| above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><B>minicalc/convert/content/multi_boolean</B></P> |
| </TD> |
| <TD WIDTH=584> |
| <P><B>Summary</B>: Spreadsheet with 1 column 8 entries - |
| Spreadsheet multi boolean entry. |
| </P> |
| <P><B>Procedure:</B> <BR>Use test file <B>c_multi_boolean.sxc</B>. |
| |
| </P> |
| <P>Convert c_multi_boolean.sxc to c_multi_boolean.pdb, in MiniCalc |
| PDB format. <BR>Start POSE with MiniCalc application and |
| import c_multi_boolean.pdb. <BR>Export the doc back to |
| c_multi_boolean.pdb. <BR>Merge c_multi_boolean.pdb to |
| c_multi_boolean.sxc. |
| </P> |
| <P>Logical Funtion test : cells A1-A4: |
| </P> |
| <P>A1-A4 = FALSE |
| </P> |
| <P>A5-A8 = TRUE |
| </P> |
| <P>Returns 4 logical FALSE & TRUE values resp.. |
| </P> |
| <P><B>Expected result:</B> <BR> The logical entry of each |
| cell should be displayed on the sheet as stated above.</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=431> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=584> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| </TABLE> |
| <P><BR> <BR> <BR> |
| </P> |
| </BODY> |
| </HTML> |
