Name/Version: ClipCalc/-Format v1.1
1st Release : 14.07.2002
Last Update : 21.07.2002

Short Description
Calculates and formats lists of values, which are situated in the clipboard.
ClipCalc can calculate +, -, x, /, ^, sqr (\), %, average.
Additional it can make time calculations (add/sub hours/minutes).
ClipFormat can format into flash, #.0, #.00 etc.
Additional ClipFormat can add currency symbols like EUR, $ etc.

Reason for the Development
These components are developed and parts of RemoteKeys.
A complete calculator based on these modules.

Note
Try the freeware tool RemoteKeys to see full function of these components.

Appearance
Language ..........: No
User Interface/Form: No
Input  by Interface: No
Input  by Attribute: Supported: see instructions
Input  by Clipboard: Required
Input  by Drag&Drop: No
Input  from Disk ..: No
Input, Other ......: No
Output by Interface: No
Output to Clipboard: Yes (only)
Output to Disk ....: No
Output by Drag&Drop: No
Output, Other .....: No

More Requirements
No

Instructions

Starting ClipCalc with attribute (parameter): ClipCalculator.exe [mod]

<mod> = (without): calculation (default)
<mod> = 1        : calculation + average calculation
<mod> = 2        : time calculation

Examples:
ClipCalc.exe
ClipCalc.exe 1

Starting ClipFormat with attribute, comma separated: ClipFormat.exe [frm[,sym]]

<frm> = (without): flash format (default)
<frm> = 0        : same
<frm> = -1       : un-formatted
<frm> = 1        : #.0
<frm> = 2        : #.00
<frm> = 3        : #.000
<sym> = (without): no symbol
<sym> = ...      : can include any text to add currency symbol
<sym> = del      : remove last symbol from list

Examples:
ClipFormat.exe
ClipFormat.exe 3
ClipFormat.exe 2,EUR

Try this example to see how the modules works:

- Fill some Excel cells with values.
  Important: The cells must be in a column!
- Mark the cells and select "Copy" in Excel to copy the cells into the clipboard.
- Open NotePad and select "Paste" to paste the Excel-Cells into the text-area.
- Start ClipCalc. It will finish itsself after some milli-sec. and there will be nothing to see/hear.
- Paste again the clipboard content into NotePad. You get the result of the calculation now.
- Start ClipFormat and Paste again into NotePad to see the formatted output.

Or try this:
Copy the following block into the clipbaord:

25
+5.5
-.5
/6
*2

Then start ClipCalc and paste the clipboard back into another application.

Or try this, same procedure as above:

200
*2.5%

Time Calculations:

If ClipCalc is started with parameter "2" or it finds colons in the calculation list, it will try
to make a time calculation.

Normaly the result of
1.45
1.46
is 2.91.

But if there are colons in the list like
1:45
1:46
the result will be 3:31.

The time calculation can work with "+" and "-" (or nothing for "+") only.

{End of instructions}

Limitations
Unknown

Special Thanks
N/A

Future Planning
No

Updates ClipCalc
1.0    14.07.02 > New: First Release
1.0.1  15.07.02 - Cor: "Can not open clip" fixed
1.1    21.07.02 > New: Expanded to time calculation

Updates ClipFormat
1.0    14.07.02 > New: First Release
1.0.1  15.07.02 - Cor: "Can not open clip" fixed
1.1    21.07.02 - Imp: Apaption to time calculation
