Secret StarWars games

Basic Functions: FIXED

In OpenOffice Calc, the FIXED function returns a text representation of a number rounded to a specified number of decimal places.

The arguments to the function are:

FIXED(number, decimal_places, no_commas)
where

· number … is the number to round.

· decimal_places is the number of decimal places to display in the result.

· no_commas If this parameter is set to TRUE, the result will not display commas. If it is set to FALSE, it will display commas in the result.

We see a few examples of the FIXED function below.

This entry was posted on Sunday, September 25th, 2005 at 11:35 am and

Paste Special II - Removing formulae

September 20th, 2005

The paste special feature is useful for preserving the values in a spreadsheet - but removing the formulae that generated those values. This may be required to preserve proprietary equations.

To remove the formulae for a range of cells, select and copy the desired range. Do not unselect the range. Now click on Edit - Paste Special - see below.

Make sure the Formulas box is unchecked. After you click OK, the formula is removed but the value is preserved.

Posted in Using OpenOffice Calc | No Comments»

Secret StarWars games

September 16th, 2005

Open Office Calc has an interesting Easter egg - a hidden feature that might not be obvious or documented. Programmers sometimes bury Easter Eggs in their programs or web sites to add extra depth and challenge users to find them.

In an empty cell, type the following formula.. =GAME(”StarWars”)
This is what you will see…

After you have selected your hero, the game begins. Another screen shot…

You can only play the game once. To play again - exit OOo Calc and the quickstarter before restarting.

Posted in Using OpenOffice Calc | No Comments»

Дата добавления: 2015-11-16