diff options
Diffstat (limited to 'xmerge/java/org/openoffice/xmerge/converter/palm/palmtests/qa/test_spec/convertor_test_spec.html')
| -rw-r--r-- | xmerge/java/org/openoffice/xmerge/converter/palm/palmtests/qa/test_spec/convertor_test_spec.html | 2274 |
1 files changed, 0 insertions, 2274 deletions
diff --git a/xmerge/java/org/openoffice/xmerge/converter/palm/palmtests/qa/test_spec/convertor_test_spec.html b/xmerge/java/org/openoffice/xmerge/converter/palm/palmtests/qa/test_spec/convertor_test_spec.html deleted file mode 100644 index 5b77f3263654..000000000000 --- a/xmerge/java/org/openoffice/xmerge/converter/palm/palmtests/qa/test_spec/convertor_test_spec.html +++ /dev/null @@ -1,2274 +0,0 @@ -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> -<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>
\ No newline at end of file |