I am using the top row of an HTML table as a 'copy down' control row. So you can over-ride the values in the rows you've selected below (each row has a check box - similar to the phpMyAdmin interface) when you click a button in the top row that says 'Copy down'.
However if you don't only want to over-ride some of the values the other boxes have to have some way of showing that they are not-applicable.
- All the inputs are numbers in text boxes
- I started by just putting 'n/a' in the text boxes
- This didn't work as it can be confused with not available which is a valid thing to copy down
- currently they are just blank by default - but there is now a problem as the rows below will now also have blanks in them by default. So the blank value could imply setting the inputs below to be blank.