Add useful functions for table rows and columns
UPDATE: Now supports commas for decimal places too!
Adds some useful functions to tables.
When you have a table you want to work on, click the 'Totalizer' icon in the toolbar. When it lights up, you can now right click on a table row or column and choose a simple spreadsheet function from the following:
- Sum (calculate the total)
- Average (work out the average)
- Min (find the smallest or most negative value)
- Max (find the biggest value)
- Count (count the number of values in the row/column)
The result will be added to the end of the row or column.
The 'Exclude Cell' option can be used to remove cells from the function if required. 'Exclude All' does the same thing for each cell in the current row or column. Both can be undone by repeating. 'Clear' will remove all functions from the table.
Note: This obviously works best with rows/columns containing numeric values! Anything that's not a digit, '+', '-', ',' or '.' will be ignored. Results are displayed to two decimal places.
- Add user functions, eg A1+B2, etc.
- Add column/row labels
- Export to CSV or google docs.
0.90 Now supports commas!
0.80 Add row support
Recalculates when excluding cells
0.71 Updated to manifest v.2
0.6 Fixed toggle logic to be much simpler
0.5 Added enable/disable button
0.4 Fixed a bug in column highlighting
0.3 Included cells highlighted on hover
Exclude row option added
Exclude is now a toggle
Better column selection
0.2 Updated description
0.1 First working version
Uses Joe Walnes's neat jquery context menu plugin (https://github.com/joewalnes/jquery-simple-context-menu).