|
Draw Cell Borders |
|
2000.09.18 |
http://www.barefeetware.com/appleworks/cell_borders/ |
|
Description |
This AppleWorks script draws lines as borders on the selected cells. It asks for the desired thickness of those lines. |
|
Enhancement |
This is one of 40 scripts in the Enhancement Pack for AppleWorks. |
|
Detail
The Draw Cell Borders item is in the Spreadsheet sub-menu of AppleWorks Scripts menu. This feature compensates for the lack of control in AppleWorks over the thickness of cell borders in a spreadsheet. AppleWorks 6 can set the width of table borders. Unfortunately tables are a whole new module introduced in AppleWorks 6, rather than the hoped for enhancement of the existing spreadsheet frames.Sample
To use:
- Finish adjusting the sizes (row height and column width) of the cells in your spreadsheet.
- Select some cells.
- Select Draw Cell Borders item in the Spreadsheet sub-menu of AppleWorks Scripts menu.
- Enter the required width of the borders (in pixels). Click OK.
- You can select the border lines and apply color, thickness and patterns as desired.
Ensure that your cell dimensions are set before running this script, as the position of the lines is not tied to the cells.Requirements
Operates on the selected cells in a spreadsheet document (not a frame).Download
This script works with AppleWorks 6 and AppleWorks 5.
Only registered users are permitted to use the supplied files after 14 days or edit them.
This script is included in the Enhancement Pack for AppleWorks, not supplied separately.Scripting
This script is read only. The statements that get the dimensions of the selected cells are:Please email us any queries about this page.
set theCells to object specifier of selection
tell theCells
set rowFirstN to index of row 1 in column 1
set colFirstN to index of column 1 in row 1
set cellHeights to {} & height of rows in column 1
set cellWidths to {} & width of columns in row 1
end tell