phpWebSheet 0.1.2_b3 Online Help

Credits

Norbert F. and Christian D.

License:

This library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version.

This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details.

You should have received a copy of the GNU Lesser General Public License along with this library; if not, write to the Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA

Editing

How to enter/change cell contents

Choose Editor; Click on the cell, edit contents in the textfield and click the 'Set' button.

How to insert/delete a row

Click on the row header; The system will change to 'Cut/Copy'-mode; Click 'Ins V' or 'Del V' (vertical).

How to insert/delete a column

Click on the row header; The system will change to 'Cut/Copy'-mode; Click 'Ins H' or 'Del H' (horizontal).

How to undo the last change

Go to 'Tools'. Click 'Undo'

How to delete/cut/copy ranges

Switch to 'Cut/Copy' mode. Click on the first corner of the range, then on the opposite corner. Press cut/delete or copy button; Select the cell you want to paste to; Click paste.

Text Styles

Emphasis:
    ''italics'' 
    *bold*               
	
    (correct: *hello* world; wrong: *hello*world - the space is significant)
	
	
Headings:
    == Title ==
	
    (correct: == Title ==; wrong: ==Title==)

Borders

    t|   top border
    l|   left border
    r|   right border
    b|   bottom border
	
    (correct: t|l|My text; wrong: My t|l| text. put border styles at the beginning without leading spaces)
	

Cell Formulas

Formulas always begin with an equation character. For instance
=A1+B1

Functions:
    sum(range)                   e.g. =sum(E1:F5)
    min(range)                   minimum value
    max(range)                   maximum value
    avg(range)                   average value
    listrange(range)             list the values in the range
	
Operators:
    +,-,*,/
    (, )
	
Functions may be combined with Text and Border styles:  b|*=sum(A1:A3)* 	
	

---