Tips & tricks: PlanMaker
Localized function names
Microsoft Excel uses localized function names and so does PlanMaker when you switch on a user interface language other than English. For example, the English SUM function is called SOMME in French, SUMA in Spanish and Сумм in Russian.
As the English PlanMaker manual lists only the English function names, you might need to look up localized function names. This PlanMaker .pmdx file contains a cross-reference of all PlanMaker functions.
Inserting the current date and time
Question: I want to insert the current date or time into a worksheet. I do not want to use the functions TODAY() and NOW() because they are continuously updated.
Answer: Press Ctrl+. for the date and Ctrl+Shift+. for the time.
Changing the zoom level with the mouse
If you use a mouse with a scroll wheel, you can use it to quickly change the zoom level at which a worksheet is displayed. Press the Ctrl key on your keyboard, keep it depressed and move the scroll wheel on your mouse up or down.
Multiple currencies in a worksheet
In contrast to other spreadsheet programs, PlanMaker lets you use any number of different currencies in each worksheet.
To display a number as a currency amount, select the cells which should be formatted, right-click on the selected area and choose the entry Cell from the context menu. In the dialog that now appears, select the number format Currency and pick the desired currency (such as Euro, Swiss francs or US Dollar).
You can also simply enter a number with a currency symbol. For example, if you type € 42 or 19.50 € in a cell, PlanMaker recognizes automatically that this is a Euro amount and formats it in the currency format "€".
Combining two columns into one
Question: I have a worksheet in which area codes (for example 123) are stored in column A and phone numbers (for example 456-7890) in column B. I want to combine them as "123-456-7890" in a new column.
Answer: Enter the formula =A1&"-"&B1 in cell C1, then copy this formula to the cells below as many times as you have phone numbers.
Now you have the combined phone numbers, but only as formulas. If you want to convert them to literal values, select the new formulas and copy them with Home | Copy to the clipboard. Leave the formulas selected and execute the command Home | Paste | Paste values. Now your worksheet contains the phone numbers as literal values.