You can access the current sheet properties either by right clicking on the sheet tab and choosing Sheet Properties or by using the ->-> menu. Please note that you can only access the Sheet Properties when the document or the sheet is not protected.
You can set different properties that will be valid in the current sheet. Clicking on will validate your changes and will bring back the default settings.
Let you choose the sheet orientation. Default is that the first column of the sheet is on the left. If you choose Right to Left, then the first column will be on the right and the others added from right to left.
If this box is checked any cell containing the value zero will appear blank.
This setting controls whether formulae are recalculated automatically when the value of any cell they refer to changes.
If this box is checked the column headings will show as numbers rather than as letters. Letters are default.
If this box is checked the cell reference shown at the left end of the Formula Bar will be displayed in LC mode (i.e. L2C3) rather than in its normal form B3. This does not seem to be of much use at the moment.
Check this box and the first letter of any text you type in will automatically be converted to uppercase.
If checked the grid (the cell limits) will be shown. This is default. If you uncheck it, the grid will be hidden.
If you check this option, the page borders will be drawn on your current sheet. Per default the page borders are not displayed. It is useful to see the page borders if you want to print your sheet.
If this box is checked KSpread will display the actual formulae in cells rather than the results.
If this box is checked KSpread will display a small blue triangle at the bottom left corner of cells containing formulae. This is useful if you want to protect cells with formulae.
If this box is checked cells containing comments will be marked by a small red triangle at the top right corner.
Would you like to comment or contribute an update to this page?
Send feedback to the TDE Development Team