summaryrefslogtreecommitdiff
path: root/help/sheetqt
Side-by-side diff
Diffstat (limited to 'help/sheetqt') (more/less context) (show whitespace changes)
-rw-r--r--help/sheetqt/about.html6
-rw-r--r--help/sheetqt/accept.pngbin0 -> 326 bytes
-rw-r--r--help/sheetqt/cellselect.pngbin0 -> 357 bytes
-rw-r--r--help/sheetqt/comma.pngbin0 -> 252 bytes
-rw-r--r--help/sheetqt/enterdata.html11
-rw-r--r--help/sheetqt/equal.pngbin0 -> 218 bytes
-rw-r--r--help/sheetqt/function.pngbin0 -> 287 bytes
-rw-r--r--help/sheetqt/menudata.html7
-rw-r--r--help/sheetqt/menuedit.html13
-rw-r--r--help/sheetqt/menufile.html10
-rw-r--r--help/sheetqt/menuformat.html16
-rw-r--r--help/sheetqt/menuhelp.html7
-rw-r--r--help/sheetqt/menuinsert.html10
-rw-r--r--help/sheetqt/paran.pngbin0 -> 231 bytes
-rw-r--r--help/sheetqt/sheetqt.pngbin0 -> 16733 bytes
15 files changed, 80 insertions, 0 deletions
diff --git a/help/sheetqt/about.html b/help/sheetqt/about.html
new file mode 100644
index 0000000..8bb2925
--- a/dev/null
+++ b/help/sheetqt/about.html
@@ -0,0 +1,6 @@
+<html><head><title>Opie Sheet Help</title></head><body>
+<h2> About</h2>
+Opie Sheet is a complete spreadsheet application for Opie. It provides enhanced formula evaluation, formatted output, and other nice features that should be supported by a complete spreadsheet application software.
+<p>
+Development of Opie Sheet was started by Serdar Ozler in December 2001 to enter to the Qtopia Worldwide Developer Contest. Its name was Sheet/Qt in the contest.
+</body></html>
diff --git a/help/sheetqt/accept.png b/help/sheetqt/accept.png
new file mode 100644
index 0000000..6c0cfbe
--- a/dev/null
+++ b/help/sheetqt/accept.png
Binary files differ
diff --git a/help/sheetqt/cellselect.png b/help/sheetqt/cellselect.png
new file mode 100644
index 0000000..6ae4066
--- a/dev/null
+++ b/help/sheetqt/cellselect.png
Binary files differ
diff --git a/help/sheetqt/comma.png b/help/sheetqt/comma.png
new file mode 100644
index 0000000..c87869b
--- a/dev/null
+++ b/help/sheetqt/comma.png
Binary files differ
diff --git a/help/sheetqt/enterdata.html b/help/sheetqt/enterdata.html
new file mode 100644
index 0000000..0896224
--- a/dev/null
+++ b/help/sheetqt/enterdata.html
@@ -0,0 +1,11 @@
+<html><head><title>Opie Sheet Help</title></head><body>
+<h2> Entering Formulas</h2>
+For example, to calculate average of the cells in the range A1:B3, you must enter the data as '=AVG(A1,B3)' (without quotes). And it can be done without using any keyboard by using the following procedure:
+<ol type="1">
+<li>Click the cell, which will show the result.</li>
+<li>Click the <img src="equal.png"> button.</li>
+<li>Select Average function from the Statistical menu, which will appear when you click the <img src="function.png"> button.</li>
+<li>Activate the Cell Selector by clicking the <img src="cellselect.png"> button, press on the cell A1 and release on the cell B3.</li>
+<li>Click the <img src="paran.png"> button.</li>
+<li>Click the <img src="accept.png"> button.</li>
+</ol></body></html>
diff --git a/help/sheetqt/equal.png b/help/sheetqt/equal.png
new file mode 100644
index 0000000..6fd588c
--- a/dev/null
+++ b/help/sheetqt/equal.png
Binary files differ
diff --git a/help/sheetqt/function.png b/help/sheetqt/function.png
new file mode 100644
index 0000000..bb097e2
--- a/dev/null
+++ b/help/sheetqt/function.png
Binary files differ
diff --git a/help/sheetqt/menudata.html b/help/sheetqt/menudata.html
new file mode 100644
index 0000000..09e84b2
--- a/dev/null
+++ b/help/sheetqt/menudata.html
@@ -0,0 +1,7 @@
+<html><head><title>Opie Sheet Help</title></head><body>
+<h2> Data Menu</h2>
+One can do some important data processing by using the items of this menu.
+<p><ul>
+<li><b>Sort:</b> Sorts the data in the current cell selection.</li>
+<li><b>Find & Replace:</b> Finds data in the current sheet or cell selection and replaces it according to the user's requirements.</li>
+</ul></body></html>
diff --git a/help/sheetqt/menuedit.html b/help/sheetqt/menuedit.html
new file mode 100644
index 0000000..6df364f
--- a/dev/null
+++ b/help/sheetqt/menuedit.html
@@ -0,0 +1,13 @@
+<html><head><title>Opie Sheet Help</title></head><body>
+<h2> Edit Menu</h2>
+One can find some editing functions of Opie Sheet such as Copy, Paste, etc in this menu.
+<p><ul>
+<li><b>Accept:</b> Stores new entered data in the data editor into the cell.</li>
+<li><b>Cancel:</b> Ignores the new entered data in the data editor.</li>
+<li><b>Cell Selector:</b> A very useful utility for selecting cells. For example, to enter A1,B3 as data, you can click this item, press on the cell A1 and release on the cell B3. 'A1,B3' (without quotes) will be written to the data editor automatically.</li>
+<li><b>Cut:</b> Copies the contents of the current cell selection into buffer and deletes its contents.</li>
+<li><b>Copy:</b> Copies the contents of the current cell selection into buffer.</li>
+<li><b>Paste:</b> Pastes the data in the buffer into the current cell.</li>
+<li><b>Paste Contents:</b> Pastes only the contents (excluding cell formatting) in the buffer into the current cell.</li>
+<li><b>Clear:</b> Deletes the contents of the current cell selection.</li>
+</ul></body></html>
diff --git a/help/sheetqt/menufile.html b/help/sheetqt/menufile.html
new file mode 100644
index 0000000..dd72687
--- a/dev/null
+++ b/help/sheetqt/menufile.html
@@ -0,0 +1,10 @@
+<html><head><title>Opie Sheet Help</title></head><body>
+<h2> File Menu</h2>
+One can find basic file and application operations in this menu.
+<p><ul>
+<li><b>New:</b> Creates a new document with 3 empty sheets.</li>
+<li><b>Open:</b> Loads a previously saved document.</li>
+<li><b>Save:</b> Saves the current document.</li>
+<li><b>Save As:</b> Saves the current document by using a new name.</li>
+<li><b>Quit:</b> Closes Opie Sheet and returns to the Opie environment.</li>
+</ul></body></html>
diff --git a/help/sheetqt/menuformat.html b/help/sheetqt/menuformat.html
new file mode 100644
index 0000000..17c58a5
--- a/dev/null
+++ b/help/sheetqt/menuformat.html
@@ -0,0 +1,16 @@
+<html><head><title>Opie Sheet Help</title></head><body>
+<h2> Format Menu</h2>
+One can format cells, rows, and columns in the current sheet and sheets in the current document by using the items of this menu.
+<p><ul>
+<li><b>Cells:</b> Changes the format of the current cell selection.</li>
+<li><b>Row -> Height:</b> Changes the height of the rows in the selection.</li>
+<li><b>Row -> Adjust:</b> Adjusts the height of the rows in the selection automatically.</li>
+<li><b>Row -> Show:</b> Shows the hidden rows in the selection.</li>
+<li><b>Row -> Hide:</b> Hides all rows in the selection.</li>
+<li><b>Column -> Width:</b> Changes the width of the columns in the selection.</li>
+<li><b>Column -> Adjust:</b> Adjusts the width of the columns in the selection automatically.</li>
+<li><b>Column -> Show:</b> Shows the hidden columns in the selection.</li>
+<li><b>Column -> Hide:</b> Hides all columns in the selection.</li>
+<li><b>Sheet -> Rename:</b> Renames the current sheet.</li>
+<li><b>Sheet -> Remove:</b> Removes the current sheet from the document.</li>
+</ul></body></html>
diff --git a/help/sheetqt/menuhelp.html b/help/sheetqt/menuhelp.html
new file mode 100644
index 0000000..8d3ffcb
--- a/dev/null
+++ b/help/sheetqt/menuhelp.html
@@ -0,0 +1,7 @@
+<html><head><title>Opie Sheet Help</title></head><body>
+<h2> Help Menu</h2>
+One can find standard help menu items in this menu.
+<p><ul>
+<li><b>General:</b> Shows this help.</li>
+<li><b>About:</b> Shows the about dialog.</li>
+</ul></body></html>
diff --git a/help/sheetqt/menuinsert.html b/help/sheetqt/menuinsert.html
new file mode 100644
index 0000000..1dfa370
--- a/dev/null
+++ b/help/sheetqt/menuinsert.html
@@ -0,0 +1,10 @@
+<html><head><title>Opie Sheet Help</title></head><body>
+<h2> Insert Menu</h2>
+One can insert new elements to the sheet and functions to the data editor by using the items of this menu.
+<p><ul>
+<li><b>Function:</b> Inserts names of supported functions including some mathematical and statistical functions into the data editor.</li>
+<li><b>Cells:</b> Inserts cells to the current sheet.</li>
+<li><b>Rows:</b> Inserts rows to the current sheet.</li>
+<li><b>Columns:</b> Inserts columns to the current sheet.</li>
+<li><b>Sheets:</b> Inserts sheets to the current document.</li>
+</ul></body></html>
diff --git a/help/sheetqt/paran.png b/help/sheetqt/paran.png
new file mode 100644
index 0000000..e082706
--- a/dev/null
+++ b/help/sheetqt/paran.png
Binary files differ
diff --git a/help/sheetqt/sheetqt.png b/help/sheetqt/sheetqt.png
new file mode 100644
index 0000000..62bc514
--- a/dev/null
+++ b/help/sheetqt/sheetqt.png
Binary files differ