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