R-Gnumeric Examples

This is a collection of examples of the R-Gnumeric plugin. The simplest way to view them is to set the environment variable R_GNUMERIC_PROFILE to Profile

An sample profile for registering functions. Another sample profile A test of accessing cells from R Simple regression example with output in a new sheet. lm.S & lm A test of the GnumericCellRef class A test of the inadvisable defining new functions in a spreadsheet itself. This, of course, can create circularities in the sheet and repeated definitions each time the cells are re-calculated. An example of the different call features. A test of the formatting of a cell Example of using a graphics device as a separate window, connected to the calculations in the spreadsheet. Simple example of displaying the result of a regression in a separate worksheet. This mirrors the regression tool in the standard gnumeric, and shows how easy it is to export statistical functionality. Testing the ability to create a new sheet within a workbook. Testing the ability to remove a sheet within a workbook I think this fails. Tests the indexing in R of sheets within a workbook reference This uses the familiar [ operator to index a sheet by number of name. Test of the [<- operator for sheet references This checks we can assign into cells from R. Tests the CellRef class Uses the [[ operator to get a cell reference and then queries and sets the different attributes such as alignment, etc. List of registered functions A list of the registered functions displayed in a worksheet.
Another sample profile A test of accessing cells from R Simple regression example with output in a new sheet. lm.S & lm A test of the GnumericCellRef class A test of the inadvisable defining new functions in a spreadsheet itself. This, of course, can create circularities in the sheet and repeated definitions each time the cells are re-calculated. An example of the different call features. A test of the formatting of a cell Example of using a graphics device as a separate window, connected to the calculations in the spreadsheet. Simple example of displaying the result of a regression in a separate worksheet. This mirrors the regression tool in the standard gnumeric, and shows how easy it is to export statistical functionality. Testing the ability to create a new sheet within a workbook. Testing the ability to remove a sheet within a workbook I think this fails. Tests the indexing in R of sheets within a workbook reference This uses the familiar [ operator to index a sheet by number of name. Test of the [<- operator for sheet references This checks we can assign into cells from R. Tests the CellRef class Uses the [[ operator to get a cell reference and then queries and sets the different attributes such as alignment, etc. List of registered functions A list of the registered functions displayed in a worksheet.
A test of accessing cells from R Simple regression example with output in a new sheet. lm.S & lm A test of the GnumericCellRef class A test of the inadvisable defining new functions in a spreadsheet itself. This, of course, can create circularities in the sheet and repeated definitions each time the cells are re-calculated. An example of the different call features. A test of the formatting of a cell Example of using a graphics device as a separate window, connected to the calculations in the spreadsheet. Simple example of displaying the result of a regression in a separate worksheet. This mirrors the regression tool in the standard gnumeric, and shows how easy it is to export statistical functionality. Testing the ability to create a new sheet within a workbook. Testing the ability to remove a sheet within a workbook I think this fails. Tests the indexing in R of sheets within a workbook reference This uses the familiar [ operator to index a sheet by number of name. Test of the [<- operator for sheet references This checks we can assign into cells from R. Tests the CellRef class Uses the [[ operator to get a cell reference and then queries and sets the different attributes such as alignment, etc. List of registered functions A list of the registered functions displayed in a worksheet.
Simple regression example with output in a new sheet. lm.S & lm A test of the GnumericCellRef class A test of the inadvisable defining new functions in a spreadsheet itself. This, of course, can create circularities in the sheet and repeated definitions each time the cells are re-calculated. An example of the different call features. A test of the formatting of a cell Example of using a graphics device as a separate window, connected to the calculations in the spreadsheet. Simple example of displaying the result of a regression in a separate worksheet. This mirrors the regression tool in the standard gnumeric, and shows how easy it is to export statistical functionality. Testing the ability to create a new sheet within a workbook. Testing the ability to remove a sheet within a workbook I think this fails. Tests the indexing in R of sheets within a workbook reference This uses the familiar [ operator to index a sheet by number of name. Test of the [<- operator for sheet references This checks we can assign into cells from R. Tests the CellRef class Uses the [[ operator to get a cell reference and then queries and sets the different attributes such as alignment, etc. List of registered functions A list of the registered functions displayed in a worksheet.
A test of the GnumericCellRef class A test of the inadvisable defining new functions in a spreadsheet itself. This, of course, can create circularities in the sheet and repeated definitions each time the cells are re-calculated. An example of the different call features. A test of the formatting of a cell Example of using a graphics device as a separate window, connected to the calculations in the spreadsheet. Simple example of displaying the result of a regression in a separate worksheet. This mirrors the regression tool in the standard gnumeric, and shows how easy it is to export statistical functionality. Testing the ability to create a new sheet within a workbook. Testing the ability to remove a sheet within a workbook I think this fails. Tests the indexing in R of sheets within a workbook reference This uses the familiar [ operator to index a sheet by number of name. Test of the [<- operator for sheet references This checks we can assign into cells from R. Tests the CellRef class Uses the [[ operator to get a cell reference and then queries and sets the different attributes such as alignment, etc. List of registered functions A list of the registered functions displayed in a worksheet.
A test of the inadvisable defining new functions in a spreadsheet itself. This, of course, can create circularities in the sheet and repeated definitions each time the cells are re-calculated. An example of the different call features. A test of the formatting of a cell Example of using a graphics device as a separate window, connected to the calculations in the spreadsheet. Simple example of displaying the result of a regression in a separate worksheet. This mirrors the regression tool in the standard gnumeric, and shows how easy it is to export statistical functionality. Testing the ability to create a new sheet within a workbook. Testing the ability to remove a sheet within a workbook I think this fails. Tests the indexing in R of sheets within a workbook reference This uses the familiar [ operator to index a sheet by number of name. Test of the [<- operator for sheet references This checks we can assign into cells from R. Tests the CellRef class Uses the [[ operator to get a cell reference and then queries and sets the different attributes such as alignment, etc. List of registered functions A list of the registered functions displayed in a worksheet.: This, of course, can create circularities in the sheet and repeated definitions each time the cells are re-calculated.
An example of the different call features. A test of the formatting of a cell Example of using a graphics device as a separate window, connected to the calculations in the spreadsheet. Simple example of displaying the result of a regression in a separate worksheet. This mirrors the regression tool in the standard gnumeric, and shows how easy it is to export statistical functionality. Testing the ability to create a new sheet within a workbook. Testing the ability to remove a sheet within a workbook I think this fails. Tests the indexing in R of sheets within a workbook reference This uses the familiar [ operator to index a sheet by number of name. Test of the [<- operator for sheet references This checks we can assign into cells from R. Tests the CellRef class Uses the [[ operator to get a cell reference and then queries and sets the different attributes such as alignment, etc. List of registered functions A list of the registered functions displayed in a worksheet.
A test of the formatting of a cell Example of using a graphics device as a separate window, connected to the calculations in the spreadsheet. Simple example of displaying the result of a regression in a separate worksheet. This mirrors the regression tool in the standard gnumeric, and shows how easy it is to export statistical functionality. Testing the ability to create a new sheet within a workbook. Testing the ability to remove a sheet within a workbook I think this fails. Tests the indexing in R of sheets within a workbook reference This uses the familiar [ operator to index a sheet by number of name. Test of the [<- operator for sheet references This checks we can assign into cells from R. Tests the CellRef class Uses the [[ operator to get a cell reference and then queries and sets the different attributes such as alignment, etc. List of registered functions A list of the registered functions displayed in a worksheet.
Example of using a graphics device as a separate window, connected to the calculations in the spreadsheet. Simple example of displaying the result of a regression in a separate worksheet. This mirrors the regression tool in the standard gnumeric, and shows how easy it is to export statistical functionality. Testing the ability to create a new sheet within a workbook. Testing the ability to remove a sheet within a workbook I think this fails. Tests the indexing in R of sheets within a workbook reference This uses the familiar [ operator to index a sheet by number of name. Test of the [<- operator for sheet references This checks we can assign into cells from R. Tests the CellRef class Uses the [[ operator to get a cell reference and then queries and sets the different attributes such as alignment, etc. List of registered functions A list of the registered functions displayed in a worksheet.
Simple example of displaying the result of a regression in a separate worksheet. This mirrors the regression tool in the standard gnumeric, and shows how easy it is to export statistical functionality. Testing the ability to create a new sheet within a workbook. Testing the ability to remove a sheet within a workbook I think this fails. Tests the indexing in R of sheets within a workbook reference This uses the familiar [ operator to index a sheet by number of name. Test of the [<- operator for sheet references This checks we can assign into cells from R. Tests the CellRef class Uses the [[ operator to get a cell reference and then queries and sets the different attributes such as alignment, etc. List of registered functions A list of the registered functions displayed in a worksheet.: This mirrors the regression tool in the standard gnumeric, and shows how easy it is to export statistical functionality.
Testing the ability to create a new sheet within a workbook. Testing the ability to remove a sheet within a workbook I think this fails. Tests the indexing in R of sheets within a workbook reference This uses the familiar [ operator to index a sheet by number of name. Test of the [<- operator for sheet references This checks we can assign into cells from R. Tests the CellRef class Uses the [[ operator to get a cell reference and then queries and sets the different attributes such as alignment, etc. List of registered functions A list of the registered functions displayed in a worksheet.
Testing the ability to remove a sheet within a workbook I think this fails. Tests the indexing in R of sheets within a workbook reference This uses the familiar [ operator to index a sheet by number of name. Test of the [<- operator for sheet references This checks we can assign into cells from R. Tests the CellRef class Uses the [[ operator to get a cell reference and then queries and sets the different attributes such as alignment, etc. List of registered functions A list of the registered functions displayed in a worksheet.: I think this fails.
Tests the indexing in R of sheets within a workbook reference This uses the familiar [ operator to index a sheet by number of name. Test of the [<- operator for sheet references This checks we can assign into cells from R. Tests the CellRef class Uses the [[ operator to get a cell reference and then queries and sets the different attributes such as alignment, etc. List of registered functions A list of the registered functions displayed in a worksheet.: This uses the familiar [ operator to index a sheet by number of name.
Test of the [<- operator for sheet references This checks we can assign into cells from R. Tests the CellRef class Uses the [[ operator to get a cell reference and then queries and sets the different attributes such as alignment, etc. List of registered functions A list of the registered functions displayed in a worksheet.: This checks we can assign into cells from R.
Tests the CellRef class Uses the [[ operator to get a cell reference and then queries and sets the different attributes such as alignment, etc. List of registered functions A list of the registered functions displayed in a worksheet.: Uses the [[ operator to get a cell reference and then queries and sets the different attributes such as alignment, etc.
List of registered functions A list of the registered functions displayed in a worksheet.: A list of the registered functions displayed in a worksheet.

Last modified: Mon Nov 11 10:29:57 UTC 2002